Re: PostgreSQL 9.0.1 PITR can not copy WAL file

From: Christian Ullrich <chris(at)chrullrich(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.1 PITR can not copy WAL file
Date: 2011-01-19 11:56:47
Message-ID: ih6jhv$lic$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* 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
[... lots more ...]
> 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

Some possible reasons:

- 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ahmed Ossama 2011-01-19 12:20:28 Error during a dump (ts_selectivity, not found)
Previous Message lee Richard 2011-01-19 11:07:05 Some problem with the NOTIFY/LISTEN