Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-14 Thread Jan de Visser
On September 14, 2015 07:22:58 AM Martín Marqués wrote: > I would recommend using psql's \password meta- command instead of ALTER > USER to change a password, as to avoid having the password stamped in > the logs. You learn something new every day :-) jan

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-14 Thread Jan de Visser
On September 14, 2015 07:22:58 AM Martín Marqués wrote: > I would recommend using psql's \password meta- command instead of ALTER > USER to change a password, as to avoid having the password stamped in > the logs. You learn something new every day :-) jan

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-14 Thread Martín Marqués
El 13/09/15 a las 18:20, Jan de Visser escribió: > > 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 I would recommend using psql's \password

[GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Dale Seaburg
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

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Adrian Klaver
On 09/13/2015 01: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

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Adrian Klaver
On 09/13/2015 01: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

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Jan de Visser
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

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread John R Pierce
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