From: | Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dumpall --exclude |
Date: | 2008-01-10 14:06:40 |
Message-ID: | Pine.LNX.4.64.0801100801120.12662@rray.drdc.mstc.ms.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://postgres.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-10 14:12:43 | Re: find the sequence name from schema, table, field |
Previous Message | Allan Kamau | 2008-01-10 12:32:42 | Re: using trigger (plpgsql) on table with default value in not null field.(solved) |