symlinks in pg_xlog to wal of previous timeline, after a failover

From: Purav Chovatia <puravc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: symlinks in pg_xlog to wal of previous timeline, after a failover
Date: 2018-01-11 17:49:13
Message-ID: CADrzpjGtcr6Fu0oQFU0t8HfO+hTgxgPN=cyw5Gt9q1q4bPQPXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

We have configured Streaming Replication and we see symlink in pg_xlog
pointing to another file with the previous timeline, in the same location.
This is happening after a failover. archiver errors while trying to copy
this file:
cp: cannot stat ‘pg_xlog/000000020000000000000075’: No such file or
directory
2018-01-11 23:08:24 IST LOG: archive command failed with exit code 1
2018-01-11 23:08:24 IST DETAIL: The failed archive command was: cp
pg_xlog/000000020000000000000075 /pgArch/edb/9.6/000000020000000000000075

-bash-4.2$ ls -ltr ../pg_xlog/000000020000000000000075
lrwxrwxrwx. 1 enterprisedb enterprisedb 24 Jan 9 16:50
../pg_xlog/000000020000000000000075 -> 000000010000000000000075
-bash-4.2$

Can somebody help understand why are these symlinks created and how to
overcome the situation?

Many Thanks

Browse pgsql-admin by date

  From Date Subject
Next Message Karl Denninger 2018-01-11 18:16:42 Re: Rolling forward to 10.1, new issue...
Previous Message Tom Lane 2018-01-11 17:48:47 Re: Rolling forward to 10.1, new issue...