From: mike g <mike@thegodshalls.com>
To: h_harush@hotmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Dumping partial database content
Date: Thu, 01 Jul 2004 23:10:33 -0500
Message-ID: <1088741432.23457.30.camel@localhost.localdomain> (raw)
In-Reply-To: <3b30f7df.0406300407.2b192621@posting.google.com>
References: <3b30f7df.0406300407.2b192621@posting.google.com>
I don't believe there is an option in pg_dump that current handles
that. It is the whole table / object or nothing at all. Depending on
the volume of transactions and frequency that you need to dump the data
will determine which solution works best for you.
Heavy volume and/or dumps multiple times per hour: Replication would
probably be the best solution-perhaps Slony.
Occasionaly or small volume: A Perl script / cron job that executes a
SELECT * FROM x WHERE date > $passed parameter when calling the script.
One time: Use pgadminIII or psql to execute a SELECT query and direct
the results into a file.
Mike
On Wed, 2004-06-30 at 07:07, h_harush@hotmail.com wrote:
> Hi,
>
> I need to dump only partial content of my database, for example i want
> to dump only records that has been insterted to the database from a
> specific date.
> I tried to use pg_dump/pg_export but did not find anything usefull.
>
> I'm using postgres version 7.3 on Linux RH 7.3
>
> any idea/direction ?
>
> Regards,
> Hanan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@thegodshalls.com, h_harush@hotmail.com
Subject: Re: Dumping partial database content
In-Reply-To: <1088741432.23457.30.camel@localhost.localdomain>
References: <3b30f7df.0406300407.2b192621@posting.google.com> <1088741432.23457.30.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox