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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to take export of one year data from large database which contain 4 years of data.
Date: 2015-11-16 08:47:09
Message-ID: n2c56d$b5a$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

clingareddy(at)vsoftcorp(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dorian Machado 2015-11-16 11:12:47 Re: interactif pg environnement script
Previous Message Albe Laurenz 2015-11-16 08:31:39 Re: how to take export of one year data from large database which contain 4 years of data.