New answers tagged high-availability
Yep, you don't need HAProxy with the newest versions pgpool-II. I'm not sure in which version it is introduced, but "watchdog" feature that is now embedded in pgpool does everything needed for automatic fialover and real HA. Take a look at this post - it'll help for sure.
I would investigate the following scenario: Setup a failover cluster to take care of the HA requirement and set up a third box with database mirroring to offload the reporting part. Take a look at these articles for more details: https://msdn.microsoft.com/en-us/library/ms191309(v=sql.120).aspx and ...
I see your point on not feeling the FCI usefull in this kind of setup. You could have 2 good servers on FCI with shared storage sharing the dbs and then automatic Failover and then configure the AGs for some of the databases to be replicated on a third sercer with not so good specs just to work as a read only replica and also allowing to balance some ...
You can have AGs within an FCI but I don't see the point (I mean when you do this you usually do away with the FCIs unless there was some specific requirement). In an AG the listener acts similar to a load balancer - kind of. If applications support using application intent read only in the connection string it can offload reads to the "passive" server. ...
Yes, it can be a good idea. In fact, allowing this was a major feature in the release of PostgreSQL 9.2.
Top 50 recent answers are included