Thread: pg_upgrade on Windows
I am having issues with pg_upgrade on Windows. I have posted a question on StackOverflow -- at http://stackoverflow.com/questions/34664236/pg-upgrade-on-windows-cannot-write-to-log-file-pg-upgrade-internal-log -- copied below for convenience:
I'm trying to run pg_upgrade on Windows, but I'm getting the error:
cannot write to log file pg_upgrade_internal.log Failure, exiting
I saw a similar question for Linux at 23216734 which explains that the issue is with permissions, but it doesn't help with Windows as I do not have a user named postgres
Same goes for the pg_upgrade docs, which mention a postgres
user:
RUNAS /USER:postgres "CMD.EXE"
But again, I do not have such a user, and am trying to run this command as Administrator so I don't understand why I would have no permission. I even tried to do
RUNAS /USER:Administrator "CMD.EXE"
And run pg_upgrade in the new command prompt, but am getting the same error.
Also, I am not sure which directory needs permissions? Where is the process trying to write pg_upgrade_internal.log
to? any ideas? TIA!
Igal Sapir
Lucee Core Developer
Lucee.org
I'm trying to run pg_upgrade on Windows, but I'm getting the error:
cannot write to log file pg_upgrade_internal.log Failure, exiting
I saw a similar question for Linux at 23216734 which explains that the issue is with permissions, but it doesn't help with Windows as I do not have a user named
postgres
Same goes for the pg_upgrade docs, which mention a
postgres
user:RUNAS /USER:postgres "CMD.EXE"
But again, I do not have such a user, and am trying to run this command as Administrator so I don't understand why I would have no permission. I even tried to do
RUNAS /USER:Administrator "CMD.EXE"
And run pg_upgrade in the new command prompt, but am getting the same error.
Also, I am not sure which directory needs permissions? Where is the process trying to write
pg_upgrade_internal.log
to? any ideas? TIA!
how was your postgresql installed ? is the existing version of postgres running as a system service or what? what versions are you upgrading from and to ?
note, btw, just being Administrator does NOT automatically override file permissions... an administrator is allowed to change file ownership.
-- john r pierce, recycling bits in santa cruz