Re: Why so long between archive calls? - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Why so long between archive calls?
Date
Msg-id 1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com
Whole thread Raw
In response to Re: Why so long between archive calls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why so long between archive calls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Setting CLIENT_MIN_MESSAGES dynamically...  ("Eamonn Kent" <ekent@xsigo.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Andy Shellam
Date:
Subject: Re: problem with initlocation
Next
From: Tom Lane
Date:
Subject: Re: Why so long between archive calls?