Postgres Pro
Downloads
Home   >   mailing lists

Permissions denied for the database file system on Windows during restore - Mailing list pgsql-hackers

From Joel Mariadasan (jomariad)
Subject Permissions denied for the database file system on Windows during restore
Date
Msg-id DM6PR11MB3452ED921542223DC51FAD7FD7449@DM6PR11MB3452.namprd11.prod.outlook.com
Whole thread Raw
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Splitting up guc.c
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: PostgreSQL 15 release announcement draft