conditional backup

Поиск
Список
Период
Сортировка
От suhailck
Тема conditional backup
Дата
Msg-id 29180107.post@talk.nabble.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rob Wultsch
Дата:
Сообщение: Re: postgres data permission
Следующее
От: Robert Voinea
Дата:
Сообщение: Weird sorting order