Re: archiver process problem

From: "Scot Kreienkamp" <SKreien(at)la-z-boy(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: archiver process problem
Date: 2010-10-18 17:24:02
Message-ID: 59E62072D4EFFF4BB912EC607F8FA60B01D43025@lzbs6304.na.lzb.hq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Never mind, it picked up again. It took a few hours, not sure why.

Scot Kreienkamp

skreien(at)la-z-boy(dot)com

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Scot Kreienkamp
Sent: Monday, October 18, 2010 11:29 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] archiver process problem

Hey guys,

My archive became unavailable for a short while, causing the archiver
process to stop copying files out. Now it seems to be stuck although
the archive location is available again.

This is from ps -ax: postgres: archiver process last was
0000000100000323000000F8

How do I wake up the archiver process again so it starts copying files
out, short of restarting postgres? Running PG 8.3.7.

Thanks!

Scot Kreienkamp

skreien(at)la-z-boy(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-10-18 18:08:00 PgWest 2010: Two weeks away
Previous Message Scott Marlowe 2010-10-18 16:11:14 Re: How to find which query are doing seq_scan