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?*
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" |