|
Home > Archive > PostgreSQL Bugs > December 2005 > Configuring postgresql8.1.1
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Configuring postgresql8.1.1
|
|
| Pushpa Gorak 2005-12-16, 1:23 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
| |
| Tom Lane 2005-12-16, 8:25 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Jaime Casanova 2005-12-16, 8:25 pm |
| 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 ;)
---------------------------(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
|
|
|
|
|