Faster way of upgrading postgresql to 10 from 9.5

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Faster way of upgrading postgresql to 10 from 9.5
Date: 2017-11-25 03:34:46
Message-ID: CAF6DVKOZOqFPLFcnmxF6PU7j7NMkQN90jkb8af-gTRAyfZKZ_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Cross posting from stack-exchange
<https://dba.stackexchange.com/questions/191693/faster-way-of-upgrading-postgres-to-10-from-9-5>

*I am trying to test the migration of postgres to 10 from 9.5*

*On trying in a test DB of size 490 GB in one postgres node it is taking
about 18 mins. The command I used*

*sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_upgrade \*
* -b /usr/lib/postgresql/9.5/bin \*
* -B /usr/lib/postgresql/10/bin \*
* -d /var/lib/postgresql/data/postgresql0 \*
* -D /var/lib/postgresql/10/data/postgresql0 \*
* -o ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf' \*
* -O ' -c config_file=/etc/postgresql/10/main/postgresql.conf' -k *

*Is there any faster way of doing this?*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2017-11-25 04:06:08 RE: Faster way of upgrading postgresql to 10 from 9.5
Previous Message Debraj Manna 2017-11-24 05:53:16 Re: Status of the patch "Move PinBuffer and UnpinBuffer to atomics"