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