| From: | Martín Marqués <martin(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jan de Visser <jan(at)de-visser(dot)net>, pgsql-general(at)postgresql(dot)org |
| Cc: | Dale Seaburg <kg5lt(at)verizon(dot)net> |
| Subject: | Re: Ubuntu installed postgresql password failure |
| Date: | 2015-09-14 10:22:58 |
| Message-ID: | 55F6A002.7050302@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Ramseyer | 2015-09-14 11:44:24 | Re: GIN Trigram Index Size |
| Previous Message | biswadeep.banerjee | 2015-09-14 10:14:03 | BUG #13619: regression functions return Null |