Story/postgresql
postgresql backup
Stdio
2009. 2. 28. 10:40
반응형
Database 목록 보기
$ /usr/local/pgsql/bin/psql -l
List of databases
Name | Owner | Encoding
----------------+----------------+-----------
xxx | xxx | SQL_ASCII
yyy | yyy | UTF8
(2 rows)
Database Backup
$ /usr/local/pgsql/bin/pg_dump xxx> xxx.dump
특정 table만 Backup
$ /usr/local/pgsql/bin/pg_dump --table=table1 some_db > table_dump
$ /usr/local/pgsql/bin/pg_dump -Uxxx --no-owner --no-privileges --table=zip xxx > zipcode.dump
반응형