[PostgreSQL] DB 덤프 & 복구

[덤프]

/usr/local/pgsql/bin/pg_dump -U USER_NAME -d DB_NAME -t TABLE_NAME -f DUMP_FILE_PATH

ex)
USER         : bloodguy
DB_NAME   : my_site
SCHEMA    : bloodguy
TABLE       : board_1
FILE_PATH : /tmp/board_1.sql

/usr/local/pgsql/bin/pg_dump -U bloodguy -d my_site -t bloodguy.board_1 -f /tmp/board_1.sql





[복구]

/usr/local/pgsql/bin/psql -U USER_NAME -d DB_NAME < SQL_FILE_PATH

ex)
/usr/local/pgsql/bin/psql -U bloodguy -d my_site < /tmp/board_1.sql