On Thu, Feb 12, 2015 at 11:13 AM, Andres Freund <and...@2ndquadrant.com> wrote: >>I started getting these errors after upgrading from 9.2.8 to 9.2.10. >>Is it something critical that requires version downgrade or I can just >>ignore that errors? > > What errors are you getting in precisely which circumstances? You're using > pg-receivexlog?
Errors like this one pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002AF000000B7.done": No such file or directory pg_receivexlog: disconnected.. on Linux xyz 3.2.0-76-generic #111-Ubuntu SMP PostgreSQL 9.2.10 Yes, I use pg_receivexlog. I also use a wrapper/watchdog script around pg_receivexlog which tracks failures and restarts the latter. The WAL files time correlates with the pg_receivexlog failures. postgres@xyz:~$ ls -ltr /mnt/archive/wal/ | tail -rw------- 1 postgres postgres 16777216 Feb 12 10:58 00000004000002B600000011 -rw------- 1 postgres postgres 16777216 Feb 12 11:02 00000004000002B600000012 -rw------- 1 postgres postgres 16777216 Feb 12 11:06 00000004000002B600000013 -rw------- 1 postgres postgres 16777216 Feb 12 11:11 00000004000002B600000014 -rw------- 1 postgres postgres 16777216 Feb 12 11:15 00000004000002B600000015 -rw------- 1 postgres postgres 16777216 Feb 12 11:19 00000004000002B600000016 -rw------- 1 postgres postgres 16777216 Feb 12 11:23 00000004000002B600000017 -rw------- 1 postgres postgres 16777216 Feb 12 11:27 00000004000002B600000018 -rw------- 1 postgres postgres 16777216 Feb 12 11:30 00000004000002B600000019 -rw------- 1 postgres postgres 16777216 Feb 12 11:32 00000004000002B60000001A.partial postgres@xyz:~$ cat /var/log/pgcookbook/manage_pitr-wal.log | tail Thu Feb 12 11:15:18 PST 2015 ERROR manage_pitr.sh: Problem occured during WAL archiving: pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002B600000015.done": No such file or directory pg_receivexlog: disconnected.. Thu Feb 12 11:19:33 PST 2015 ERROR manage_pitr.sh: Problem occured during WAL archiving: pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002B600000016.done": No such file or directory pg_receivexlog: disconnected.. Thu Feb 12 11:23:38 PST 2015 ERROR manage_pitr.sh: Problem occured during WAL archiving: pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002B600000017.done": No such file or directory pg_receivexlog: disconnected.. Thu Feb 12 11:27:32 PST 2015 ERROR manage_pitr.sh: Problem occured during WAL archiving: pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002B600000018.done": No such file or directory pg_receivexlog: disconnected.. Thu Feb 12 11:30:34 PST 2015 ERROR manage_pitr.sh: Problem occured during WAL archiving: pg_receivexlog: could not create archive status file "/mnt/archive/wal/archive_status/00000004000002B600000019.done": No such file or directory pg_receivexlog: disconnected.. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979 gray...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
