deployment:postgresql
This is an old revision of the document!
Table of Contents
PostgreSQL - Dumping Data
Windows
cd "\Program Files\PostgreSQL\9.3\bin" pg_dumpall -Upostgres > data.bu
Linux
su - postgres pg_dumpall > data.bu exit
PostgreSQL - Restoring Data
Since you are restoring the whole database you will need to delete the database completely. So please remember to do a back up before you do so. Also, you must stop tomcat.
Windows
cd "\Program Files\PostgreSQL\9.3\bin" psql -Upostgres drop database da; \q psql -Upostgres < data.bu
Linux
su - postgres psql drop database da; \q psql < data.bu exit
/srv/www/htdocs/wiki/data/attic/deployment/postgresql.1407555803.txt.gz · Last modified: 2014/08/09 03:43 by asok
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
