BUG #14304: WAL files pg_upgrade

From: furlongs(at)osti(dot)gov
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14304: WAL files pg_upgrade
Date: 2016-08-30 15:41:41
Message-ID: 20160830154141.15676.28819@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14304
Logged by: Shane Furlong
Email address: furlongs(at)osti(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2016-08-30 15:45:20 Re: BUG #14302: SQL with LIMIT degrades performance seriously
Previous Message Karl O. Pinc 2016-08-30 13:00:47 Re: [BUGS] BUG #14299: initdb and man pages are not installed in the alternatives system