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: (view raw, whole thread or download thread mbox)
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 -d testing123
>  psql: FATAL:  no pg_hba.conf entry for host "", 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 -d testing123

Postgresql & php tutorials

In response to


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-2017 The PostgreSQL Global Development Group