PostgreSQL

[cdbs]

Hi

I have tried to connect to my PostgreSQL databases via external tools, but was not able to do so.

I have seen that some tools can use ssh and/or http tunnels (for example http://www.navicat.com/ssh_tunnel.php) and would like to know if Siteground support these kind of connections?

Any help will be appreciated.

Many thanks

Willem

[kenny]

cPanel itself does not allow for managing remote PostgreSQL access, and on most of our servers PostgreSQL does not even listen for TCP connections.

It is possible for us to allow access of a particular user to a particular database, though. Just open a support ticket with the request, and let us know which IP address is to be granted access and what are the databases and pgsql users involved.

SSH tunnelling is not possible, since we do not provide SSH access to our shared hosting accounts. It is possible to get shell access on a VPS, or use some sort of HTTP tunelling script to access Postgre.

[cdbs]

Hi Kenny

After googling for HTTP tunnelling scripts I managed to figure things out. Thanks for pointing me in the right direction.

Willem