Harshpreet, could you confirm the following
1. Version for ThingWorx, PostgreSQL?
2. Check if sufficient access rights are available on that folder
Here's the blog you want to check for more help on running script for postgre sql Troubleshooting Syntax Error when running postgresql set up scripts
Are all the scripts/downloads in the same partition as your installed postgresql db, tomcat, the ThingworxPlatform , and ThingworxPostgresqlStorage folders? They have to be in the same partition. Also grant all of the permissions on all folders.
Do you have access to pgadminIII? I would check to see if a tablespace thingworx got created, and if so - remove it; then check the ThingworxPostgresqlStorage folder and clean up the insides too before re-running the script.
You may also take a look at this Installation Script for Thingworx platform on Redhat/CentOS/Ubuntu
Hi Harshpreet Kaur,
This seems some generic error and I can find similar errors on Google.
Can you try to locate the libpq.so.rh-postgresql library file and see if it has required file permission and is on the same partition where scripts are available.
Thank you for help, i tried to figure out given answers but at last found the correct answer
While executing the bash file, some grant permissions were set by SELinux,
Resolution- 1) Go to path where bash file is placed thingworxPostgresDBSetup.sh i.e till install folder
2) Run command-> getenforce
3) If output is 'Enforcing' it means some permissions were set which needs to be unset
4) Run command-> setenforce 0
5) Now execute the bash file by login to the postgres user.