We are running PG 8.4.4 on Suse 9 and would like to set up a master/slave configuration but have the following
requirements:
- we want to be able to freeze the slave and only force it to update 'on demand'
- we have data in other schemas in the slave database that we would like to preserve
The master and slave will exist on different servers if that helps. The master DB is roughly 40 GB in size. I realize
wecould do a dump on master and restore to slave, but it seems like there might be a more elegant and efficient
solution.
Does anyone have any recommendations about the best replication solution given these requirements?
Thanks in advance
Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are
notthe addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or
copyingof this communication is strictly prohibited. If you have received this e-mail in error, please notify the
senderof the error.