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