Re: how to take export of one year data from large database which contain 4 years of data.

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: how to take export of one year data from large database which contain 4 years of data.
Дата
Msg-id n2c56d$b5a$1@ger.gmane.org
обсуждение исходный текст
Ответ на how to take export of one year data from large database which contain 4 years of data.  (clingareddy@vsoftcorp.com)
Список pgsql-admin
Дерево обсуждения 
clingareddy@vsoftcorp.com schrieb am 16.11.2015 um 09:17:
> My database contains 4 years of data, but i want to migrate only one year i.e 2015 of data to another database.
>
>
> Please help me how to take export of one year data. Is there any bus_date condition we can use while exporting?

I have never used this, but Jailer claims to support exporting a (logical) subset of a database:

http://jailer.sourceforge.ne

Thomas

В списке pgsql-admin по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: how to take export of one year data from large database which contain 4 years of data.
Следующее
От: Dorian Machado
Дата:
Сообщение: Re: interactif pg environnement script