To: pgsql-admin@postgresql.org, itdev <itdev@itdevel.internal.net>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Subject: pg_upgrade 9.0 -> 9.3 general questions : things to watch out for
Message-ID: <567A510A.1070903@matrix.gatewaynet.com>
Date: Wed, 23 Dec 2015 09:45:14 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hello List,

We just finished a test upgrade using pg_upgrade from 9.0 to 9.3, and the experience has been unexpectedly good! The database is just a tad smaller than 1TB, and the upgrade last only seconds, using 
the --link option.
I noticed that :
- Database specific options were correctly retained (e.g. bytea_output)
- Next XID was correctly transferred to the new cluster
I'd like to ask, if we can rely on the above assumptions during the actual migration on the production system.

Another consideration is --check. I didn't run it on the test system. Is it a requirement? A plus? The doc says about using it in conjunction with --link to do enable link-mode-specific checks. What 
does this do? From what I understand, running --check against the existing running older system enables doing some checks and allowing us to perform some preparation work in parallel before the actual 
final pg_upgrade invocation. Is this true? Can anyone shed some light on this?

Another question is about --retain (I didn't use it either in our test). I understand that it might transfer or make the links to the old pg_log directory. The doc says "retain SQL and *log* files 
*even* after a successful completion". What's the logic behind it? Why a special note on successful completion? If SQL logs are the regular pg_log files, then which are the other *log* files the doc 
mentions? Apparently it cannot be WAL (pg_xlog), since this is a different format than the old version, and would be of no use in the new data cluster, just like the older PITR archived WALs. So, 
what's the best practice regarding regular postgresql log file and pg_uprage? How about pg_xlog? Should we just scrap the old ones, move the new ones to the correct locations and re regenerate the 
symlinks ? Sounds fair, I think.

-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin