Postgres Pro
Downloads
Home   >   mailing lists

Re: How to save and restore a template database ? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: How to save and restore a template database ?
Date
Msg-id 20060302171447.GA7904@winnie.fuhr.org
Whole thread Raw
In response to How to save and restore a template database ?  (DANTE ALEXANDRA <ALEXANDRA.DANTE@BULL.NET>)
Responses Re: How to save and restore a template database ?  (Agnes Bocchino <agnes.bocchino@bull.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Question about "pg_upgrade"
Next
From: Scott Marlowe
Date:
Subject: Re: Need a GNU SQL CLI tool for Win32 with ODBC support.