postgresql solution for a server failure
- by user1272305
i describe the situation:
i have two pc with postgressql server:
- a main pc, with ip 192.168.5.1 turned on
- a "backup" pc, with ip 192.168.5.1 turned off
i want that the main pc saves the two identical databases in local hard drive and on a nas real-time. when the main pc has a failure, i turn on, manually, the secondary pc, that reads the database from the nas
it's possible to do that?
postgres: postgresql-9.1
operating system: Ubuntu 10.04