On 9/13/2015 1:57 PM, Dale Seaburg wrote:
I have reached my wit's end. lol I installed postgresql (9.3.9) and
pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql,
I get an error "password authentication failed for user "postgres" ".
Ubuntu (14.04.3).
I created a postgres user BEFORE installing postgresql/pgadmin
toolset. The password I used for the postgres user will not work with
the installed postgresql tools.
What in the world am I doing wrong, and more importantly, how do I
determine the password used for postgres during the postgresql
install? AND, why should it be different from the postgres user I
created.
Any help will be greatly appreciated.
try `su - postgres` THEN run psql
if that works, do this at that psql prompt:
CREATE USER yourname SUPERUSER PASSWORD 'somepassword';
CREATE DATABASE yourname OWNER yourname;
where yourname is your regular login. now exit psql, exit the su, and
try running pgadmin. don't specify localhost, leave the host
empty/blank, and you should be allowed to log in as yourname.
explaining why this is just as it is requires more energy than I have at
the moment.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
