From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dumpall --exclude |
Date: | 2008-01-10 03:07:44 |
Message-ID: | 200801100307.m0A37iZ02550@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(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 | johnf | 2008-01-10 07:29:31 | find the sequence name from schema, table, field |
Previous Message | Peter Koczan | 2008-01-09 18:43:24 | Re: data transfer/migrate from win to linux |