up vote 0 down vote favorite
share [g+] share [fb]

Please refer to the diagram in the link below. While looking at my goals.

http://i.stack.imgur.com/GkVWb.png

GOAL:

  1. Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
  2. 'on site' have 'streaming replication' running between these DB's 'on-site' locations.
  3. 'on site' have fail-over to one of the 'on-site' 'slaves'.
  4. 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.

Thanks!

link|improve this question
You cannot use streaming replication between different OS. – a_horse_with_no_name Mar 15 at 17:22
@a_horse_with_no_name - CRAP - working on an edit will keep you posted. – cph Mar 15 at 17:28
@a_horse_with_no_name -- Ok now just streaming replication between XP units. – cph Mar 15 at 17:34
Should I be putting this in the ServerStack? – cph Mar 15 at 17:38
Did you go through the description in the manual? I got replication working by simply reading the manual: postgresql.org/docs/current/static/warm-standby.html – a_horse_with_no_name Mar 15 at 17:55
show 2 more comments
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.