Szybkie notatki administratora

Backup i restore Postgresql

backup

pg_dump -U user -d mydb | gzip > mydb.pgsql.gz

restore

gunzip -c mydb.pgsql.gz | psql dbname -U user

Comments are currently closed.