Re: how can I exclude stuff from template in my dumps?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
Cc: "General Postgres Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how can I exclude stuff from template in my dumps?
Date: 2008-11-18 16:38:38
Message-ID: 20742.1227026318@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Harald Armin Massa" <haraldarminmassa(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scara Maccai 2008-11-18 16:49:35 MVCC and index-only read
Previous Message Erwin Moller 2008-11-18 16:34:06 Re: Foreign Key 'walker'?