Search Postgresql Archives

Re: PostgreSQL 9.0.1 PITR can not copy WAL file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* tuanhoanganh wrote:

I download postgresql from Enterprise DB

On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich <chris@xxxxxxxxxxxxxx
<mailto:chris@xxxxxxxxxxxxxx>> 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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux