Skip site navigation (1) Skip section navigation (2)

pgAdmin can't connect to port 5432

From: Michael J Martin <mike(at)mike-martin(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin can't connect to port 5432
Date: 2004-08-15 19:44:18
Message-ID: 411FBD12.7020008@mike-martin.com (view raw or flat)
Thread:
Lists: pgadmin-support
I realise this is probably my fault for not setting up Postgres properly 
so may question is how do you setup postgres to play nicely with pgAdmin?

Background:
We're with a host provider who uses FreeBSD and installed postgresql 
using their tools, it's running and I can get to it by using the 'psql' 
command at the SSH prompt. I can even use 'createdb' etc. as root or as 
the 'pgsql' user on the system.

I created a new user in postgres using: CREATE USER mike CREATEUSER 
PASSWORD 'whatevermypasswordis'.

But when I connect using pgAdmin3 (winxp) it says connection refused.

Ran a 'netstat' at the SSH prompt of the server and 5432 wasn't open but 
nor is 3306 and I can connect to the MySQL server on there running a 
front-end at my pc just fine.

'ps aux' says:
pgsql    49576  0.0  0.1 15136 2076  ??  Is    6:46PM   0:00.04 
/usr/local/bin/postmaster (postgres)
pgsql    49577  0.0  0.1  6868 2000  ??  I     6:46PM   0:00.01 
postmaster: stats buffer process    (postgres)
pgsql    49578  0.0  0.1  5940 2088  ??  I     6:46PM   0:00.01 
postmaster: stats collector process    (postgres)

'pg_ctl status' as root says:
pg_ctl: postmaster is running (PID: 49576)
Command line was:
/usr/local/bin/postmaster

'pg_ctl' as unprivileged user says:
pg_ctl: postmaster or postgres not running

I guess I'm just stuck and need help anyone know how to get pgAdmin to 
connect to postgresql? Is there anything I missed when setting it up?

Is there an IP wildcard I need to set somewhere, like the MySQL GRANT 
ALL ON *.* TO mike@'%' IDENTIFIED BY 'whatevermypasswordis';?

Thanks,

Michael

Responses

pgadmin-support by date

Next:From: Michael J MartinDate: 2004-08-15 21:11:51
Subject: Re: pgAdmin can't connect to port 5432
Previous:From: Raphaƫl EnriciDate: 2004-08-13 20:33:51
Subject: Re: undefined symbol: krb5_cc_get_principal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group