Re: Is the a "magic number" for WAL files - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Is the a "magic number" for WAL files
Date
Msg-id CAEYLb_VmK-UMm7jjKVtP88+7aFw7ya-SErFNHeycPQ6tTHRX0Q@mail.gmail.com
Whole thread Raw
In response to Is the a "magic number" for WAL files  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On 9 December 2011 18:46, Rob Sargent <robjsargent@gmail.com> wrote:
> I would like the "file" command to tell me something other than "data",
> yes even though I can tell by the name (and the directory of course).
> Hoping someone has something I can slip into /usr/share/misc/magic.mgc
> or that directory.

You mean something like this?:

/*
 * Each page of XLOG file has a header like this:
 */
#define XLOG_PAGE_MAGIC 0xD068    /* can be used as WAL version indicator */

Obviously that isn't stable.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: OT DBA type question - GRANT PRIVILEGE
Next
From: Jack Christensen
Date:
Subject: Why does aggregate query allow select of non-group by or aggregate values?