BUG #14304: WAL files pg_upgrade

On Tue, Aug 30, 2016 at 03:41:41PM +0000, furlongs@osti.gov wrote:

The following bug has been logged on the website:

Bug reference: 14304
Logged by: Shane Furlong
Email address: furlongs@osti.gov
PostgreSQL version: 9.4.9
Operating system: centOS
Description:

My shop is running PostgreSQL 9.0 and pg_upgrading to 9.4.

Currently WAL files are saved in a location /pgsql/archive.

New WAL files will be stored in location /pgsql/archive94.

My question is how does pg_upgrade handle WAL files. It looks like to me
that pg_upgrade only addresses the data directory and not the archive
directory.

Is it necessary to flush all 9.0 WAL files prior to running pg_upgrade? Or
would one just copy the WAL files from the previous location to the new
location?

Any help or direction you can supply would be greatly appreciated.

pg_upgrade does _nothing_ with WAL. It does not copy it from the old
cluster to the new cluster, nor does it interact with the archive
directory.

I do recommend you use a _different_ directory to store the WAL after
the ugprade so the WAL file names don't conflict --- seems you are
already doing that. :-)

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +

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