Re: Trouble connecting

Lists: pgsql-admin
From: Norbert Beckers <limburgsebeer(at)zonnet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Trouble connecting
Date: 2004-01-15 10:26:47
Message-ID: 40066AE7.2040005@zonnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

I'm a novice when it comes to PostgreSQL and PostgreSql Admin. I having
truoble connecting to PostgreSQl Server running on the localhost. Every
time I try to connect I get the following response:

¨Error connecting to the server: could not connect to server:
Connection refused
is server running on 127.0.0.1 and accepting TCP/IP connections on 5432?
¨
The connection information:
Server = localhost
Port = 5432 SSL = <empty>
Initial database: template1
Username = postgres
Trusted = off
Password = <empty>

Futher Information:
PostgreSQL version = 7.3.4-11
PostgreSQl Admin = 3.1.1.0-cvs200312111
OS = Fedora Core 1 (2.4.22-1.2149) Arch = athlon

Can anyone help me out here?

Norbert Beckers, Heerlen, NL


From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Norbert Beckers <limburgsebeer(at)zonnet(dot)nl>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Trouble connecting
Date: 2004-01-16 17:40:37
Message-ID: Pine.LNX.4.33.0401161040260.27657-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

You likely need this line in postgresql.conf:

tcpip_socket = true

On Thu, 15 Jan 2004, Norbert Beckers wrote:

> I'm a novice when it comes to PostgreSQL and PostgreSql Admin. I having
> truoble connecting to PostgreSQl Server running on the localhost. Every
> time I try to connect I get the following response:
>
> ¨Error connecting to the server: could not connect to server:
> Connection refused
> is server running on 127.0.0.1 and accepting TCP/IP connections on 5432?
> ¨
> The connection information:
> Server = localhost
> Port = 5432 SSL = <empty>
> Initial database: template1
> Username = postgres
> Trusted = off
> Password = <empty>
>
> Futher Information:
> PostgreSQL version = 7.3.4-11
> PostgreSQl Admin = 3.1.1.0-cvs200312111
> OS = Fedora Core 1 (2.4.22-1.2149) Arch = athlon
>
> Can anyone help me out here?
>
> Norbert Beckers, Heerlen, NL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>