Dear Eduardo ,
pg_dump --disable-triggers -U <user_name> -a -d -b -D -Fc -Z 9 -f <filername.tar.gz> <dbname>What is the most recommended way to backup a PostgreSQL database?
+
A file system backup could be done but for this you will have to shutdown PostgreSQL server
before filesystem backup is done
And to restore it?pg_restore --disable-triggers -U <user_name> -d <dbname> <backupfilename.tar.gz>
IN case of Filesystem backup just stop PostgreSQL and replace the Dumped or Tared file of the
filesystem
Links http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x17860%2ehtm And ofcource the PostgreSQL documentation itself
-- Best Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com [Soon http://www.saihertz.com] Yahoo IM: coeb_college[ a t ]yahoo.com
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
