Re: Cannot connect to Database

I've already shutdown my firewall.
My OS is Linux (SuSE 9.2 64Bit)

My postgre version is 7.4.6

and the port is on listen-mode

postgres(at)amd64:/home/bernd> netstat -an | grep 5432
tcp 0 0 0.0.0.0:5432 0.0.0.0:*
LISTEN
tcp 0 0 :::5432 :::*
LISTEN
unix 2 [ ACC ] STREAM HÖRT 15159
/tmp/.s.PGSQL.5432

thx,
Bernd
--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:56
Von: Lonni J Friedman <netllama(at)gmail(dot)com>
An: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
Betreff: Re: [GENERAL] 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(at)kalwar(dot)net <bernd(at)kalwar(dot)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(at)g2switchworks(dot)com>
> > An: bernd(at)kalwar(dot)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(at)kalwar(dot)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(at)commandprompt(dot)com>
> > > > An: bernd(at)kalwar(dot)net
> > > > Betreff: Re: [GENERAL] Cannot connect to Database
> > > >
> > > > > bernd(at)kalwar(dot)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(at)gmail(dot)com>
> > > > > > An: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
> > > > > > Betreff: Re: [GENERAL] Cannot connect to Database
> > > > > >
> > > > > >
> > > > > >>On Tue, 08 Feb 2005 18:46:00 +0100, bernd(at)kalwar(dot)net
> > > > <bernd(at)kalwar(dot)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(at)gmail(dot)com
> LlamaLand http://netllama.linux-sxs.org
>