> -----Original Message----- > From: Jeff Rhys-Jones [mailto:[EMAIL PROTECTED]] > Sent: 27 June 2002 17:36 > To: [EMAIL PROTECTED] > Subject: DB Backup / Restore with PG Admin 2? > > > Hi There, > > Sorry if this has been asked before, but what is the > recommended way of backing up and restoring databases with PGAdmin? > > Does the DB Schema copy everything? Can I then fully restore > a database from this schema? Backing up & restoring databases is *not* a job pgAdmin should be used for. The DB Schema dumps are there as a convenience when hacking designs about, however there may be errors in the code it generates because most of it is reverse-engineered from the system catalogues and I may have got something wrong. Perform your backups using pg_dump or pg_dumpall on the server. They are designed to dump the database *exactly* as it should be. Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
