Re: PostgreSQL upgrade. - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: PostgreSQL upgrade.
Date
Msg-id 7e7a988f-0493-8741-199e-529eb68a4d3e@a-kretschmer.de
Whole thread Raw
In response to PostgreSQL upgrade.  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses Re: PostgreSQL upgrade.
List pgsql-performance

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.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com




pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Commit(?) overhead
Next
From: Gunther
Date:
Subject: Out of Memory errors are frustrating as heck!