Re: Ubuntu installed postgresql password failure

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 meta-command instead of ALTER
USER to change a password, as to avoid having the password stamped in
the logs.

Regards,

--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services