Thread: pg_upgrade on Windows

pg_upgrade on Windows

From
"Marc Daelemans"
Date:
Dear,



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/P

ostgreSQL/9.4/data" --new-datadir "C:/Program Files/PostgreSQL/9.5/data"
--old-b

indir "C:/Program Files/PostgreSQL/9.4/bin" --new-bindir "C:/Program
Files/Postg

reSQL/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?



Best regards,

Marc Daelemans

Re: pg_upgrade on Windows

From
John R Pierce
Date:
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