dbTalk Databases Forums  

[BUGS] Configuring postgresql8.1.1

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] Configuring postgresql8.1.1 in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pushpa Gorak
 
Posts: n/a

Default [BUGS] Configuring postgresql8.1.1 - 12-16-2005 , 12:49 PM








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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] Configuring postgresql8.1.1 - 12-16-2005 , 01:53 PM






Pushpa Gorak <pushpag (AT) yash (DOT) com> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


Reply With Quote
  #3  
Old   
Jaime Casanova
 
Posts: n/a

Default Re: [BUGS] Configuring postgresql8.1.1 - 12-16-2005 , 02:00 PM



On 12/16/05, Pushpa Gorak <pushpag (AT) yash (DOT) com> wrote:
Quote:

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

Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.