Menu
I found this article explaining how to run MySQL on Amazon EC2. It talks about using XFS as the filesystem and then leveraging EBS snapshots to create backups of the data. Does anyone know if I can do something similar using PostgreSQL? Are there changes to the SQL commands to FLUSH and LOCK the tables? Thanks!
887
Originally implemented in version 9.2, snapshot exports allow multiple transactions to share identical views of the same database state.
Amazon EBS Snapshots are a convenient way to back up your EBS volumes. The snapshots are automatically saved to Amazon Simple Storage Service (Amazon S3) for long-term retention.
AWS supports PostgreSQL through a fully managed database service with Amazon Relational Database Service (RDS). Amazon Aurora with PostgreSQL compatibility is also built using PostgreSQL.
Snapshots can be used to create a backup of critical workloads, such as a large database or a file system that spans across multiple EBS volumes. Multi-volume snapshots allow you to take exact point-in-time, data coordinated, and crash-consistent snapshots across multiple EBS volumes attached to an EC2 instance.
Yes, that should work fine. As long as your data (all tablespaces) and pg_xlog are on the same device, it should just work. No need for any flushes or locking.
143
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
