I have checked your solution.
- Target disk full : No
- PostgreSQL user does not have write privilege for the target directory : No
- Target file exists already (then you have a bigger problem) : Last file in D:/3SDATABACKUP/PITR/WAL is 00000001000000040000005D
- PostgreSQL user does not have full control privileges for the source
file (the copy command needs them) : i switch to user postgres an copy 00000001000000040000005E from source to d:\temp and create new text file on D:/3SDATABACKUP/PITR/WAL it is ok. No access denied
On Wed, Jan 19, 2011 at 6:56 PM, Christian Ullrich
<chris@chrullrich.net> wrote:
* tuanhoanganh wrote:
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: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: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
- Target disk full
- PostgreSQL user does not have write privilege for the target directory
- Target file exists already (then you have a bigger problem)
- PostgreSQL user does not have full control privileges for the source
file (the copy command needs them)
If you can stop your server, do so, then try to copy the file yourself on the command line. If that fails as well, you will get a better error message. If the server must stay up, copy the file to somwhere else on D: (assuming you don't have a volume mounted somewhere in the path).
If you can copy the file yourself, you have a permissions problem. Make sure the PostgreSQL service user has full control on both the source and target directories.
--
Christian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general