Skip site navigation (1) Skip section navigation (2)

Waiting for archive to complete

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Waiting for archive to complete
Date: 2007-06-25 21:18:00
Message-ID: 1182806280.3625.39.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-hackers
A number of people have complained that it is possible to make a base
backup and then shutdown the server before the last xlog file has been
archived. Others say they would like to be able to make a backup and
know it is complete.

Making the archiver continue while the file is archived can cause
problems when we do a restart, which has prevented some possible
solutions.

A simple solution is to introduce a new function:

pg_archive_wait(integer maxwait);
maxwait = 0 means wait forever, otherwise time measured in seconds.

This will get the current xlog position and wait for all files prior to
that point to be shown as archive done. Code to do this is very similar
to XLogArchiveCheckDone() in a wait loop, testing once per second.

Simple enough for this release?

Comments?

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



Responses

pgsql-hackers by date

Next:From: Chuck McDevittDate: 2007-06-25 21:35:01
Subject: libpq protocol version 2
Previous:From: Tom LaneDate: 2007-06-25 21:01:20
Subject: Re: Bugtraq: Having Fun With PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group