Re: Checkpoint Location Format

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Checkpoint Location Format
Дата
Msg-id 20061109070209.GE90133@nasby.net
обсуждение исходный текст
Ответ на Checkpoint Location Format  ("Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>)
Ответы Re: Checkpoint Location Format  ("Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>)
Список pgsql-admin
On Tue, Nov 07, 2006 at 01:12:53PM +0000, Andy Shellam (Mailing Lists) wrote:
> Hi,
>
> I'm writing an automated file-system level backup application for use
> with WAL archiving, that will issue the pg_start_backup call, tar and
> gzip the cluster data directory, issue the pg_stop_backup call, and
> remove all previous un-needed WAL files from the archive.
>
> I need to write a regular expression that will search for the WAL
> filename and checkpoint location from the backup_label file, and just
> want to clarify that the checkpoint location will always be of the
> format: X/XXXXXX - where X is one of 0-9, A-F?
>
> And then the WAL .backup file that is generated in the archive, has a
> filename of the form:
>
> <WAL_FILE>.00XXXXXX.backup
>
> where <WAL_FILE> is the name of the "STARTING WAL LOCATION" directive in
> the backup_label file, and XXXXXX is the last 6 digits of the checkpoint
> (after the / )?

I don't know the answer, but since no one's replied I suggest looking in
the code. Looking at the source of pg_start_backup would probably be a
good start, though I'm guessing the real answer is somewhere in the
backend.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Problems changing column attribute
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Manual sys catalog constraint setup to avoid downtime?