Re: pg_stop_backup running for 2h10m?

Поиск
Список
Период
Сортировка
От François Beausoleil
Тема Re: pg_stop_backup running for 2h10m?
Дата
Msg-id 9CC57302-10F8-4678-BBD3-028EC6B57051@teksol.info
обсуждение исходный текст
Ответ на Re: pg_stop_backup running for 2h10m?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Le 2013-04-24 à 09:15, hubert depesz lubaczewski a écrit :

> On Tue, Apr 23, 2013 at 03:08:52PM -0400, François Beausoleil wrote:
>> I used omnipitr to launch a base backup, but I fumbled a couple of
>> things, so I Ctrl+C'd *once* the console where I had
>> omnipitr-backup-master running. omnipitr-backup-master correctly
>> launched pg_stop_backup, but pg_stop_backup has been active for 2h10
>> minutes, as reported by pg_stat_activity.
>
> Most likely your archive_command is not doing its job. Why - hard to
> tell without knowing more about the setup, but that's the direction you
> should be looking in.

Yes, after looking at more logs, I found out I had a permission issue. I ran backup-master as root, and
omnipitr-archivewasn't able to write the the local backup directory. There should be a mention of who should run the
toolin the docs, as I was confused. 

Thanks!
François
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Regarding template1 database
Следующее
От: Alexander Reichstadt
Дата:
Сообщение: DISTINCT ON changes sort order