Re: PostgreSQL 9.0.1 PITR can not copy WAL file

From: Christian Ullrich <chris(at)chrullrich(dot)net>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.1 PITR can not copy WAL file
Date: 2011-01-19 23:06:24
Message-ID: 4D376E70.2060701@chrullrich.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Magnus Hagander wrote:

> On Wed, Jan 19, 2011 at 19:20, Christian Ullrich<chris(at)chrullrich(dot)net> wrote:

>> So when PostgreSQL runs "copy 000...5E D:\...", it fails, and when you do
>> the same thing as the PostgreSQL user, it works. Interesting. Try increasing
>> the log level in postgresql.conf to see if it logs the error message from
>> copy, or try xcopy instead of copy.
>
> Note thatn when PostgreSQL runs, it will shed any rights given through
> "Administrators" or "Power Users" group. So this is not an identical
> test.

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.

tuanhoanganh, what did you download to install Postgres?

--
Christian

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2011-01-20 03:06:10 Re: possible error in documentation for 9.1
Previous Message Kevin Grittner 2011-01-19 22:59:17 Re: How to fire triggers just on "top" level DML