Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup)

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup)
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B50F9BE1A@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на PostgreSQL Stand By Database Server backup (without using pg_basebackup)  (girish R G peetle <giri.anamika0@gmail.com>)
Ответы Re: PostgreSQL Stand By Database Server backup (without using pg_basebackup)  (girish R G peetle <giri.anamika0@gmail.com>)
Список 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

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

Предыдущее
От: girish R G peetle
Дата:
Сообщение: PostgreSQL Stand By Database Server backup (without using pg_basebackup)
Следующее
От: Nima Azizzadeh
Дата:
Сообщение: Fwd: two factor authentication for pgadmin iii