pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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: Thu, 10 Jan 2008 13:00:20 -0500 (EST)
Message-ID: <200801101800.m0AI0KU13124@momjian.us> (raw)
In-Reply-To: <Pine.LNX.4.64.0801100801120.12662@rray.drdc.mstc.ms.gov>

Richard Ray wrote:
> On Wed, 9 Jan 2008, Bruce Momjian wrote:
> 
> > 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:
> 
> sorry bout that, 8.2.5
> 
> >
> >     * 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.
> 
> I use pg_dumpall to get all changes to the server including users, groups, 
> etc.
> If I use pg_dump what might the command look like that would accomplish 
> the same as pg_dumpall

I am afraid you are going to have to use pg_dumpall --globals-only and
then loop each database running pg_dump with the flags you need.

The -t/-n flags were not added to pg_dumpall on the assumption that you
wouldn't be including/exclusing the same schemas/tables on every
database, so you have to do it per-database.

-- 
  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. +



view thread (4+ messages)

Message-ID: <200801101800.m0AI0KU13124@momjian.us>
Permalink:  ../200801101800.m0AI0KU13124@momjian.us/
Also on:    postgresql.org/message-id/200801101800.m0AI0KU13124@momjian.us

 · 

reply

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: <200801101800.m0AI0KU13124@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