Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Kevin Grittner
Scott Marlowe wrote: >> -- Dear Ian Lea, i guess 10.0.0.1/24 is the same as 10.0.0.0/24 >> as the mask '24' means that the first 3 octets (24 bits from the >> left hand side) must match ie both mean simply 10.0.0.* > > Actually 10.0.0.0/24 means that the right hand 24 bits don't matter, > so

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Scott Marlowe
On Tue, Nov 3, 2009 at 1:53 AM, Shruthi A wrote: > Hi all, > > Thanks a lot for all your replies.  The problem is solved now.  This is the > correct thing to do:    listen_addresses = '*' > And then restart the service. > > Additional notes: > -- Remember to use single quotes around the * else it

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Tim Bruce - Postgres
On Tue, November 3, 2009 10:10, Scott Marlowe wrote: > On Tue, Nov 3, 2009 at 1:53 AM, Shruthi A wrote: >> Hi all, >> >> -- Once this service is started, telneting the server on the given port >> successfully connects. >> -- Dear Ian Lea, i guess 10.0.0.1/24  is the same as 10.0.0.0/24  as the >>

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Scott Marlowe
On Tue, Nov 3, 2009 at 11:26 AM, Kevin Grittner wrote: > Scott Marlowe wrote: > >>> -- Dear Ian Lea, i guess 10.0.0.1/24  is the same as 10.0.0.0/24 >>> as the mask '24' means that the first 3 octets (24 bits from the >>> left hand side) must match ie both mean simply 10.0.0.* >> >> Actually 10.0

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Shruthi A
Hi all, Thanks a lot for all your replies. The problem is solved now. This is the correct thing to do:listen_addresses = '*' And then restart the service. Additional notes: -- Remember to use single quotes around the * else it will give syntax error. -- The listen_addresses parameter specif

Re: [ADMIN] Need help in enabling remote connection

2009-11-02 Thread Sam Jas
hostall all 10.0.0.1/24 trust >> host all all trust -- In postgresql.conf, i added the line listen_addresses = 10.0.0.* >> listen_address = * & then restart the server. -- Thanks Sam --- On Mon, 2/11/09, Shruthi A wrote: From: Shruthi A Subject: [

Re: [ADMIN] Need help in enabling remote connection

2009-11-02 Thread Brian Modra
2009/11/2 Shruthi A : > Hi, > > I want a postgres client to be able to connect to a postgres sever on a > remote machine.  But i'm not able to make it work.  Assume both the machines > are on a LAN 10.0.0.* .Following available advice, this is what i did: > > -- In pg_hba.conf, i added the line > h

Re: [ADMIN] Need help in enabling remote connection

2009-11-02 Thread Julius Tuskenis
Hello, I think you make mistake writing "listen_addresses = 10.0.0.*". I doubt it can be done like this... Try "listen_addresses = '*'" first. Also see, that addresses are in form '10.0.0.1' and not 10.0.0.1. (use ' ) If this doesn't help try telneting server (port 5432) from client mashine. M