Hey all, I have a question about streaming replication available in PG 9+
The general configuration I see is along the lines of this:
Where you do the file system backup and restore. However, our current
server I wish to make master has a 75GB database. I can't take the server
down, and I can't run rsync against the live DB.
What are my options? I don't care if it takes a day or two for the slave to
get up to sync w/ the master: is there some way to have an empty DB read an
entire log that has everything?
I could also do a pg_restore to the new slave from last night's DB backup,
but I understand (at least, I seem to read it) that you can't bring a slave
up using pg_restore.
Are there any other options I am missing? Thanks for any tips.
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2012-04-10 18:38:56|
|Subject: Re: Setting up streaming replication w/ a big ole database|
|Previous:||From: Kevin Grittner||Date: 2012-04-10 15:19:19|
|Subject: Re: Why would queries fail with 'could not stat file'