Skip site navigation (1) Skip section navigation (2)

Re: jdbc pg_hba.conf error

From: "chris smith" <dmagick(at)gmail(dot)com>
To: Bhavana(dot)Rakesh <Bhavana(dot)Rakesh(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: jdbc pg_hba.conf error
Date: 2007-05-31 13:24:59
Message-ID: 3c1395330705310624q793f8f82n8b8ba240e1acf195@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 5/31/07, Bhavana.Rakesh <Bhavana(dot)Rakesh(at)noaa(dot)gov> wrote:
>
>  Ok,
>  I confirmed that I'm editing the right pg_hba.conf file.  I made sure that
> there are no other postmasters running.  I made sure that there is a user
> called 'brakesh'.  I restart the postmaster everytime I make any changes to
> pg_hba.conf file.  But still same results!
>
>  [brakesh(at)lnx383 ~/db_connect]$ psql -U brakesh -h 127.0.0.1 -d testing123
>  psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "brakesh",
> database "testing123", SSL off
>
>
>  [brakesh(at)lnx383 ~/db_connect]$ psql -p 5000 testing123
>  Welcome to psql 7.4.17, the PostgreSQL interactive terminal.

Why are you specifying the port number when you don't include the host?

What happens if you do include the port:

psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123

-- 
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

pgsql-general by date

Next:From: Ray StellDate: 2007-05-31 13:27:00
Subject: Re: jdbc pg_hba.conf error
Previous:From: Bhavana.RakeshDate: 2007-05-31 12:57:41
Subject: Re: jdbc pg_hba.conf error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group