คำสั่ง backup / restore ใน format sql output

[admin]

backup

Code: Select all

pg_dump db_name | gzip > file.gz

restore

Code: Select all

cat file.gz | gunzip | psql db_name