Re: Cannot connect to postgresql

On Sun, 2004-07-18 at 21:14, Andreas Pflug wrote:
> Peter Bradley wrote:
> > 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
>
> Please supply informations about system and pgadmin3 version
> (binary/source?)
>
> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Good point Andreas. Apologies.

I'm running SuSE Linux 8.2. Postgresql 7.4.3. pgadmin3-1.0.2.

The Postgresql installation is from the source files. pgadmin is from
the rpm for SuSE 8.2.

My apologies again for not including that info before.

Thanks

Peter