Re: pg_upgrade could not connect to server

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(at)getrailo(dot)org <mailto:igal(at)getrailo(dot)org>> 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/