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 = 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?
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)