Re: WAL and archive disks full

Thank you.
Kieren

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