Backup PostgreSQL from RDS straight to S3

From: Anthony DeBarros <adebarros(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Backup PostgreSQL from RDS straight to S3
Date: 2019-09-18 18:32:12
Message-ID: CAAQFaFLH7WGZxBmJgkfjZy9LEQxN5L3zLnY1+KmE3AM03SHNkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks for any and all advice!

Anthony

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-09-18 18:35:56 Re: Backup PostgreSQL from RDS straight to S3
Previous Message Rob Sargent 2019-09-18 18:23:51 Re: PostgreSQL License