Re: pg_dump for values inserted in last day - Mailing list pgsql-hackers

From Robert Treat
Subject Re: pg_dump for values inserted in last day
Date
Msg-id 200411251144.37001.xzilla@users.sourceforge.net
Whole thread Raw
In response to pg_dump for values inserted in last day  (vertigo <ax178@wp.pl>)
List pgsql-hackers
On Monday 22 November 2004 14:33, vertigo wrote:
> Hello
> I need to "pg_dump" my database, but i want only to receive sql commands
> which will insert row which were inserted into database today. Is there
> any way to do it ?
> I have large database and i want to make "incremential backups".
>

Daily pg_dump -a -d diffed against the preceeding day should give you 
something close.  Watch out for schema changes though. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem installing 8.0.0beta5 on OS X 10.3
Next
From: Tom Lane
Date:
Subject: Re: Intermittent bug