Hi Mamatha, On 4 August 2011 13:11, <mamatha_kagathi_c...@dell.com> wrote: > I am basically an Oracle user and now I am exploring PostgreSQL. I have > successfully configured the server. Now if I want to access that server from > my machine, what is the process?? Is it like Oracle where I will have to > install the client or the concept is entirely different? Please help me in > setting up a client access on my machine(different from server machine) > using Psql for instance.
These sorts of questions are generally better handled by the pgsql-general mailing list. However, you'll have to: 1) Make a pg_hba.conf entry for the machine you'll be connecting from. 2) Set listen_addresses to listen on some IP or '*', rather than just on localhost. 3) Possibly make a new firewall rule. I hope that helps -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
