> To: kierenscott@hotmail.com > CC: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] WAL and archive disks full > Date: Mon, 23 Aug 2010 20:17:02 -0400 > From: tgl@sss.pgh.pa.us > > 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 > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin