Re: pg_basebackup
| От | desmodemone |
|---|---|
| Тема | Re: pg_basebackup |
| Дата | |
| Msg-id | CAEs9oFmxyDoNtKmSMz1tY-6U9EDqYi6Xdc1ac3J7yNM1XtoWjA@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_basebackup (Murthy Nunna <mnunna@fnal.gov>) |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: