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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: XLogArchivingActive


  • From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
  • To: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
  • Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Re: XLogArchivingActive
  • Date: Sat, 27 May 2006 13:51:50 +0200
  • Message-id: <44783D56(dot)3000405(at)pse-consulting(dot)de>

Jim C. Nasby wrote:


Also, regarding needing to place an archiver command in
pg_start_backup_online, another option would be to depend on the
filesystem backup to copy the WAL files, and just let them pile up in
pg_xlog until pg_stop_backup_online. Of course, that would require a
two-step filesystem copy, since you'd need to first copy everything in
$PGDATA, and then copy $PGDATA/pg_xlog after you have that.

Sounds fine. This solves the problem to insure that all required wal files are actually copied to the wal archive.

Regards,
Andreas



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group