From: Bruce Momjian <bruce@momjian.us>
To: Richard Ray <rray@mstc.state.ms.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dumpall --exclude
Date: Wed, 9 Jan 2008 22:07:44 -0500 (EST)
Message-ID: <200801100307.m0A37iZ02550@momjian.us> (raw)
In-Reply-To: <Pine.LNX.4.64.0801090921180.28696@rray.drdc.mstc.ms.gov>
Richard Ray wrote:
> I've inherited an application that creates a temp schema and stores
> a table for each user there.
> The data is temporary and does not need to be backed up.
> I run pg_dumpall each night.
> I can't just delete the tables because users may be working during the
> backup.
> Any suggestion on how to exclude the temp schema?
You don't say what version of Postgres you are using but 8.2 added this
feature:
* Allow complex selection of objects to be included or excluded by
pg_dump (Greg Sabino Mullane) pg_dump now supports multiple -n
(schema) and -t (table) options, and adds -N and -T options to
exclude objects. Also, the arguments of these switches can now be
wild-card expressions rather than single object names, for example
-t 'foo*', and a schema can be part of a -t or -T switch, for
example -t schema1.table1.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, rray@mstc.state.ms.us
Subject: Re: pg_dumpall --exclude
In-Reply-To: <200801100307.m0A37iZ02550@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox