On 9/18/19 11:32 AM, Anthony DeBarros wrote:
> Hi, folks -- I'm a longtime PostgreSQL user but a bit of a noob when it
> comes to maintenance. Question:
>
> I'm running PostgreSQL 11 on Amazon RDS. Also have an EC2 box running
> Ubuntu that runs some Python scripts that collect data into PostgreSQL.
>
> We're doing the standard RDS backups. However, I'd also like to do a
> nightly pg_dump and store that file on S3. Is there a way to go straight
> from RDS to S3 without having to download the dump file onto the EC2 box
> at any point? I want to avoid a scenario where the DB file fills the EC2
> box's disk.
?:
https://dba.stackexchange.com/questions/221454/best-way-to-pg-dump-postgresql-on-rds-to-s3
>
> Thanks for any and all advice!
>
> Anthony
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com