Re: [PATCHES] Forcing current WAL file to be archived - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [PATCHES] Forcing current WAL file to be archived
Date
Msg-id 1155279848.2350.12.camel@localhost.localdomain
Whole thread Raw
In response to Re: [PATCHES] Forcing current WAL file to be archived  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] Forcing current WAL file to be archived
List pgsql-hackers
On Thu, 2006-08-10 at 08:57 -0400, Tom Lane wrote:

> Anyway, after further thought I've concluded that we really should
> supply something that returns the Insert pointer, as this would be
> useful for debugging and system-monitoring purposes.  It's clear however
> that we also need something that returns the Write pointer, as that's
> what's needed for partial log-shipping.

> So my vote is for two
> functions, both read-only (and hence not superuser-only).

Thats probably the most important consideration.

> Not sure
> what to name them exactly.

pg_current_xlog_location() - gives the write pointer i.e. the offset up
to which you can read() the xlog file and trust what it tells you

pg_current_wal_insert_pointer() - gives the insert pointer :-)

Named sufficiently differently that there is no confusion between them.

--
  Simon Riggs
  EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] different sort order in windows and linux version
Next
From: Volkan YAZICI
Date:
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]