Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump

2021-10-18 Thread Tom Lane
Chris Williams writes: > Thanks Tom. It's a strange one for sure. Hopefully AWS support will shed > some light on it. I will clarify too that this is the regular RDS Postgres > version and not their other Aurora Postgres service. I suspect the Aurora > Postgres probably differs from the

Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump

2021-10-18 Thread Chris Williams
Thanks Tom. It's a strange one for sure. Hopefully AWS support will shed some light on it. I will clarify too that this is the regular RDS Postgres version and not their other Aurora Postgres service. I suspect the Aurora Postgres probably differs from the community version by quite a bit, but

Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump

2021-10-18 Thread Tom Lane
Chris Williams writes: > We have a script that runs a pg_dump off of an RDS PG13.3 replica several > times per day. We then load this dump using pg_restore into another > postgres RDS db in another AWS account, scrub some of the data, and then > take a snapshot of it. Hmm ... I'm fairly sure

Unsynchronized parallel dumps from 13.3 replica produced by pg_dump

2021-10-18 Thread Chris Williams
Hi, We have a script that runs a pg_dump off of an RDS PG13.3 replica several times per day. We then load this dump using pg_restore into another postgres RDS db in another AWS account, scrub some of the data, and then take a snapshot of it. We then use these snapshots for testing and staging