Re: recovering using a continuous archive backup doesn'twork on Windows - Mailing list pgsql-admin

From Sabin Coanda
Subject Re: recovering using a continuous archive backup doesn'twork on Windows
Date
Msg-id ev4nqh$1u89$1@news.hub.org
Whole thread Raw
In response to recovering using a continuous archive backup doesn't work on Windows  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-admin
Hi,

Finally I solved it. It was just a rights access problem. When I
save/copy/move/cleanup the data directory, I used my account, and postgres
user had no rights to write/modify the new data directories. I give it
rights and the recovery works well now.

Regards,
Sabin

BTW: Although the rights access problems are obvious for experimented users,
it would be nice to find a warning/error message in the event logs from the
service that it has no write access in the directory.



pgsql-admin by date:

Previous
From: "Gabriele Bartolini"
Date:
Subject: Advice on migration without down-time
Next
From: "Dominik Żyła"
Date:
Subject: Database replication.