postgresql backup

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