Hi Ron,
> On 12 Mar 2025, at 21:50, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> No, I think it's 100% on point: logically replicate the Prod databases, while pg_dump/pg_restore of the dev and pre-prod databases happen on weekends.
Yes, I live for and in the company. 🤣 SNCR.
No, seriously, I'm one of only two PostgreSQL DBAs and our working capacity is limited by biological and other factors. Next tob working a normal day, capacities to to frequent things like these are limited.
Cheers,
Paul