Backing up AWS RDS postgresql databases

[garybrowne]

Hello,
It's not clear to me if this can be used to backup an AWS RDS postgres database? The "links" and "depends_on" vars in docker compose lead me to believe this is just for containerised local dbs, but hopefully I am mistaken (as the use of psql seems to indicate that this utility would back up any postgres dbs on any host).
Can someone please clarify for me?
Thanks very much,
Gary

[prodrigestivill]

Yes, you can use this image, no need to use links nor depends_on.

Just configure the environment variables to point to your running PostgreSQL (running in RDS or elsewhere) and ensure the routing and firewalls (AWS security groups) allow the connections from this container.

Mainly you would need to setup the following in case you opt to use ECS:

• Environment variables:
  • POSTGRES_HOST: postgres RDS domain name
  • POSTGRES_DB
  • POSTGRES_USER
  • POSTGRES_PASSWORD: ideally using secrets
• Data Volumes: (ECS Storage Options)
  • A persistent volume (EBS, EFS, ...) to store the backups at /backups.

[prodrigestivill]

Also keep in mind you might also be interested in using the schickling/postgres-backup-s3 image.