sql profiler for postgres

Highlighted
Silver 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

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

6 REPLIES 6
Highlighted
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/

Regards,
Dhananjay
Highlighted
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)

 

 

Highlighted
Silver Adventurer

Re: sql profiler for postgres

Capture.JPG

Highlighted
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.

Highlighted
Silver 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.

 

 

Highlighted
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.

Regards,
Dhananjay

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks