Re: WAL files backup

Поиск
Список
Период
Сортировка
От Eduardo J. Ortega
Тема Re: WAL files backup
Дата
Msg-id 200702122156.43178.ejortegau@cable.net.co
обсуждение исходный текст
Ответ на WAL files backup  (pedro noticioso <cucnews@yahoo.com>)
Ответы Re: WAL files backup  (pedro noticioso <cucnews@yahoo.com>)
Список pgsql-admin
For what i understand, the WAL files only record changes to the database, so
each WAL segment is absolutely different from the previous one. As a matter
of fact, each WAL file is the incremental backup you want to make (provided
you have already taken a base or level 0 backup).

On Monday 12 February 2007 13:42, pedro noticioso wrote:
> hi there
>
> I lightly read this
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> and am interested in creating an incremental backup of
> WAL files, but my database is small so each of this
> WAL files must be almost identical to the previous
> one.
>
> Is there a way to incrementally backup so that it
> takes less space?
>
> thanks!
>
>
>
> ___________________________________________________________________________
>_________ Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find flight and
> hotel bargains. http://farechase.yahoo.com/promo-generic-14795097
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--
Eduardo J. Ortega - Linux user #222873
"No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus
Torvalds

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pid file problem
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: WAL files backup