Knowledge Base
308 copy-ready commands with fill-in variables, plus step-by-step installation guides.
/
Categories
7 results
PostgreSQL
Create PostgreSQL Database & User
sudo -u postgres psql <<EOF
#postgresql
#database
3 views
0 copies
PostgreSQL
Connect to PostgreSQL as postgres
sudo -u postgres psql
#postgresql
#connect
3 views
0 copies
PostgreSQL
Backup PostgreSQL Database
sudo -u postgres pg_dump {{db_name}} | gzip > /backups/{{db_name}}-$(date +%Y%m%...
#postgresql
#backup
3 views
0 copies
PostgreSQL
Restore PostgreSQL from Backup
gunzip < /backups/{{backup_file}} | sudo -u postgres psql {{db_name}}
#postgresql
#restore
3 views
0 copies