Please refer to the diagram in the link below. While looking at my goals.
- Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
- 'on site' have 'streaming replication' running between these DB's 'on-site' locations.
- 'on site' have fail-over to one of the 'on-site' 'slaves'.
- between 'master' 'on site' and 'slave data warehouse' I'll just pull log files.
I've read a bunch about Linux but haven't found much about Windows XP. All the machines 'on site' have the same hardware. Unfortunately I can't use linux in the 'on site' environment.
Again been googling but not finding much anyone know of a good tutorial(s) to get this type of setup pieced together!
I'm going to keep looking and if I find anything I'll make sure to post it back here.