Re: Why so long between archive calls?

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Re: Why so long between archive calls?
Дата
Msg-id 1d219a6f0609011230t2407cba5u53a5e536ad4fbc20@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why so long between archive calls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Why so long between archive calls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Setting CLIENT_MIN_MESSAGES dynamically...  ("Eamonn Kent" <ekent@xsigo.com>)
Список 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 по дате отправления:

Предыдущее
От: Andy Shellam
Дата:
Сообщение: Re: problem with initlocation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why so long between archive calls?