pg_upgrade on Windows

On 4/5/2016 3:05 PM, Marc Daelemans wrote:

When one attempts to run pg_upgrade on Windows (7 SP 1 x64) the
command produces a failure notice, probably because writing to (log)
files in C:\Program Files and its subdirectories is not allowed.

C:\Program Files\PostgreSQL\9.5>pg_upgrade.exe --old-datadir
"C:/Program Files/PostgreSQL/9.4/data" --new-datadir "C:/Program
Files/PostgreSQL/9.5/data" --old-bindir "C:/Program
Files/PostgreSQL/9.4/bin" --new-bindir "C:/Program
Files/PostgreSQL/9.5/bin"

cannot write to log file pg_upgrade_internal.log

Failure, exiting

Is there a way to redirect the log file to another file location?

wild guess says its writing that to the current default directory.

try running it from a directory you have write access to, such as
c:\Users\MyUsername and specify the path for pg_upgrade, like...

C:\Users\MyUsername> C:\Program Files\PostgreSQL\9.5\bin\pg_upgrade
--old-datadir "C:/Program Files/PostgreSQL/9.4/data" --new-datadir
"C:/Program Files/PostgreSQL/9.5/data" --old-bindir "C:/Program
Files/PostgreSQL/9.4/bin" --new-bindir "C:/Program
Files/PostgreSQL/9.5/bin"

--
john r pierce, recycling bits in santa cruz