Re: pg_upgrade could not connect to server

From: "Igal (at) getRailo(dot)org" <igal(at)getrailo(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_upgrade could not connect to server
Date: 2015-01-23 01:46:08
Message-ID: 54C1A7E0.8040105@getrailo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igal @ getRailo.org 2015-01-23 03:13:40 Re: pg_upgrade could not connect to server
Previous Message robertlazarski . 2015-01-23 01:40:12 Re: implicit cast works for insert, not for select