From: | Peter Bradley <apvx95(at)dsl(dot)pipex(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Cannot connect to postgresql |
Date: | 2004-07-18 20:03:20 |
Message-ID: | 1090181000.14084.43.camel@linux.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I have just downloaded and installed postgresql and pgadmin3.
In Postgresql I have done no more than create a test database (with no
tables or anything) called testdb. I can connect to this dataabase as
the user postgres from the command line interface (./psql testdb). The
postgres user is the user who started the server.
When I try to add a server in pgadmin3 I firstly get the following
warning:
Warning:
Mailcap file /home/peter/.mailcap, line 59: incomplete entry ignored.
which seems a bit odd, since that refers to crossover office's entry for
Word 97 ...
Then I enter the details for the new server (localhost, testdb,
postgres), but pgadmin3 hangs when I click on OK. I've tried it with
the trusted checkbox both selected and deselected.
netstat -l confirms that the server is listening on port 5432.
If I try to telnet to port 5432 I get "Connection refused" both as my
own user and as the postgres user.
My pg_hba.conf file is just the default file, which says that
connections should be permitted for any local postgresql user. So I
gather from that that the postgres user should be OK.
I'd look in the logs, but I don't know where to look (or what to look
for ...).
I'd be grateful for any help
Thanks in advance
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-07-18 20:14:15 | Re: Cannot connect to postgresql |
Previous Message | Dave Page | 2004-07-16 14:48:44 | Re: Error Message: ERROR: column "datpath" does not exist |