Re: PostgreSQL 9.0.1 PITR can not copy WAL file - Mailing list pgsql-general

From Christian Ullrich
Subject Re: PostgreSQL 9.0.1 PITR can not copy WAL file
Date
Msg-id 4D397F56.7030501@chrullrich.net
Whole thread Raw
In response to Re: PostgreSQL 9.0.1 PITR can not copy WAL file  (tuanhoanganh <hatuan05@gmail.com>)
List pgsql-general
* tuanhoanganh wrote:

> I download postgresql from Enterprise DB
>
> On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich <chris@chrullrich.net
> <mailto:chris@chrullrich.net>> wrote:

>     We cannot assume that the one-click installer was used, but if it
>     was, the service account it creates will be a member of the Users
>     group only.

And, to confirm, when you did the copy yourself, you were logged on as
the "postgres" user that was created during the installation? Then
please recheck that the user the PostgreSQL service is running as does
in fact have:

- full control permissions for the source directory (data and all
   subdirs)

- full control permissions for the target directory (WAL)

- at least "read and execute" permissions for all directories from the
   D: root down to the PITR directory

If you have enabled disk quotas, make sure that the postgres user has
not reached the quota limit on the D: drive.

Have you had any luck with xcopy instead of copy, or has procmon found
out which operation actually fails?

--
Christian


pgsql-general by date:

Previous
From: Ivan Voras
Date:
Subject: Copying databases with extensions - pg_dump question
Next
From: "Andrus"
Date:
Subject: Server stops responding in every week