Re: PostgreSQL upgrade.
Mark Kirkwood <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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