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

In PostgreSQL 9.0, can I configure the PostgreSQL not to replicate a certain database? I have three databases and I want to replicate only two.

share|improve this question

migrated from May 31 '11 at 17:15

This question came from our site for professional and enthusiast programmers.

No, you can't, that's not supported. PostgreSQL uses log shipping, so everything in WAL is shipped and processed on the slave.

Take a look at Slony, that will solve your problem.

share|improve this answer
Slony is the appropriate solution, so have an upvote. Having worked with it, however, I'd suggest that the OP do literally ANYTHING within their power to use Postgres 9's replication instead. Slony is an administrative tar-pit with extremely eccentric behavior, bizarre restrictions that mess you up at wierd times (no DDL without piping it through a special script, strange locking behavior, on and on), and a generally hellish threshold of reliability that is anything but enterprise-ready. I've admin'd Slony for relatively simple use cases for six months now, and I want that half a year back. – Zac B Apr 6 '12 at 21:04

Your Answer


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