up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

migrated from stackoverflow.com May 31 '11 at 17:15

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

1 Answer

up vote 3 down vote

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.

link|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 at 21:04
feedback

Your Answer

 
or
required, but never shown
discard