How to back-up Restore Postgres DB: 1. Access user postgres cho - TopicsExpress



          

How to back-up Restore Postgres DB: 1. Access user postgres cho thu muc backup file data $ chown root:postgres dbBackUp/ $ chmod 0777 -R dbBackUp/ $ sudo su postgres 2. dump all DB $ bash-4.1$ pg_dumpall -U postgres > /opt/dbFeosco/all.sql 3. Restore all /Library/PostgreSQL/9.1/bin/psql -f all.sql -p 5432 -h localhost 4. List all Database: /Library/PostgreSQL/9.1/bin/psql -h localhost -p 5432 -U postgres -l
Posted on: Fri, 14 Mar 2014 02:24:37 +0000

Trending Topics



Recently Viewed Topics




© 2015