PostgreSQL Stand By Database Server backup (without using pg_basebackup) - Mailing list pgsql-admin

From girish R G peetle
Subject PostgreSQL Stand By Database Server backup (without using pg_basebackup)
Date
Msg-id CAKKd066P9SX7DzX7s47dCzJV5gJchJz_+zGUNsPAbrWOKerteA@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup)
List pgsql-admin
Hi, 
We want to perform File System based backup of PostgreSQL Standby Database server.
 
For Primary server we perform backup of data directory after invoking  pg_start_backup, once this is done, execute pg_stop_backup and backup archived transaction logs.

We are not able to follow same procedure for Standby server as pg_start_backup and pg_stop_backup cannot be executed on stand by.
 
I am aware that pg_basebackup utility can be used to perform backup of standby but we don't want to use this utility. ( As backup of data directory is handled by third party backup vendor)

In this case what is the recommended way to backup standby database server (without using pg_basebackup utility) ?

Thanks
Girish

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: installing Libxml on running postgres server
Next
From: Albe Laurenz
Date:
Subject: Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup)