Trying to install sql profiler plugin, however it doesnt like my postgres install location. Any input would be great, is it looking for the bin folder?
It seems that might be some permission issue with the PostgreSQL server installation directory. Can you try to give bin directory path of your PostgreSQL server installation?
And also can you provide the output of below command.:
ls -ltrh /var/opt/rh/rh-postgresql95/
The sqlprofiler installer is asking for the installation directory of postgres. Even if you give the bin directory it will search for the installation files and give the same error.
Please check following points while installaling SQLprofiler :
1. The postgres installation directory specified is correct.
2. The installation dircectory is mounted properly. (If applicable)
The SQL profiler installation is asking for an already installed Postgres directory and not a directory where it can install it.
For installing SQL profiler you will require a postgres installed on the server upon which the sqlprofiler will get installed.
In your case as well the location "/var/opt/rh/rh-postgresql95" does not contain any postgres installation, thus you are facing the error.
The installation directory looks like :
[root@ip-172-31-42-131 opt]# ls -ltrh
drwxr-xr-x. 3 root daemon 23 Jun 6 15:09 doc
drwxr-xr-x. 6 root daemon 4.0K Jun 6 15:09 include
-rw-------. 1 root root 57K Jun 6 15:09 uninstall-db_server.dat
-rwx------. 1 root daemon 7.7M Jun 6 15:09 uninstall-db_server
-rw-------. 1 root root 15K Jun 6 15:09 uninstall-edbpgagent.dat
-rwx------. 1 root daemon 7.6M Jun 6 15:09 uninstall-edbpgagent
drwxr-xr-x. 7 root daemon 4.0K Jun 6 15:09 edbplus
drwxr-xr-x. 9 root daemon 162 Jun 6 15:10 client-v6
drwxr-xr-x. 6 root daemon 215 Jun 6 15:10 scripts
drwxr-xr-x. 6 root daemon 75 Jun 6 15:10 installer
drwxr-xr-x. 8 root daemon 4.0K Jun 6 15:10 share
drwxr-xr-x. 2 root daemon 4.0K Jun 6 15:10 bin
drwxr-xr-x. 3 root daemon 55 Jun 6 15:10 etc
-rw-------. 1 root root 12K Jun 6 15:10 uninstall-replication.dat
-rwx------. 1 root daemon 7.6M Jun 6 15:10 uninstall-replication
drwxr-xr-x. 4 root daemon 8.0K Jun 6 15:10 lib
-rw-------. 1 root root 6.6K Jun 6 15:10 uninstall-pgpool_extension.dat
-rwx------. 1 root daemon 7.6M Jun 6 15:10 uninstall-pgpool_extension
drwx------. 21 postgres postgres 4.0K Jun 21 07:54 data01
Let us know in case you have any issues further.
what constitutes a postgres installation, i have tried the directory that contains all of the pg_ files and still it does not like it.
When you execute "ps -ef | grep postgres " command on your server. You will find all the Postgres process and along with postmaster process. Postmaster process consists of PostgreSQL bin directory and data directory information. One directory prior to bin directory is the PostgreSQL installation directory. This is the simplest way to find the PostgreSQL installation directory if your PostgreSQL cluster is up and running.
Kindly refer below screenshot for the details of above explanation.
Hope this helps.