From: | "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Allowing a connection from other client in the network |
Date: | 2007-09-24 17:57:26 |
Message-ID: | 009001c7fed4$5de77440$ec5a3d0a@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Your solution worked perfectly, Tom.
Thanks a million
Best,
Oliveiros
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Monday, September 24, 2007 4:29 PM
Subject: Re: [NOVICE] Allowing a connection from other client in the network
> "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> writes:
>> I need to allow access to the postgres server(windows) from a remote
>> machine (10.61.90.231).
>
>> I changed the postgresql.conf to include the line :
>
>> listen_addresses = 'localhost,10.61.90.231' # what IP address(es) to
>> listen on;
>
> This is incorrect. listen_addresses must specify the interface
> addresses of your *own* machine, not some other one. Usually if you
> want to allow remote connections, you should just set it to '*' and let
> the postmaster figure out what the machine's IP address(es) are.
>
>> And I changed the pg_hba.conf file (also on data dir) so now it has a
>> line like this
>
>> host all all 10.61.90.0/24 md5
>
> This part's OK.
>
> You might also have a third problem: if the machine has any sort of
> firewall software, the firewall might need to be adjusted to let in
> remote connections to port 5432.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sugrue, Sean | 2007-09-24 20:05:46 | Odbc connection |
Previous Message | Tom Lane | 2007-09-24 15:29:15 | Re: Allowing a connection from other client in the network |