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

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 stackoverflow.com May 31 '11 at 17:15

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

1 Answer 1

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

 
discard

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