On (18/07/05 09:05), Lance Hoffmeyer wrote: > What am I doing wrong here? > I am not able to do anything with my postgresql database? > > in /etc/postgresql/pg_hba.conf > > local all postgres md5 > host all postgres 127.0.0.1 255.255.255.255 md5 > > > I login to a console as postgres and try > > postgres:~$ createuser -U postgres -a username > Shall the new user be allowed to create databases? (y/n) y > Password: > createuser: could not connect to database template1: FATAL: Password > authentication failed for user "postgres" > postgres:~$
You could try, as postgres: # psql [template1] which should get you in and then create your user using SQL. I've actually found pgadmin3 useful for managing users, groups etc. HTH Regards Clive -- www.clivemenzies.co.uk ... ...strategies for business -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
