PostgreSQL 9.0.1 PITR can not copy WAL file - Mailing list pgsql-general
From | tuanhoanganh |
---|---|
Subject | PostgreSQL 9.0.1 PITR can not copy WAL file |
Date | |
Msg-id | AANLkTimZij4NXWh+JEtdVo4W4FaNcdfFHh1-iJ8S5tJP@mail.gmail.com Whole thread Raw |
Responses |
Re: PostgreSQL 9.0.1 PITR can not copy WAL file
|
List | pgsql-general |
My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011 postgresql log have issue
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_19"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_49"."tmpct70s" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."kmtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."dmckcttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_58"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_53"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_120"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."dmckcttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."kmtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_22"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_18"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_15"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:54 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:54 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:55 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:55 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:56 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:56 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:56 ICT WARNING: transaction log file "00000001000000040000005E" could not be archived: too many failures
...
2011-01-06 08:28:56 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:56 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:57 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:57 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:58 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:58 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:58 ICT WARNING: transaction log file "00000001000000040000005E" could not be archived: too many failures
And my pg_xlog can not copy to D:/3SDATABACKUP/PITR/WAL from 06/01/2011. How to fix error ? Please help me
Here is my Archive
# - Archiving -
archive_mode = on # allows archiving to be done
# (change requires restart)
archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f' # command to use to archive a logfile segment
Thanks in advance
Tuan Hoang ANh
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_19"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_49"."tmpct70s" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."kmtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_34"."dmckcttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_58"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_53"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_120"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."dmckcttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_119"."kmtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_22"."dmgiabancttmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_18"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:48 ICT LOG: autovacuum: found orphan temp table "pg_temp_15"."cdvt13newtmp" in database "cpnvn_data"
2011-01-06 08:27:54 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:54 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:55 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:55 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:56 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:56 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:27:56 ICT WARNING: transaction log file "00000001000000040000005E" could not be archived: too many failures
...
2011-01-06 08:28:56 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:56 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:57 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:57 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:58 ICT LOG: archive command failed with exit code 1
2011-01-06 08:28:58 ICT DETAIL: The failed archive command was: copy pg_xlog\00000001000000040000005E D:/3SDATABACKUP/PITR/WAL/00000001000000040000005E
2011-01-06 08:28:58 ICT WARNING: transaction log file "00000001000000040000005E" could not be archived: too many failures
And my pg_xlog can not copy to D:/3SDATABACKUP/PITR/WAL from 06/01/2011. How to fix error ? Please help me
Here is my Archive
# - Archiving -
archive_mode = on # allows archiving to be done
# (change requires restart)
archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f' # command to use to archive a logfile segment
Thanks in advance
Tuan Hoang ANh
pgsql-general by date: