Hi Pierre, in my opinion it depends a bit from your setup, the workload and your goal. Since streaming replication offers near-realtime data view, you might go for that and offload your master too. Also consider that there are more options, like pg_logical, which is quite cool. regards, fabio pardi On 11/2/18 4:56 PM, Pierre Ochsenbein wrote: > Hey guy's, > > What is your best recommendation for a PostgreSQL HA with two nodes if I > use pgpool-II. > Warm standby or read only with streaming replication? > > Thanks >
