Re: How to save and restore a template database ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET>
Cc: pgsql-general(at)postgresql(dot)org, Agnes Bocchino <agnes(dot)bocchino(at)BULL(dot)NET>
Subject: Re: How to save and restore a template database ?
Date: 2006-03-02 17:14:47
Message-ID: 20060302171447.GA7904@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-03-02 17:29:21 Re: Need a GNU SQL CLI tool for Win32 with ODBC support.
Previous Message Bruce Momjian 2006-03-02 16:39:23 Re: Question about "pg_upgrade"