postgresql -U postgres login porblems
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:~$
Lance
--
Lance Hoffmeyer
lance@augustmail.com
-------------------------------------------------------------------------------
The natural progress of things is for liberty to yield and
governments to gain ground.
-
Thomas Jefferson
Reply to: