X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1C7C89FB4D9 for ; Fri, 1 Sep 2006 18:27:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32951-04-5 for ; Fri, 1 Sep 2006 18:27:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.233]) by postgresql.org (Postfix) with ESMTP id E75C79FB6E7 for ; Fri, 1 Sep 2006 16:30:54 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so1157812wxc for ; Fri, 01 Sep 2006 12:30:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=fEmZw7J9TEg/j+8VAVy8lnMNCunovg4PKKjFgBUyz2y1bvY4gEUUVr9o6B+CqNZwxRpCC8s8rd4IPfLUyR1ZGWO5eUkJ1g4u1X29aAVhue7yeFeoQdS/zCQszVKnOEkw4Eks2ksr8FLxKIJgU8fBsT+Dqv4JgqMDfYW2omRC4qc= Received: by 10.70.87.9 with SMTP id k9mr954683wxb; Fri, 01 Sep 2006 12:30:53 -0700 (PDT) Received: by 10.70.73.10 with HTTP; Fri, 1 Sep 2006 12:30:53 -0700 (PDT) Message-ID: <1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com> Date: Fri, 1 Sep 2006 15:30:53 -0400 From: "Chris Hoover" To: "Tom Lane" Subject: Re: Why so long between archive calls? Cc: pgsql-admin@postgresql.org In-Reply-To: <24247.1157059093@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_93745_26851780.1157139053354" References: <1d219a6f0608290835u6647a8e1g437dfd4cedb81658@mail.gmail.com> <44F4690D.2010503@mailnetwork.co.uk> <1d219a6f0608290934g6d3ed785oa2814dbf3619306b@mail.gmail.com> <1d219a6f0608301212k699061d0ge52c953ecc5bddfa@mail.gmail.com> <24247.1157059093@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.95 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/13 X-Sequence-Number: 22927 ------=_Part_93745_26851780.1157139053354 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 wrote: > > "Chris Hoover" writes: > > Any other ideas? I am still 508 archive log files behind. > > Try "strace -f -p " on the archiver subprocess to see what it's > doing and what the launched scripts are doing. > > regards, tom lane > ------=_Part_93745_26851780.1157139053354 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_93745_26851780.1157139053354--