Re: PostgreSQL 9.0.1 PITR can not copy WAL file

From: tuanhoanganh <hatuan05(at)gmail(dot)com>
To: Christian Ullrich <chris(at)chrullrich(dot)net>
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-21 04:03:55
Message-ID: AANLkTinbsMsT1fBvuExTTQOn9rrJdtn2ecmqN_OJ+KvW@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I download postgresql from Enterprise DB

On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich <chris(at)chrullrich(dot)net>wrote:

> * 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 Craig Ringer 2011-01-21 05:04:27 Re: Moving from SQL Anywhere to PostGres - First Time
Previous Message tuanhoanganh 2011-01-21 04:03:21 Re: PostgreSQL 9.0.1 PITR can not copy WAL file