Permissions denied for the database file system on Windows during restore

From: "Joel Mariadasan (jomariad)" <jomariad(at)cisco(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Permissions denied for the database file system on Windows during restore
Date: 2022-09-12 20:52:46
Message-ID: DM6PR11MB3452ED921542223DC51FAD7FD7449@DM6PR11MB3452.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

When I try to restore an old backup on Windows, the restore always fails with a message that permission denied for "base/19513/21359".

Note this file name provided by postgres is random. When I check the properties of this file, this file doesn't have any owner at all. Windows says that no one is owning this file.
This is only happening to certain files in the base directory.

Due to these reasons, the restore operation always fails.

Queries:

1. How does postgres assign in conjunction with Windows assign ownership of the database files post a restore operation?
2. Are there any guesses on why the issue might have occured?

Regards,
Joel

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2022-09-12 20:56:28 Re: PostgreSQL 15 release announcement draft
Previous Message Andres Freund 2022-09-12 20:50:24 Re: Splitting up guc.c