Postgres Pro
Downloads
Home   >   mailing lists

Re: how to take export of one year data from large database which contain 4 years of data. - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: how to take export of one year data from large database which contain 4 years of data.
Date
Msg-id n2c56d$b5a$1@ger.gmane.org
Whole thread Raw
In response to how to take export of one year data from large database which contain 4 years of data.  (clingareddy@vsoftcorp.com)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: how to take export of one year data from large database which contain 4 years of data.
Next
From: Dorian Machado
Date:
Subject: Re: interactif pg environnement script