Support for multiple databases

[chris-1o]

Thank you for this tool! It worked flawlessly for many upgrades!

However, I just found that it seems that only 1 database is migrated in a cluster during an upgrade.

When upgrading a cluster with two databases (say one and two) using:

sudo docker run --rm --name pgauto -it \
	--volume /opt/webapp-postgresql:/var/lib/postgresql:rw \
        --volume /opt/webapp-postgresql/data:/var/lib/postgresql/data:rw \
	-e POSTGRES_DB=one \
	-e POSTGRES_PASSWORD=** \
	-e POSTGRES_USER=postgres \
	-e PGAUTO_ONESHOT=yes \
	pgautoupgrade/pgautoupgrade:18-alpine

It results in only database one (successfully) available on the migrated cluster. Database two is left behind and not available on the upgraded cluster.

If I do not set POSTGRES_DB both are not migrated.

Is it possible to upgrade with multiple databases in the same cluster? Am I missing something?

[andyundso]

I think this is a scenario we did not test. when upgrading, a new cluster is created and therefore you only see one. I am not sure if all that is left at that point is to connect the second node into the cluster again?