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

Re: cannot connect using terminal nor pgaccess

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: psql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cannot connect using terminal nor pgaccess
Date: 2001-05-21 15:14:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
on day of Mon, 21 May 2001 17:00:19 +0200 (CEST), the message from Peter
Eisentraut <peter_e(at)gmx(dot)net> says:

> Jaume Teixi writes:
> > $ psql -d template1 -U postgres
> > psql: Peer authentication failed for user 'postgres'
> There is no "peer" authentication type in any official PostgreSQL

he, I hope this is the unix socket method that Olly is developing on the
current debian unstable release 7.1.1-3

but why the tcp/ip also doesn't works ?

teixi(at)thinkpad:~$ grep -v ^# /etc/postgresql/pg_hba.conf | grep -i host   

host         all       ident sameuser
host         all             reject

suid postgres works

teixi(at)thinkpad:~$ su - postgres -- psql template1

but without suid doesnt'

teixi(at)thinkpad:~$ psql -d template1 -U postgres -h localhost -p 5432
psql: IDENT authentication failed for user 'postgres'

any points ?


Jaume Teixi
    6TEMS - Ducform, SA

In response to


pgsql-admin by date

Next:From: Peter EisentrautDate: 2001-05-21 17:13:00
Subject: Re: cannot connect using terminal nor pgaccess
Previous:From: twangerDate: 2001-05-21 15:04:48
Subject: Re: simpler query significantly slower

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