Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In my scenario I want pgpool to forward read only queries to slaves when the master goes down - I want my app to be in the "read only mode".

How do I setup pgpool to accept read only queries when master fails (streaming replication) ?

Currently I when the master goes down, pgpool waits for the master and doesn't forward any queries to slaves.

share|improve this question
    
I suspect you'll need to switch to routing read/write vs read-only queries at the application level to do this. –  Craig Ringer Aug 14 '13 at 10:31
add comment

migrated from stackoverflow.com Aug 19 '13 at 3:41

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.