Re: pg_dump for values inserted in last day

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: vertigo <ax178(at)wp(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump for values inserted in last day
Date: 2004-11-25 16:44:36
Message-ID: 200411251144.37001.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-11-25 16:49:55 Re: Intermittent bug
Previous Message Tom Lane 2004-11-25 16:41:29 Re: problem installing 8.0.0beta5 on OS X 10.3