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
user/roles from both PG11 and PG12 copied to PG14. -Ursprüngliche Nachricht- Von: Adrian Klaver Gesendet: Mittwoch, 6. Oktober 2021 17:33 An: Marco Lechner ; pgsql-general@lists.postgresql.org Betreff: Re: how to merge two postgresql server instances into one WARNUNG: Diese E-Mail kam

AW: how to merge two postgresql server instances into one

2021-10-07 Thread Marco Lechner
-general@lists.postgresql.org Betreff: Re: how to merge two postgresql server instances into one WARNUNG: Diese E-Mail kam von außerhalb der Organisation. Klicken Sie nicht auf Links oder öffnen Sie keine Anhänge, es sei denn, Sie kennen den/die Absender*in und wissen, dass der Inhalt sicher ist

Re: how to merge two postgresql server instances into one

2021-10-06 Thread Adrian Klaver
On 10/6/21 2:58 AM, Marco Lechner wrote: Hi, how to merge two postgresql server instances into one? I have a postgresql-11 and -12 instance on my server and want to upgrade both (pg_upgrade?) into one postgresql-14 instance. The bigger issue will be the merge. Define what that means in this

how to merge two postgresql server instances into one

2021-10-06 Thread Marco Lechner
Hi, how to merge two postgresql server instances into one? I have a postgresql-11 and -12 instance on my server and want to upgrade both (pg_upgrade?) into one postgresql-14 instance. The postgresql-14 instance does not exist yet (fresh install of postgresql-14 server packages). Using