cancel
Showing results for 
Search instead for 
Did you mean: 

sql profiler for postgres

Level 3 Adventurer

sql profiler for postgres

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?  

 

profilererror.JPG

6 REPLIES
EDB Team Member

Re: sql profiler for postgres

Hi Matt,

 

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/

EDB Team Member

Re: sql profiler for postgres

Hi Matt,

 

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)

 

 

Level 3 Adventurer

Re: sql profiler for postgres

Capture.JPG

EDB Team Member

Re: sql profiler for postgres

Hi  MattGorham,

 

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

total 31M

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.

Level 3 Adventurer

Re: sql profiler for postgres

what constitutes a postgres installation,   i have tried the directory that contains all of the pg_  files and still it does not like it.

 

 

EDB Team Member

Re: sql profiler for postgres

Hi  MattGorham,

 

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. 

 

Screen Shot 2018-06-22 at 7.07.06 PM.png

 

Hope this helps.