| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Anthony DeBarros <adebarros(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backup PostgreSQL from RDS straight to S3 |
| Date: | 2019-09-18 18:35:56 |
| Message-ID: | 66ea419a-2584-f3b7-d306-9df40beb267d@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-09-18 18:41:03 | Re: PostgreSQL License |
| Previous Message | Anthony DeBarros | 2019-09-18 18:32:12 | Backup PostgreSQL from RDS straight to S3 |