On 10/7/21 1:19 AM, Marco Lechner wrote:
Hi Adrian,
does this clearify the mission:
Recent:
PostgreSQL 11:
- Db1_foo
- Db2_bar
- postgres
- template1
PostgreSQL 12:
- Db3_zii
- Db4_gee
- postgres
- template1
Result after Upgrade:
PostgreSQL 14:
- Db1_foo
- Db2_bar
I would suggest you setup a new virtual server, LXC container or docker
instance with the new
version of pg14, pg_dump the old databases(one by one) and then import
them to the new ones.
That way, you do not have to mess with multiple installations of
Postgres and can use minimal
extra resour