From: Chris Hoover <revoohc@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Why so long between archive calls?
Date: Fri, 1 Sep 2006 15:30:53 -0400
Message-ID: <1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com> (raw)
In-Reply-To: <24247.1157059093@sss.pgh.pa.us>
References: <1d219a6f0608290835u6647a8e1g437dfd4cedb81658@mail.gmail.com>
<44F4690D.2010503@mailnetwork.co.uk>
<1d219a6f0608290934g6d3ed785oa2814dbf3619306b@mail.gmail.com>
<1d219a6f0608301212k699061d0ge52c953ecc5bddfa@mail.gmail.com>
<24247.1157059093@sss.pgh.pa.us>
Tom,
I just ran this for several minutes and have about an 11MB trace file. Is
there anything particular you want to see?
Also, is the data in the file deciferable or have actual database data in
it? The reason I ask, is that I work under HIPPA regulations, so I can't
release anything if it has potential personal/patient data in it.
Chris
On 8/31/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Chris Hoover" <revoohc@gmail.com> writes:
> > Any other ideas? I am still 508 archive log files behind.
>
> Try "strace -f -p <pid>" on the archiver subprocess to see what it's
> doing and what the launched scripts are doing.
>
> 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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: revoohc@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Why so long between archive calls?
In-Reply-To: <1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com>
References: <1d219a6f0608290835u6647a8e1g437dfd4cedb81658@mail.gmail.com> <44F4690D.2010503@mailnetwork.co.uk> <1d219a6f0608290934g6d3ed785oa2814dbf3619306b@mail.gmail.com> <1d219a6f0608301212k699061d0ge52c953ecc5bddfa@mail.gmail.com> <24247.1157059093@sss.pgh.pa.us> <1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com>
* 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