Re: Ubuntu installed postgresql password failure

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