Database 썸네일형 리스트형 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.. 더보기 이전 1 다음