Re: Cannot connect to Database

Well, its obviosly not listening on localhost.  Are you firewalling
anywhere?  Which OS is this?  Which version of postgresql?

If this is Linux, what do you get from running 'netstat -an | grep 5432' ?

On Tue, 08 Feb 2005 19:44:26 +0100, bernd@kalwar.net <bernd@kalwar.net> wrote:
> > Did you restart Postgresql after editing your pg_hba.conf file?
>
> Yes, I did.
>
> thx,
> Bernd
>
>  --- Ursprüngliche Nachricht ---
> Datum: 08.02.2005 19:31
> Von: Scott Marlowe <smarlowe@g2switchworks.com>
> An: bernd@kalwar.net
> Betreff: Re: [GENERAL] Cannot connect to Database
>
> > Did you restart Postgresql after editing your pg_hba.conf file?
> >
> > On Tue, 2005-02-08 at 12:22, bernd@kalwar.net wrote:
> > > I recvive still the same error-message.
> > >
> > > thx,
> > > Bernd
> > >
> > >  --- Ursprüngliche Nachricht ---
> > > Datum: 08.02.2005 19:14
> > > Von: "Joshua D. Drake" <jd@commandprompt.com>
> > > An: bernd@kalwar.net
> > > Betreff: Re: [GENERAL] Cannot connect to Database
> > >
> > > > bernd@kalwar.net wrote:
> > > > >>Do you have TCP/IP activated in postgresql.conf ?  Are you trying
> to
> > > > >>connect via localhost (127.0.0.1) or some other route?
> > > > >
> > > > >
>
> > > > > I start the Server with the -i option, so TCP/IP is activated,
> isn't
> > > it?
> > > > > I want to connect by localhost to my database.
> > > >
> > > >  From the localhost can you:
> > > >
> > > > psql -h 127.0.0.1 -U postgres template1
> > > >
> > > > ?
> > > >
> > > > Sincerely,
> > > >
> > > > Joshua D. Drake
> > > >
> > > >
> > > > >
> > > > > thx,
> > > > >
> > > > > Bernd
> > > > >
> > > > >  --- Ursprüngliche Nachricht ---
> > > > > Datum: 08.02.2005 18:52
> > > > > Von: Lonni J Friedman <netllama@gmail.com>
> > > > > An: "bernd@kalwar.net" <bernd@kalwar.net>
> > > > > Betreff: Re: [GENERAL] Cannot connect to Database
> > > > >
> > > > >
> > > > >>On Tue, 08 Feb 2005 18:46:00 +0100, bernd@kalwar.net
> > > <bernd@kalwar.net>
> > > > >
> > > > > wrote:
> > > > >
> > > > >>>Hi,
> > > > >>>
> > > > >>>everytime I try to connect to my Database with a
> Java-Applikation, I
> > > > >>>recieve only the following Exception:
> > > > >>>
> > > > >>>org.postgresql.util.PSQLException: A connection error has
> occurred:
> > > > >>>org.postgresql.util.PSQLException: FATAL: kein
> pg_hba.conf-Eintrag
> > > > >
> > > > > für
> > > > >
> > > > >>>Host »127.0.0.1«, Benutzer »postgres«, Datenbank »test«,
> SSL aus
> > > > >>>
> > > > >>>I get the same error-message with other applications, e.g.
> pgaccess,
> > > > >
> > > > > too.
> > > > >
> > > > >>>My pg_hba.conf looks like:
> > > > >>>
> > > > >>># TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
> > > > >>>METHOD
> > > > >>>
> > > > >>>host    all         all         127.0.0.1
> 255.255.255.255
> > > > >
> > > > > trust
> > > > >
> > > > >>>The database and the applications are on the same host.
> > > > >>>
> > > > >>>What could be the problem.
> > > > >>
> > > > >>Do you have TCP/IP activated in postgresql.conf ?  Are you trying
> to
> > > > >>connect via localhost (127.0.0.1) or some other route?


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org