| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Marco Lechner <mlechner(at)bfs(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: how to merge two postgresql server instances into one |
| Date: | 2021-10-06 15:32:55 |
| Message-ID: | d6bbe307-4c6d-b53b-5b41-8a4e6d2d12cf@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 context?
>
> The postgresql-14 instance does not exist yet (fresh install of
> postgresql-14 server packages). Using pg_upgrade to upgrade the larger
> one and pg_dumpall/pg_restore for the smaller one? Or are there any
> other nice recommended workflows?
>
> i.A. Dr. Marco Lechner
>
> Leiter Fachgebiet RN 1 │ Head RN 1
>
> --
>
> Bundesamt für Strahlenschutz │ Federal Office for Radiation Protection
>
> Koordination Notfallschutzsysteme │ Coordination Emergency Systems │ RN 1
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Millas | 2021-10-06 15:50:09 | Re: streaming replication different versions |
| Previous Message | Allie Crawford | 2021-10-06 15:06:38 | Re: [Ext:] Configuration of pgaudit settings in postgreSQL.conf causes postgreSQL to fail to start |