Re: [GENERAL] Logging the fact that a log was shipped

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: [GENERAL] Logging the fact that a log was shipped
Дата
Msg-id 20170828110630.tb4ealny7kq6voms@squirrel.exwg.net
обсуждение исходный текст
Ответ на [GENERAL] Logging the fact that a log was shipped  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: [GENERAL] Logging the fact that a log was shipped
Список pgsql-general
## Ron Johnson (ron.l.johnson@cox.net):

> How is this done in v8.4?  (I tried adding "date; rsync ..." but pg
> didn't like that *at all*.)

There's a DEBUG1-level log message on successful archive_command
completion - that would give you a lot of other low-prio log
messages wich you probably don't care about.
I'd put a wrapper around your rsync (a short shell script
would be sufficient) in the lines of rsync ... && logger "done",
that way you'd get the information via syslog.
On the other hand, do you really need the details about each WAL
segment? Since 9.4 there's pg_stat_wal_archiver... You're really
making your job harder than it needs to be with that ancient
PostgreSQL...

Regards,
Christoph

--
Spare Space.


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

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: [SPAM] Re: [GENERAL] Invalid magic number 0000 in log file
Следующее
От: Alban Hertroys
Дата:
Сообщение: [GENERAL] Performance with high correlation in group by on PK