Search Postgresql Archives

Re: Cannot connect to Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is postgresql on the same machine as your applicaiton?

Are you sure postgresql is starting up in the directory you think it is?

On Tue, 2005-02-08 at 12:44, bernd@xxxxxxxxxx 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@xxxxxxxxxxxxxxxxx>
> An: bernd@xxxxxxxxxx
> Betreff: Re:  Cannot connect to Database
> 
> > Did you restart Postgresql after editing your pg_hba.conf file?
> >
> > On Tue, 2005-02-08 at 12:22, bernd@xxxxxxxxxx wrote:
> > > I recvive still the same error-message.
> > >
> > > thx,
> > > Bernd
> > >
> > >  --- UrsprÃÂngliche Nachricht ---
> > > Datum: 08.02.2005 19:14
> > > Von: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
> > > An: bernd@xxxxxxxxxx
> > > Betreff: Re:  Cannot connect to Database
> > >
> > > > bernd@xxxxxxxxxx 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@xxxxxxxxx>
> > > > > An: "bernd@xxxxxxxxxx" <bernd@xxxxxxxxxx>
> > > > > Betreff: Re:  Cannot connect to Database
> > > > >
> > > > >
> > > > >>On Tue, 08 Feb 2005 18:46:00 +0100, bernd@xxxxxxxxxx
> > > <bernd@xxxxxxxxxx>
> > > > >
> > > > > 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@xxxxxxxxx
> > > > >>LlamaLand                       http://netllama.linux-sxs.org
> > > > >>
> > > > >
> > > > >
> > > > >
> > > > > ---------------------------(end of
> > > broadcast)---------------------------
> > > > > TIP 5: Have you checked our extensive FAQ?
> > > > >
> > > > >                http://www.postgresql.org/docs/faq
> > > >
> > > >
> > > > --
> > > > Command Prompt, Inc., your source for PostgreSQL replication,
> > > > professional support, programming, managed services, shared
> > > > and dedicated hosting. Home of the Open Source Projects plPHP,
> > > > plPerlNG, pgManage,  and pgPHPtoolkit.
> > > > Contact us now at: +1-503-667-4564 - http://www.commandprompt.com
> > > >
> > > >
> > > >
> > >
> > >
> > > ---------------------------(end of
> broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
> majordomo@xxxxxxxxxxxxxx
> >
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux