Skip site navigation (1) Skip section navigation (2)

conditional backup

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 (view raw or flat)
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.


pgsql-admin by date

Next:From: Rob WultschDate: 2010-07-16 07:14:45
Subject: Re: postgres data permission
Previous:From: Craig JamesDate: 2010-07-16 00:18:46
Subject: Re: 8.3 to 8.4 - Can't load dynamic shared library

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group