From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'girish R G peetle *EXTERN*'" <giri(dot)anamika0(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup) |
Date: | 2015-08-26 07:30:18 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B50F9BE1A@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nima Azizzadeh | 2015-08-27 06:55:10 | two factor authentication for pgadmin iii |
Previous Message | girish R G peetle | 2015-08-26 07:01:11 | PostgreSQL Stand By Database Server backup (without using pg_basebackup) |