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.

2 Answers


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:


answered 2 years ago

First attach to v9 , upgarde the db to v11 and from this point you have the data on EBS ready for another detach-attach as v11

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions