On Thu, Mar 02, 2006 at 05:17:12PM +0100, DANTE ALEXANDRA wrote: > We have a question concerning backup / restore of database. > Is it right if we say that for having a complete backup, we have do : > 1. use pg_dumpall > 2. do a backup of the modified "template1" database with pg_dump ? > > Our question is how to save and restore a template database, as > "template1" ?
pg_dumpall should dump the modified contents of template1. Is it not doing so? What version of PostgreSQL are you using? -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
