Timescale Logo

Users

Set/Reset postgres user password

\password username

// To set/reset a password for PostgreSQL database user (psql)

For example: Change password for current user “postgres”:

\password postgres
Enter new password: xxxx
Enter it again: xxxx


Show all users

select * from pg_user;

// Display PostgreSQL database users (SQL)

\du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 testrole  |                                                            | {} 
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

// Display PostgreSQL database roles (psql)


Login & enter postgres terminal

$ psql -U testuser mytest
Password for user testuser: ......
psql (9.6.12)
Type "help" for help.

// Login to PostgreSQL: psql -U user database (psql)

Timescale Logo

Subscribe to the Timescale Newsletter

By submitting, I acknowledge Timescale’s Privacy Policy
2024 © Timescale Inc. All rights reserved.