On September 13, 2015 03:57:51 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.
Try jan@bison:~$ sudo -u postgres -s postgres@bison:~$ psql psql (9.4.4) Type "help" for help. postgres=# ALTER USER postgres PASSWORD 'postgres'; ALTER ROLE postgres=# \q postgres@bison:~$ exit jan@bison:~$ > > Any help will be greatly appreciated. > > Dale -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
