PostgreSQL

Password management

By default, the CC-IN2P3 interactive servers (cca.in2p3.fr) have one client for each DBMS.

Client psql for PostgreSQL

% psql -h <service>.in2p3.fr> -p <port> -U <username> -W <database>

Once connected to your PostgreSQL instance, you can change your password

dbname=> alter user <username> with password '<new password>';