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?
Asked
Active
Viewed 2.5k times
15
-
What is the OS? Most Linux systems will offer client-only packages. – Sven Apr 04 '11 at 11:35
-
What is your OS: Linux, Windows, others? – Khaled Apr 04 '11 at 11:36
-
It's Ubuntu. I will look for a package then. – jason.ppdev Apr 04 '11 at 11:41
1 Answers
35
On Debian the package you are looking for is called postgresql-client and I guess it will be the same on Ubuntu.
Sven
- 99,533
- 15
- 182
- 228
-
Where do I put pg_hba.conf though? It's supposed to be under the data directory, but there is none in a client only setup. – jason.ppdev Apr 04 '11 at 14:06
-
You need pg_hba.conf only on the server side, not the client side. It defines which client might connect from where and how. – Sven Apr 04 '11 at 14:15