Configuring postgresql8.1.1

Started by Pushpa Gorakover 20 years ago3 messagesbugs
Jump to latest
#1Pushpa Gorak
pushpag@yash.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pushpa Gorak (#1)
Re: Configuring postgresql8.1.1

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

#3Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: Pushpa Gorak (#1)
Re: Configuring postgresql8.1.1

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 = 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 ;)