Postgresql – How to install a PostgreSQL client

postgresql

I have a PostgreSQL server setup on Box A. I want to connect to the server from Box B using psql. What do I need to install on Box B? I can't find a client installation binary for PostgreSQL. Or do I have to install the entire PostgreSQL distribution?

Best Answer

On Debian the package you are looking for is called postgresql-client and I guess it will be the same on Ubuntu.

Related Solutions

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

OK, got it from someone else. This query should do the trick:

select *
from pg_stat_activity
where datname = 'mydatabasename';

Ssh – can not connect via SSH to a remote Postgresql database

Check if the remote host allow tunneling. You can check with the client if the tunnel is refused with:

ssh -v -L 3333:myHost:5432 myUser@myHost

Best Answer

Related Solutions

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

Ssh – can not connect via SSH to a remote Postgresql database

Related Topic