Thread: Start up

Start up

From
"Keith Worthington"
Date:
Hi All,

I just installed pgAdmin.  I can start the program.  When I try to add a
server connection (which is what I amssume I am supposed to do) it fails.  I
am using the following settings in the "Connect to a Server" dialog.

Description:  DBServer
Server:  localhost
Port:  5432
SSL:  
Initial database:  template1
Username:  postgres
Trusted:  X
Password:

When I click "OK" I get the following message.

An error has occured:

Error connecting to the server:  could not connect to server:
Connection refused    Is the server running on host 127.0.0.1 and accepting    TCP/IP connections on port 5432?

Of course being a newbie I don't know if the server is listening.  Any help
would be appreciated.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com



Re: Start up

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Keith Worthington
> Sent: 08 October 2004 20:45
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Start up
>
> Error connecting to the server:  could not connect to server:
> Connection refused
>      Is the server running on host 127.0.0.1 and accepting
>      TCP/IP connections on port 5432?
>
> Of course being a newbie I don't know if the server is
> listening.  Any help would be appreciated.

What server/platform are you running? If it's < 8.0, then look for the
tcpip_sockets options in $PGDATA/postgresql.conf. If its version 8.0
beta, then it should work out of the box from localhost, but double the
listen_addresses directive in postgresql.conf. If you need to change
anything, you should restart postgresql.

Regards, Dave