Re: Clustering solution ?

On Thu, 9 Jul 2020 13:53:46 +0000 (UTC)
Laurent FAILLIE <l_faillie@yahoo.com> wrote:

> Hello,
> I've been asked by one of my customer to know which are the possible
> clustering solution for PostgreSQL ? Active/passive ?Active/active ?
> if possible free or not too expensive.

Start first by setting up safe and indestructible backups. Look at PITR
backups. Look at pg_backrest to help.

As soon as you have correct backups, you have DR.

Dig some more, optimize, and your PITR backup will be quite fast to restore.

If your RTO is not met with that, dig some more and then, we can talk about
HA, patroni and friends.

Regards,