Postgres Pro
Downloads
Home   >   mailing lists

how to merge two postgresql server instances into one - Mailing list pgsql-general

From Marco Lechner
Subject how to merge two postgresql server instances into one
Date
Msg-id 5c0755626e364831849d20919f394a3a@bfs.de
Whole thread Raw
Responses Re: how to merge two postgresql server instances into one
List pgsql-general
Tree view

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 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

pgsql-general by date:

Previous
From: Joao Miguel Ferreira
Date:
Subject: Re: pg_dump save command in output
Next
From: Philippe Doussot
Date:
Subject: idle_in_transaction_session_timeout