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
Attachment:
pgp81DgLcR1HY.pgp
Description: PGP signature
_______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
