How to save and restore a template database ?

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

Michael Fuhr wrote:

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?

Thanks Michael,
we use a 8.1.2 release and we first make tests to
understand how pg_dump works .The first test was without a template1
modified.

We redo this morning the test but with a modified template1,
and yes it works fine

Alexandra, Agn�s