PostgreSQL Client Application
I would like to be able to connect to my PostgreSQL server in the office without having to always SSH to the server and then use the client on the server. Can I simply not use a client on my workstation and connect using:
Code:
psql -h 192.168.1.200 -d dbname |
Yes, you can just install postgresql rather than postgresql-server on your workstation. The package names will vary depending on what distro you are using, but the names I mentioned should be correct for fedora. This will provide you with the psql utility. You'll need to allow your workstation's IP to connect in pg_hba.conf also.
|
Looks like in my distribution (Arch Linux) there is no separate package between server / client. When I did a search on my workstation, I had the following installed:
Code:
[cmennens@tuna ~]$ pacman -Qs postgresql |
That's a shame. I guess, in that case, you could compile postgres from source, and delete the postgres binary from /usr/local/pgsql/bin/postgres ? That would remove the db server, but psql would still be in the bin directory. Alternatively you could look for third-party client software, I don't have any experience with that though.
|
All times are GMT -5. The time now is 08:17 AM. |