Re: PostgreSQL upgrade.

On 10/04/19 8:20 PM, Andreas Kretschmer wrote:
>
>
> Am 10.04.19 um 07:40 schrieb Daulat Ram:
>> We have two node postgresql database version 9.6 with streaming
>> replication which is running on docker environment, os Linux (Ubuntu)
>> and we have to migrate on PostgresQL11. I need your suggestions &
>> steps to compete the upgrade  process successfully.
>
> there are exists several ways to do that. You can take a normal dump
> and replay it in the new version, you can use pg_upgrade, and you can
> use a logical replication (using slony, londiste or pg_logical from
> 2ndQuadrant). There is no 'standard way' to do that, all depends on
> your requirements and knowledge how to work with that tools.
>
>
>

The docker environment makes using pg_upgrade more difficult, as you
need to modify (or build a new) container with the old and new Postgres
versions installed. I'm interested in seeing how hard that would be
(will update this thread if I find anything useful).

regards

Mark