Re: Query regarding Infinite Cache

Thanks Peter. It works .

-----Original Message-----
From: Peter Geoghegan [mailto:peter@2ndquadrant.com]
Sent: Friday, August 05, 2011 4:54 PM
To: Chan, Mamatha Kagathi
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Query regarding Infinite Cache

Hi Mamatha,

On 4 August 2011 13:11,  <Mamatha_Kagathi_Chan@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