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: | 20010521171449.1f3696a4.teixi@6tems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
release.
he, I hope this is the unix socket method that Olly is developing on the
current debian unstable release 7.1.1-3
isn't?
but why the tcp/ip also doesn't works ?
teixi(at)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
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 ?
thanks
--
Jaume Teixi
CTO
6TEMS - Ducform, SA
http://www.6tems.com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-21 17:13:00 | Re: cannot connect using terminal nor pgaccess |
Previous Message | twanger | 2001-05-21 15:04:48 | Re: simpler query significantly slower |