| From: | Joby Joba <jobyjoba59(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | WARNING: transaction log file "....." could not be archived: too many failures |
| Date: | 2011-01-28 10:44:25 |
| Message-ID: | AANLkTikfgjyieKPAcezuvvro5=iXRD43xkN3Xe5E4b_5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello.
The following message appears continuously in the log file of postgresql :
Jan 28 11:35:01 abcd postgres[28359]: [81-1] LOG: archive command "cp
"pg_xlog/000000010000000000000085"
/u10/postgres/archive/"000000010000000000000085"" failed: return
Jan 28 11:35:01 abcd postgres[28359]: [81-2] code 256
Jan 28 11:35:02 abcd postgres[28359]: [82-1] LOG: archive command "cp
"pg_xlog/000000010000000000000085"
/u10/postgres/archive/"000000010000000000000085"" failed: return
Jan 28 11:35:02 abcd postgres[28359]: [82-2] code 256
Jan 28 11:35:03 abcd postgres[28359]: [83-1] LOG: archive command "cp
"pg_xlog/000000010000000000000085"
/u10/postgres/archive/"000000010000000000000085"" failed: return
Jan 28 11:35:03 abcd postgres[28359]: [83-2] code 256
Jan 28 11:35:03 abcd postgres[28359]: [84-1] WARNING: transaction log file
"000000010000000000000085" could not be archived: too many failures
The problem is that the requested file is not available anymore. How can I
tell postgres to bypass this file ?
Thanks
Joby
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernhard Schrader | 2011-01-28 13:09:46 | Re: pg_upgrade 8.3 to 9.0, shutdown is to slow |
| Previous Message | Frank Brendel | 2011-01-28 08:54:05 | Re: asm/ia64regs.h not found on FreeBSD 8.1 IA64 |