Skip site navigation (1)
Skip section navigation (2)
I've inherited an application that creates a temp schema and stores a table for each user there.
Peripheral Links
Header And Logo
|
Site Navigation
pg_dumpall --exclude
- From: Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: pg_dumpall --exclude
- Date: Wed, 9 Jan 2008 09:27:07 -0600 (CST)
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? Richard Ray
- Follow-Ups:
- Re: pg_dumpall --exclude
- From: Bruce Momjian
- Re: pg_dumpall --exclude
- Prev by Date: data transfer/migrate from win to linux
- Next by Date: Re: data transfer/migrate from win to linux
- Previous by thread: data transfer/migrate from win to linux
- Next by thread: Re: pg_dumpall --exclude
- Indexes: