Re: postgresql -U postgres login porblems

[Clive Menzies <clive@clivemenzies.co.uk>]

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