Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i describe the situation: i have two pc with postgressql server: - a main pc, with ip turned on - a "backup" pc, with ip 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 – Craig Ringer Nov 3 '12 at 14:10

Postgresql supports replication between two servers.

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


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.