From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kieren Scott <kierenscott@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: WAL and archive disks full
Date: Mon, 23 Aug 2010 20:17:02 -0400
Message-ID: <16189.1282609022@sss.pgh.pa.us> (raw)
In-Reply-To: <BAY149-w37FF7BF1B4AF50BC7289BCAE820@phx.gbl>
References: <BAY149-w37FF7BF1B4AF50BC7289BCAE820@phx.gbl>
Kieren Scott <kierenscott@hotmail.com> writes:
> [ hypothetical scenario: ]
> You can't start the instance because it needs to write to the WAL disk
> (which is full), but if you manually move WAL files off the WAL disk,
> the archiver will fail because it can't find WAL files it needs to
> archive.
Uh, no, that shouldn't be a problem. You can manually move the same WAL
files that the archiver would move. Look into the
pg_xlog/archive_status subdirectory. Any WAL files that have a ".ready"
file in there can be moved to archive, and then you delete the .ready
file, and you're good to go.
Of course, if you don't have any .ready files, you're going to need to
look elsewhere for some disk space to reclaim :-(
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, kierenscott@hotmail.com
Subject: Re: WAL and archive disks full
In-Reply-To: <16189.1282609022@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox