girish R G peetle wrote: > 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) ? You can issue pg_start_backup on the primary, then take a file system backup of the standby, then run pg_stop_backup on the primary and collect the archived logs from the primary. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
