How to migrate only postgres data using EBS volumes
Our application stores metadata in postgres database. We are using AWS ebs volumes for postgres data for persistent storage. We attach and detach this EBS volumes to AWS instance when needed. AWS instance is destroyed when not needed and will create new one when needed. EBS volume will be attached when new instance is created. The problem is, when ebs volume is detached postgres version is 9.x. While attaching EBS volume to new instance, postgres version in the new instance is 11.x. How to migrate the postgres data from 9.x to 11.x in the ebs volumes where new instance has 11.x version postgres version installed.
I assume this is a self-managed postgres database? You'll need to upgrade the database from v9 to v11, you cannot just use the database files created in one version from another db engine version.
You can refer to this documentation for instructions for example: https://www.postgresql.org/docs/11/pgupgrade.html
Multiple EBS volumes to gain perfomanceAccepted Answerasked 5 months ago
How to migrate only postgres data using EBS volumesasked 2 months ago
does AWS DMS support partition tables from postgresasked 5 months ago
Redshift varchar(max) not enough to store json data type column from Postgresasked 3 months ago
Restriction on number of EBS volumes per EC2 ?Accepted Answerasked 2 years ago
Using Amazon EBS for Data LakeAccepted Answerasked 3 months ago
MSK ebs snapshotasked 2 years ago
EBS gp3 volumes in Severely Degraded stateasked a month ago
Conditions to attach EBS volumesasked a month ago
Unable to delete ebs volumesasked a month ago