On Fri, Sep 15, 2017 at 01:23:45AM +0200, Andreas Joseph Krogh wrote: > I tested upgrading from 9.6 to 10 now, using pg_upgrade, and pg_upgrade > creates > the new data-dir with pg_wal "in it" (just like regular initdb), so pg_upgrade > seems not to care about where the old version's pg_xlog was. You have to move > (by symlinking) pg_wal to a separate location manually *after* running > pg_upgrade on the master. No special handling is needed when rsync'ing it over > to the standby, so it doesn't need any --hard-links or --size-only, correct?
What rsync is going to do is to reproduce the directory structure of the old cluster _in_ the standby's old cluster, and the structure of the new cluster on the standby's new cluster. If you had the WAL directory relocated in the new cluster, the relocation symbolic link will be reproduced by rsync, but the directory it points _to_ will not be copied, so it will point to nothing. Of course, of both old and new clusters share the same WAL directory, which I think is impossible, things would get very confusing quickly. I will reply to this now in a later email. -- Bruce Momjian <br...@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-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
