Re: pg_upgrade could not connect to server

["Igal @ getRailo.org" <igal@xxxxxxxxxxxx>]

ok, I resolved this by giving Full Permissions to the data directory. 

I don't understand why this problem occurred in the first place.  probably something in the process that creates the Data directory.

thank you all for your help.


Igal

On 1/22/2015 5:46 PM, Igal @ getRailo.org wrote:

so when I try to run pg_ctl start I get this now:

c:\Program Files\PostgreSQL\9.3\bin>pg_ctl --pgdata=E:\PGSQLData start
server starting

c:\Program Files\PostgreSQL\9.3\bin>2015-01-22 17:25:22 PST PANIC:  could not open control file "global/pg_control": Permission denied

so looks like that is the source of the problem.

any ideas?

I'm also not sure why this mailing list doesn't use the mailing list's address for Reply-To.  weird...

On 1/22/2015 11:30 AM, Igal @ getRailo.org wrote:

same result :(

C:\Windows\system32>"C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "c:\pg_upgrade_ctl.log" -D "E:\PGSQLData" -o "-p 50432 -b " start
waiting for server to start....Access is denied.
.... stopped waiting
pg_ctl: could not start server
Examine the log output.

can't find any log output either.  I expected it to be at c:\pg_upgrade_ctl.log given the command above.

On 1/22/2015 11:14 AM, Jimmy Jack wrote:

runas administrator

https://msdn.microsoft.com/en-us/library/bb385791.aspx

"The new security model does not grant administrative privileges at all times. Even administrators run under standard privileges when they perform non-administrative tasks that do not require elevated privileges…"

On Thu, Jan 22, 2015 at 10:55 AM, Igal @ getRailo.org <igal@xxxxxxxxxxxx> wrote:

Jimmy,

On 1/22/2015 10:53 AM, Jimmy Jack wrote:
> Did you try to use runas windows command? Should not make any
> difference based on your comment how you run it.
>
> https://technet.microsoft.com/en-us/library/cc771525(WS.10).aspx
>
runas what? there is no "postgres" user on my system. the Windows
service runs as Network Service

thanks,

--
Igal Sapir
Railo Core Developer
http://getRailo.org/

-- 
Igal Sapir
Railo Core Developer
http://getRailo.org/

-- 
Igal Sapir
Railo Core Developer
http://getRailo.org/

-- 
Igal Sapir
Railo Core Developer
http://getRailo.org/