Postgres Pro
Downloads
Home   >   mailing lists

Re: how can I exclude stuff from template in my dumps? - Mailing list pgsql-general

From Tom Lane
Subject Re: how can I exclude stuff from template in my dumps?
Date
Msg-id 20742.1227026318@sss.pgh.pa.us
Whole thread Raw
In response to how can I exclude stuff from template in my dumps?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
Tree view 
"Harald Armin Massa" <haraldarminmassa@gmail.com> writes:
> Is there a clever way to exclude them from dumps or restores?

You're thinking about it backwards.  The correct way to deal with this
is to create the destination database for the restore from template0,
so that it doesn't have any of template1's additions.

            regards, tom lane

pgsql-general by date:

Previous
From: Pietro Tedesco
Date:
Subject: High Availability for PostgreSQL on Windows 2003.
Next
From: Scara Maccai
Date:
Subject: MVCC and index-only read