Thread: pg_dump for values inserted in last day

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".

Thanx
Michal

Oops! vertigo <ax178@wp.pl> was seen spray-painting on a wall:
> 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".

This is a feature planned for addition fairly shortly to the Slony-I
replication system; it is pretty plausible that this will be the
quickest route to it...
-- 
output = reverse("gro.gultn" "@" "enworbbc")
http://linuxfinances.info/info/x.html
"Language shapes the  way we think   and determines what we can  think
about." -- Benjamin Whorf

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