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(at)bison:~$ sudo -u postgres -s
postgres(at)bison:~$ psql
psql (9.4.4)
Type "help" for help.

postgres=# ALTER USER postgres PASSWORD 'postgres';
ALTER ROLE
postgres=# \q
postgres(at)bison:~$ exit
jan(at)bison:~$

>
> Any help will be greatly appreciated.
>
> Dale