Clarification on start/stop backup
От | Scott Whitney |
---|---|
Тема | Clarification on start/stop backup |
Дата | |
Msg-id | cf774789-5676-4931-bff3-3508814ebc7d@zimbra.int.journyx.com обсуждение исходный текст |
Ответы |
Re: Clarification on start/stop backup
Migrating to PG 9.2 (LONG, SORRY) |
Список | pgsql-admin |
I'll be moving to PG9 (hopefully soon...probably 6 weeks). At that time, I'll be setting up hot-standby with streaming replication to 2 sites. Off-siting my pgdumps nightly is no longergoing to be possible in the very near future, due to the size of the dumps. So...what I had planned to do was setup my production 9.x, setup my streaming standby (same network) 9.x and setup my disasteroff-site (here at the office) also 9.x. Each one will do pg_dump at some point (nightly, probably) to ensure thatI've got actual backup files available at each location. Yes, they'll be possibly-inconsistent, but only with one another,and that's a very minor issue for the dump files. Now, when I do the directory rsync/tar (in this case tar), I can bring it up pretty quickly on the standby that is thereat the data center. However, of course, I need to also set it up here at my office. Which amounts to me driving backto the office, copying it over, and starting up PG (assuming I don't get interrupted 20 times walking in the door). So...something like this: SELECT pg_start_backup() tar off my pg directory SELECT pg_stop_backup() My question is this: Can I do stop_backup after I've tgzed to an external hard drive or do I have to wait to do stop_backup until both slavesare actually online? I _think_ that I'm merely telling the source db server that "I have my possibly-inconsistent file system backup, you cango back to what you were doing," and then when the slave(s) come up, they start replaying the WAL files until they catchup then use network communication to stay in sync. Is that a correct understanding of the process?
В списке pgsql-admin по дате отправления: