Re: cannot connect using terminal nor pgaccess - Mailing list pgsql-admin

Jaume Teixi writes:

> but why the tcp/ip also doesn't works ?
>
> teixi@thinkpad:~$ grep -v ^# /etc/postgresql/pg_hba.conf | grep -i host
>
> host         all         127.0.0.1     255.255.255.0       ident sameuser
                                                                   ^^^^^^^^
> host         all         0.0.0.0       0.0.0.0             reject

> teixi@thinkpad:~$ psql -d template1 -U postgres -h localhost -p 5432
  ^^^^^                                  ^^^^^^^^
> psql: IDENT authentication failed for user 'postgres'

"sameuser" means "same user".  Please read up on the details of ident
authentication.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter