Обсуждение: Configuring postgresql8.1.1

hi,

i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
connection. though i have uncommented listen_addresses = localhost in
postgreql.conf file,the connection is refused.

Can you help me in resolving this.


Thanx in advance,

Pushpa.Gorak

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Pushpa Gorak <pushpag@yash.com> writes:
> i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
> connection. though i have uncommented listen_addresses = localhost in
> postgreql.conf file,the connection is refused.

You probably need to change your iptables configuration to allow
connections to port 5432.

            regards, tom lane

On 12/16/05, Pushpa Gorak <pushpag@yash.com> wrote:
>
>
> hi,
>
> i have installed postgresql8.1.1 on RedHat7.0. how do i enable TCP/IP
> connection. though i have uncommented listen_addresses =3D localhost in
> postgreql.conf file,the connection is refused.
>

if you simply uncomment this but not change this value you will
receive only connections from localhost...
and you have to edit the pg_hba.conf as well

> Can you help me in resolving this.
>
>
> Thanx in advance,
>
> Pushpa.Gorak
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)