pg_receivexlog or archive_command

Поиск
Список
Период
Сортировка
От Vikas Sharma
Тема pg_receivexlog or archive_command
Дата
Msg-id CAN6gwKwx865jv0fqc7SfwsG3utPhSoFF_tFaptcoDUW+T0uP8w@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_receivexlog or archive_command
Re: pg_receivexlog or archive_command
Re: pg_receivexlog or archive_command
Список pgsql-general
Дерево обсуждения
Hi,

I am wondering which one is the best way to archive the xlogs for Backup and Recovery - pg_receivexlog or archive_command.

pg_receivexlog seems best suited because the copied/archived file is streamed as it is being written to in xlog while archive_command only copies when the WAL is fully written to.

Best wishes
Vikas

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

Предыдущее
От: Corey Taylor
Дата:
Сообщение: Re: postgres 9.6: insert into select finishes only in pgadmin not psql
Следующее
От: Paul McGarry
Дата:
Сообщение: How to get timezone offset in timestamp with time zone AT TIME ZONE output.