BUG #13859: pg_upgrade permissions on Windows

From: igal(at)lucee(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13859: pg_upgrade permissions on Windows
Date: 2016-01-10 18:23:01
Message-ID: 20160110182301.7615.96066@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13859
Logged by: Igal Sapir
Email address: igal(at)lucee(dot)org
PostgreSQL version: 9.5.0
Operating system: Windows 2008R2
Description:

I'm not sure if this is a known issue or not, but in order to run pg_upgrade
on Windows to upgrade from pgsql-9.4 to pgsql-9.5 I had to:

1) Give Write permissions to Everyone for the working directory, old-data
directory, and new-data directory.

* please note that I was running pg_upgrade as Administrator but still had
to add those permissions

2) Set method to trust in pg_hba.conf for both the old database and the new
database.

If those are the requirements then it should be documented better in my
opinion, though it might be better to make it less restrictive if possible.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-01-10 23:21:23 Re: BUG #13770: Extending recovery_min_apply_delay on Standby causes it to be unavailable for a while
Previous Message Christian Ullrich 2016-01-10 18:08:37 Re: BUG #13854: SSPI authentication failure: wrong realm name used