10 Apr
2007
10 Apr
'07
1:19 p.m.
On Tue, Apr 10, 2007 at 12:03:56PM +0100, Tom Brown wrote:
I am following instructions for creating a DB user and encountering this
# createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: IDENT authentication failed for user "postgres"
Try instead: sudo -u postgres createuser -ADP foo
In a standard postgres install whats causing this? I presume its because the user postgres has a pwd but what is this and why am i not being prompted to enter this?
See http://www.postgresql.org/docs/7.4/interactive/client-authentication.html and /var/lib/pgsql/data/pg_hba.conf.
--
lfr
0/0