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: 2008-01-09 15:27:07
Message-ID: Pine.LNX.4.64.0801090921180.28696@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Koczan 2008-01-09 18:43:24 Re: data transfer/migrate from win to linux
Previous Message Antonio Muñoz 2008-01-09 10:01:06 data transfer/migrate from win to linux