pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin J. Brown, Jr. <mjbjr@mjbjr.com>
To: pgsql-admin@postgresql.org
Subject: can't authenticate pg admin
Date: Wed, 11 Aug 2004 10:17:27 GMT
Message-ID: <pan.2004.08.11.10.17.34.477531@mjbjr.com> (raw)

I've had this problem with 7.3.3, and now with 7.4.3. ...

The pg admin is the default 'postgres'.  As 'postgres', I do...

postgres@localhost postgres $ 'psql -d template1'
Welcome to psql 7.4.3, the PostgreSQL interactive terminal.

template1=# alter user postgres password 'xyz'
template1=#

I exit 'psql'.

I then edit 'pg_hba.conf', changing from 'trust' to 'password'.
I stop, then start pg.

I then do 'psql -d template1', which results in a password prompt.
I enter 'xyz', and get an authentication error for user "postgres".

Other db users authenticate fine, only the admin fails.

Any ideas on how to fix this?

-- 
                            - Martin J. Brown, Jr. -
                              - mjbjr@mjbjr.com -
Public PGP Key ID: 0x76A1778E keyserver: http://pgpkeys.mit.edu:11371/
Fingerprint: F2D2 5D2B 333F 79D0 D126  0941 21D6 7321 76A1 778E




view thread (3+ messages)  latest in thread

Message-ID: <pan.2004.08.11.10.17.34.477531@mjbjr.com>
Permalink:  ../pan.2004.08.11.10.17.34.477531@mjbjr.com/
Also on:    postgresql.org/message-id/pan.2004.08.11.10.17.34.477531@mjbjr.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mjbjr@mjbjr.com
  Subject: Re: can't authenticate pg admin
  In-Reply-To: <pan.2004.08.11.10.17.34.477531@mjbjr.com>
  References: <pan.2004.08.11.10.17.34.477531@mjbjr.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox