Greetings,
* Peter Eisentraut (peter.eisentr...@2ndquadrant.com) wrote:
> On 2019-09-23 10:25, Vikas Sharma wrote:
> > I am wondering which one is the best way to archive the xlogs for Backup
> > and Recovery - pg_receivexlog or archive_command.
>
> I recommend using pg_receivexlog. It has two i
Greetings,
* Vikas Sharma (shavi...@gmail.com) wrote:
> 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 xlo
On 2019-09-23 10:25, Vikas Sharma wrote:
> I am wondering which one is the best way to archive the xlogs for Backup
> and Recovery - pg_receivexlog or archive_command.
I recommend using pg_receivexlog. It has two important advantages over
archive_command: 1) You can have multiple instances of pg
Am 23.09.19 um 13:44 schrieb Luca Ferrari:
On Mon, Sep 23, 2019 at 10:55 AM Andreas Kretschmer
wrote:
you can use both of them, and you should consider "Barman".
If I remember well Barman uses pg_receivexlog when streaming, and
archive_command when doing a "normal" backup.
Barman < versio
On Mon, Sep 23, 2019 at 10:55 AM Andreas Kretschmer
wrote:
> you can use both of them, and you should consider "Barman".
If I remember well Barman uses pg_receivexlog when streaming, and
archive_command when doing a "normal" backup.
Also pgbackrest is another good tool for backup.
The idea here s
Am 23.09.19 um 10:25 schrieb Vikas Sharma:
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 a