From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Strange times in WAL files in archive directory (9.3)
Date: Tue, 24 Jan 2017 08:29:10 -0500
Message-ID: <13126.1485264550@sss.pgh.pa.us> (raw)
In-Reply-To: <58873609.4030004@matrix.gatewaynet.com>
References: <58871A66.306@matrix.gatewaynet.com>
<58873609.4030004@matrix.gatewaynet.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> 1) Do you find this behavior normal?
It's normal operation. Once a WAL file is not needed anymore, it's
typically renamed into place to be a future WAL file; that's cheaper
than deleting the file and creating/filling a new one. So those ones
that have older timestamps do not contain useful data right this instant,
but they're ready to accept data once the write pointer advances to them.
> 2) From now on, can we assume a monotonic relation between file names and creation times in order to base our maintenance scripts on this?
I wouldn't. You risk deleting a file just as it starts to be used.
You could possibly look into pg_control to see the current LSN and
avoid touching any files >= that point, but of course this complicates
the maintenance logic quite a bit.
The larger issue here is that you're confusing the function of an archive
area with that of the active WAL directory. The server will prune what is
in the active WAL directory and does not want your help. In an archive
directory, I'd expect the files to have monotonic timestamps corresponding
to the times you copied them over to the archive, so you could rely on
the timestamp sequence there.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, achill@matrix.gatewaynet.com
Subject: Re: Strange times in WAL files in archive directory (9.3)
In-Reply-To: <13126.1485264550@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox