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.
Hello,
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
Regards
Relevant questions
Multiple EBS volumes to gain perfomance
Accepted Answerasked 5 months agoHow to migrate only postgres data using EBS volumes
asked 2 months agodoes AWS DMS support partition tables from postgres
asked 5 months agoRedshift varchar(max) not enough to store json data type column from Postgres
asked 3 months agoRestriction on number of EBS volumes per EC2 ?
Accepted Answerasked 2 years agoUsing Amazon EBS for Data Lake
Accepted Answerasked 3 months agoMSK ebs snapshot
asked 2 years agoEBS gp3 volumes in Severely Degraded state
asked a month agoConditions to attach EBS volumes
asked a month agoUnable to delete ebs volumes
asked a month ago