I have read that the streaming replication can be set up so the secondary receives the read only queries, but it is not clear to me how that is "turned on"? With Informix I used a connection manager to direct all read only traffic to the secondary. If I didn't specify the connection manager would still look at the activity on the servers and direct the selects to the secondary unless it was busier than the primary. How is this accomplished with PostgreSQL?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.