Re: AW: how to merge two postgresql server instances into one

2021-10-07 Thread Adrian Klaver
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

Re: AW: how to merge two postgresql server instances into one

2021-10-07 Thread Heikki Pernu
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

AW: how to merge two postgresql server instances into one

2021-10-07 Thread Marco Lechner
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 - Db3_zii - Db4_gee - postgres (not from PG11/