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 > \usr\tomcat\webapps\da\WEB-INF\data\data.bu
Linux
su - postgres pg_dumpall > /usr/tomcat/webapps/da/WEB-INF/data/data.bu
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.
Windows
cd "\Program Files\PostgreSQL\9.3\bin" psql -Upostgres < \usr\tomcat\webapps\da\WEB-INF\data\data.bu
Linux
su - postgres psql < /usr/tomcat/webapps/da/WEB-INF/data/data.bu
/srv/www/htdocs/wiki/data/attic/deployment/postgresql.1407555070.txt.gz · Last modified: 2014/08/09 03:31 by asok
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
