Re: pg_dump for values inserted in last day

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: pg_dump for values inserted in last day
Дата
Msg-id 200411251144.37001.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на pg_dump for values inserted in last day  (vertigo <ax178@wp.pl>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problem installing 8.0.0beta5 on OS X 10.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Intermittent bug