PostgreSQL
PostgreSQL is a free open source relational database.
psql -U postgres
Log into Postgres as user 'postgres'
\l
List all databases in Postgres
\c {databasename}
Connect to database
\d
List all tables in Postgres database
\q
Disconnect from database
Admin
sudo systemctl restart postgresql
Restart postgres
Set password for user
- switch to OS user:
su - postgres
- connect:
psql
\password
OR (for other user named 'replication')\password replication
ORALTER ROLE replication WITH LOGIN PASSWORD 'password';