pg_xlog - files are guaranteed to be sequentialy named?

Поиск
Список
Период
Сортировка
От Johannes Konert
Тема pg_xlog - files are guaranteed to be sequentialy named?
Дата
Msg-id 466FEA5E.2000706@t3go.de
обсуждение исходный текст
Ответы Re: pg_xlog - files are guaranteed to be sequentialy named?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: pg_xlog - files are guaranteed to be sequentialy named?  (Frank Wittig <fw@weisshuhn.de>)
Список pgsql-general
Hi pgsql-list-members,
I currently write a small script that deletes outdated xlog-files from
my backup-location.
Because I do not want to rely on creation-date, I found it usable to use
the result of
ln | sort -g -r
Thus the newest WAL xlog-file is on top and I can delete all not needed
files at the bottom of the list.

My question: Is it for ALL cases guaranteed, that the naming of the
WAL-files in $PGDATA/pg_xlog always produces a "higher" number for a
newer file?
What happens if the 24hexdigits reach upper bound?

Thank your for your replies on that issue of postgresql inner working model.
Regards Johannes

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: setof or array as input parameter to postgresql 8.2 functions