| From: | suhailck <suhailck(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | conditional backup |
| Date: | 2010-07-16 05:03:20 |
| Message-ID: | 29180107.post@talk.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I need to take backup of my postgresql DB, but not all records from a few
tables.
My DB contains more than 700 tables, out of which 15 tables i need to take
this conditional backup
Example:
Table: C_order
I need to take backup from table C_order where "period=2009" and "org <> A"
This is done to improve performance there by deleting all non-org records
for old period from org A's server.
Expecting ur feedbacks
Thanks in advance!!!
--
View this message in context: http://old.nabble.com/conditional-backup-tp29180107p29180107.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Wultsch | 2010-07-16 07:14:45 | Re: postgres data permission |
| Previous Message | Craig James | 2010-07-16 00:18:46 | Re: 8.3 to 8.4 - Can't load dynamic shared library |