Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump

2021-10-18 Thread Chris Williams
, but I'm unsure how much their regular Postgres offering differs, if at all. Thanks, Chris On Mon, Oct 18, 2021 at 8:05 PM Tom Lane wrote: > 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 t

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 serv

Re: Slow shutdowns sometimes on RDS Postgres

2018-09-14 Thread Chris Williams
u are doing ("(e.g. reboot, changing instance > > size, etc.)") are instance operations not database operations. That > > comes under AWS's purview. > > Correct, managing reboots and hardware reconfigurations would be the > responsibility of AWS. However Chris' i

Re: Slow shutdowns sometimes on RDS Postgres

2018-09-13 Thread Chris Williams
nually shutting down all of my apps ahead of time is a real headache. Given that I haven't gotten anywhere with their support, I figured I'd try asking on the mailing list. Thanks, Chris On Thu, Sep 13, 2018 at 3:17 PM Joshua D. Drake wrote: > On 09/13/2018 03:04 PM, Chris William

Slow shutdowns sometimes on RDS Postgres

2018-09-13 Thread Chris Williams
Hi, I'm using AWS RDS Postgres (9.6.6) and have run into very slow shutdowns (10+ minutes) a few times when making database modifications (e.g. reboot, changing instance size, etc.). Other times, it shuts down quickly (1 minute or so). I have not been able to figure out why sometimes it takes a