| From: | Purav Chovatia <puravc(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
| Subject: | symlinks in pg_xlog to wal of previous timeline, after a failover |
| Date: | 2018-01-16 14:50:55 |
| Message-ID: | CADrzpjF2NB-SUz868ODXyKOcB0i2=sqON9aLFpH_+=roK7jFiw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | john snow | 2018-01-17 01:59:57 | why do i get 2 as answer for select length('aa '::char(6)); |
| Previous Message | David Rowley | 2018-01-16 14:24:42 | Re: missing FROM-clause entry for table bbbb |