Re: Ubuntu installed postgresql password failure

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