DreamApps Wiki

   cd "\Program Files\PostgreSQL\9.3\bin"
   pg_dumpall -Upostgres > data.bu
   

   su - postgres
   pg_dumpall  > data.bu
   zip data.zip data.bu
   exit
   

The above will save the data in the folder /var/lib/pgsql

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.

   cd "\Program Files\PostgreSQL\9.3\bin"
   psql -Upostgres
   drop database da;
   \q
   unzip data.zip
   psql -Upostgres < data.bu
   

   su - postgres
   psql
   drop database da;
   \q
   psql < data.bu
   exit