pg_xlog - files are guaranteed to be sequentialy named?

From: Johannes Konert <jkonert(at)t3go(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_xlog - files are guaranteed to be sequentialy named?
Date: 2007-06-13 13:00:14
Message-ID: 466FEA5E.2000706@t3go.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-06-13 13:09:56 Re: setof or array as input parameter to postgresql 8.2 functions
Previous Message Pavel Stehule 2007-06-13 12:55:13 Re: [SQL] setof or array as input parameter to postgresql 8.2 functions