Re: PGAdmin will not connect

From: Michiel Lange <michiel(at)minas(dot)demon(dot)nl>
To: Jeff Cave <jeff(dot)cave(at)sunergon(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PGAdmin will not connect
Date: 2004-03-08 01:11:11
Message-ID: 404BC82F.5000000@minas.demon.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

what does your pg_hba.conf say about alowing hosts? Is your host allowed
to connect to the database?
Read your logfile and see if there's something that gives a clue as to
why it won't allow the host...

Could also have something to do with encryption? is a certain way of
encryption required and could it be that pgAdmin does not support it?
(would give the bad user/password error, but it's worth the try)

If you're not certain where the fault is, try this checklist
On the database machine itself:
- connect to the database locally (if it's ok, the postmaster is running)
- telnet localhost 5432 (do you get a 'connected' status (but otherwise
no good info, for telnet is not psql ;-)) the database accepts socket
connections)
- telnet <your ip> 5432 (same as above, but the postmaster will see you
as from your local IP, and not localhost)

From the client:
- ping <db server> : going OK? Your network is OK
- telnet <dbserver> 5432: going OK? You can reach the postmaster, so
there's no problems with the database...

if all of these tests were succesfull, you should really check your
logfile for clues as to what went wrong.
A linux / unix way of checking out what's going on:
tail -f logfile
<try to connect> and see what new lines appear in the log...

Hope it helps you on your way...
Michiel

Jeff Cave wrote:

>No... That wasn't it.
>
>tcpip_socket=true
>port=5423
>
>Rebooted my computer (I know it was probably overkill, but did anyway), and there was no change. Still cannot get pgAdmin to connect. Still getting the same error.
>
>
>-----Original Message-----
>From: Andreas Pflug
>Sent: Sat 3/6/2004 3:04 AM
>
>Jeff Cave Wrote:
>
>
>> Is the server running on host "127.0.0.1" and accepting
>> TCP/IP connections on port 5423?
>>
>>
>
>Is the server accepting TCP/IP connections on port 5432?!?
>
>I bet it's not. (tcpip_socket=true in postgresql.conf)
>
>Regards,
>Andreas
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2004-03-08 09:03:09 FW: pgAdminIII error
Previous Message Andreas Pflug 2004-03-07 18:36:41 Re: Translations