maxwellflitton commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3368372238
> To add to this list: _know RDS provides backup, high availability and disaster recovery services._ and managed patching. Those are all the reasons we want to use RDS instead of just running on a VM/container. @jdanton if you run Postgres on an EC2, you can write the data to EBS and configure snapshots. This will be your recovery. You can then also have a cron job with PG Dump that can backup snapshots to s3 for your rollbacks. If you need to migrate to another bigger EC2, you spin up the new EC2, and use postgres logical replication to sync the DBs. When they're synced, you switch the route table to the new EC2 and kill the old one. If you have postgres running on localhost on the same machine, you're getting an order of magnitude speedup in transactions because you're not going through the network card, it's all in kernel memory. You can then install whatever you want, and even write your own extensions in C or Rust. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
