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 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: not available URL: <http://lists.centos.org/pipermail/centos/attachments/20070410/620178dd/attachment-0005.sig>