Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Please provide more details like postgres version and used operating systems. –  Thomas Berger Oct 17 '12 at 17:03
    
Appears to be a re-post of serverfault.com/questions/439636/postgresql-access-to-same-data –  Craig Ringer Nov 3 '12 at 14:10

1 Answer 1

Postgresql supports replication between two servers. http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

This can be done over the network between the two Postgresql installations running the two different servers.

But you can also run two instances of Postgresql on the same server (e.g one using the local disk and the other using the NAS storage). And configure replication between these instances.

share|improve this answer
    
thanks, i have already try this solution but when i access to the database on the nas from the secondary pc i don't found any data –  user1272305 Oct 17 '12 at 17:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.