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

Re: archive_command

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Kris Kiger <kris(at)musicrebellion(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: archive_command
Date: 2005-09-30 16:29:17
Message-ID: Pine.LNX.4.63.0509300926340.1280@discord.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 30 Sep 2005, Simon Riggs wrote:

> You don't say why you need to know?

Not sure why Kris needs to know, but I need to know for PITR and keeping the 
latest WAL file saved by a script which runs every few minutes as my client 
does not turn over WAL files very often (about 4/day).

> If you really care, you can look at the status files in the
> archive_status directory underneath pg_xlog. This is where the archiver
> checks to see for notifications of filled WAL files, then clears the
> notification afterwards. Only filled WAL filenames are shown.

I see lots of items like this:

0000000100000013000000A4.00AEE2F0.backup.done
0000000100000013000000DE.00B8A498.backup.done

I presume these correlate with the files in the pg_xlog directory that look 
like so:

0000000100000013000000A4.00AEE2F0.backup
0000000100000013000000DE.00B8A498.backup

0000000100000013000000DF
0000000100000013000000E0
0000000100000013000000E1
0000000100000013000000E2
0000000100000013000000E3
0000000100000013000000E4
0000000100000013000000E5
0000000100000013000000E6

Given that list, does that mean that 0000000100000013000000DF is the in use 
WAL file?

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-admin by date

Next:From: Tomeh, HusamDate: 2005-09-30 17:01:41
Subject: Re: Backing up several tables using pg_dump -t
Previous:From: RytisDate: 2005-09-30 16:14:44
Subject: data files corruption after server crash

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