PostgreSQL - LucianCumpata/DevOps GitHub Wiki

• Basic postgresql terminal commands

$ sudo su - postgres

psql

\conninfo

\password postgres

\list

\l

\q

• How to find the postgresql.conf file?

$ psql -U postgres -c 'SHOW config_file'

• How to restart postgresql?

# service postgresql restart

• How to send psql commands through a bash script?

sudo -u postgres psql --command '<command>'

For example: sudo -u postgres psql --command '\password postgres'

• How to change password in a script?

sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD 'newpassword';"