Re: [ADMIN] pg_dumpall --exclude

2008-01-10 Thread Bruce Momjian
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 c

Re: [ADMIN] pg_dumpall --exclude

2008-01-10 Thread Richard Ray
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

Re: [ADMIN] pg_dumpall --exclude

2008-01-09 Thread Bruce Momjian
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. > An

[ADMIN] pg_dumpall --exclude

2008-01-09 Thread Richard Ray
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