| From: | Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)bull(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to save and restore a template database ? |
| Date: | 2006-03-03 09:56:02 |
| Message-ID: | 440812B2.9020401@bull.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ragnar | 2006-03-03 09:59:00 | Re: query timeout |
| Previous Message | Michael Fuhr | 2006-03-03 09:14:40 | Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted |