Обсуждение: pg_basebackup

Поиск
Список
Период
Сортировка

pg_basebackup

От
Murthy Nunna
Дата:

All,

 

I am looking for a script I can use to perform pg_basebackup.

 

I want to take basebackup (zip and tar) and also capture all WALs generated during basebackup and append them to basebackup tar. I know I can use –X flag with –s or –f . Problem is with “f” flag sometimes I find that the WAL required is deleted (archived) as mine is a large database and also activity is high. And “s” flag is not supported with tar backup.

 

I can record start time and end time of backup and go to my archive directory and append them to tar backup. But I am wondering if someone out there may be already doing this and willing to share the script (Unix/shell script please)

 

Thanks,

Murthy

Re: pg_basebackup

От
desmodemone
Дата:



2014-02-18 17:58 GMT+01:00 Murthy Nunna <mnunna@fnal.gov>:

All,

 

I am looking for a script I can use to perform pg_basebackup.

 

I want to take basebackup (zip and tar) and also capture all WALs generated during basebackup and append them to basebackup tar. I know I can use –X flag with –s or –f . Problem is with “f” flag sometimes I find that the WAL required is deleted (archived) as mine is a large database and also activity is high. And “s” flag is not supported with tar backup.

 

I can record start time and end time of backup and go to my archive directory and append them to tar backup. But I am wondering if someone out there may be already doing this and willing to share the script (Unix/shell script please)

 

Thanks,

Murthy



Hello Murthy,
                         you have a lot of possibilities :
0) you could simple use more wal_keep_segments  so the wall will not disappear
1) switch from tar to plain mode and use -s method

other backup method :

0) create a async streaming replica and use snapshot  on the standby side
1) pg-rman http://code.google.com/p/pg-rman/
2) barman  http://www.pgbarman.org/


Bye

Mat Dba