El 13/09/15 a las 18:20, Jan de Visser escribió:
>
> 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
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