Skip to content

Docker compose scripts to help migrate data in batches from one column to another

Notifications You must be signed in to change notification settings

jango89/docker-compose-migrate-psql-column

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Migrate data from one column to another

Why

Example: The transactionId in a service seems increasing and during test there was out of range exception.

How to run migration

The script to update in batches is committed via flyway already. Just run docker-compose up --build to run the migration.

Configurations FYI

.env File - Customize the values.

pgpass.conf File - Please provide the "hostname:db_name:user:password" and do not commit.

sql_function.sql File - Needs to be commited to the database.

About

Docker compose scripts to help migrate data in batches from one column to another

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published