2

I want to use pgpool to replicate one database to another. I want to do my processing on my master database (reads/writes/inserts/deletes), replicate that database to another database as it is modified and have other reads be directed to the replicated database.

As I read the pgpool documentation it appears that reads will be distributed across all databases in the cluster. Is there a way to not do that and direct one class of reads to one database and another class of read/writes to the master?

1 Answer 1

2

No, pgpool is an all or nothing solution. All you can control is the precentage of read queries going to each host, not what kinds of (read) queries.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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