pg_upgrade could not connect to server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

pg_upgrade could not connect to server

Igal @ getRailo.org
hi all,

I'm trying to follow the pg_upgrade docs from
http://www.postgresql.org/docs/9.4/static/pgupgrade.html

I'm on Windows 64bit, and experience a few issues:

1) I do not have a "postgres" user account.  the services are run by the
Network Service account.

2) minor: the service names include "-x64" suffix which is really
unnecessary and makes the docs stray from the implementation.

3) the main problem, possibly related to issue 1 above, is the following
error message:

Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok

*failure*
Consult the last few lines of "pg_upgrade_server_start.log" or "pg_upgrade_server.log" for
the probable cause of the failure.

connection to database failed: could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 50432?
could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 50432?

could not connect to old postmaster started with the command:
"C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start

any help would be appreciated.

thanks!

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



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

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

> hi all,
>
> I'm trying to follow the pg_upgrade docs from
> http://www.postgresql.org/docs/9.4/static/pgupgrade.html
>
> I'm on Windows 64bit, and experience a few issues:
>
> 1) I do not have a "postgres" user account.  the services are run by the
> Network Service account.
>
> 2) minor: the service names include "-x64" suffix which is really
> unnecessary and makes the docs stray from the implementation.
>
> 3) the main problem, possibly related to issue 1 above, is the following
> error message:
>
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions                                   ok
>
> *failure*
> Consult the last few lines of "pg_upgrade_server_start.log" or "pg_upgrade_server.log" for
> the probable cause of the failure.
>
> connection to database failed: could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" (::1) and accepting
> TCP/IP connections on port 50432?
> could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" (127.0.0.1) and accepting
> TCP/IP connections on port 50432?
>
> could not connect to old postmaster started with the command:
> "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start
>
> any help would be appreciated.
>
> thanks!
pg_upgrade_server_start.log contains the following:

command: "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start >> "pg_upgrade_server_start.log" 2>&1
Access is denied.
waiting for server to start........ stopped waiting

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



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Bruce Momjian
In reply to this post by Igal @ getRailo.org
On Thu, Jan 22, 2015 at 10:22:34AM -0800, Igal @ getRailo.org wrote:

> Performing Consistency Checks
> -----------------------------
> Checking cluster versions                                   ok
>
> *failure*
> Consult the last few lines of "pg_upgrade_server_start.log" or "pg_upgrade_server.log" for
> the probable cause of the failure.
>
> connection to database failed: could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" (::1) and accepting
> TCP/IP connections on port 50432?
> could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "localhost" (127.0.0.1) and accepting
> TCP/IP connections on port 50432?
>
> could not connect to old postmaster started with the command:
> "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start

Can you look higher up in the log file?  Does this recent Windows
pg_upgrade failure report match yours at all?

        http://www.postgresql.org/message-id/flat/CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@...#CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@...

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Bruce Momjian
In reply to this post by Igal @ getRailo.org
On Thu, Jan 22, 2015 at 10:30:44AM -0800, Igal @ getRailo.org wrote:

> > could not connect to old postmaster started with the command:
> > "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start
> >
> > any help would be appreciated.
> >
> > thanks!
> pg_upgrade_server_start.log contains the following:
>
> command: "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start >> "pg_upgrade_server_start.log" 2>&1
> Access is denied.
> waiting for server to start........ stopped waiting

Yep, that's the problem all right.  The question is why is it failing?

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
Bruce,

On 1/22/2015 10:38 AM, Bruce Momjian wrote:
> On Thu, Jan 22, 2015 at 10:30:44AM -0800, Igal @ getRailo.org wrote:
>>
>> pg_upgrade_server_start.log contains the following:
>>
>> command: "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start >> "pg_upgrade_server_start.log" 2>&1
>> Access is denied.
>> waiting for server to start........ stopped waiting
> Yep, that's the problem all right.  The question is why is it failing?

Thank you for your prompt reply.

I am running Windows Server 2008 R2 64bit.  The commands are run using
the Administrator account.  There is no Domain Controller there.  This
is pretty much a standalone server in a simple Workgroup network.

Is there any other information I can provide to help figure this out?


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



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Bruce Momjian
On Thu, Jan 22, 2015 at 10:46:50AM -0800, Igal @ getRailo.org wrote:

> Bruce,
>
> On 1/22/2015 10:38 AM, Bruce Momjian wrote:
> > On Thu, Jan 22, 2015 at 10:30:44AM -0800, Igal @ getRailo.org wrote:
> >>
> >> pg_upgrade_server_start.log contains the following:
> >>
> >> command: "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start >> "pg_upgrade_server_start.log" 2>&1
> >> Access is denied.
> >> waiting for server to start........ stopped waiting
> > Yep, that's the problem all right.  The question is why is it failing?
>
> Thank you for your prompt reply.
>
> I am running Windows Server 2008 R2 64bit.  The commands are run using
> the Administrator account.  There is no Domain Controller there.  This
> is pretty much a standalone server in a simple Workgroup network.
>
> Is there any other information I can provide to help figure this out?

I have no ideas.

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Jimmy Jack
In reply to this post by Igal @ getRailo.org
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





On Thu, Jan 22, 2015 at 10:48 AM, Igal @ getRailo.org <[hidden email]> wrote:

Bruce,

On 1/22/2015 10:38 AM, Bruce Momjian wrote:
> On Thu, Jan 22, 2015 at 10:30:44AM -0800, Igal @ getRailo.org wrote:
>>
>> pg_upgrade_server_start.log contains the following:
>>
>> command: "C:\Program Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "E:\PGSQLData" -o "-p 50432 -b " start >> "pg_upgrade_server_start.log" 2>&1
>> Access is denied.
>> waiting for server to start........ stopped waiting
> Yep, that's the problem all right. The question is why is it failing?

Thank you for your prompt reply.

I am running Windows Server 2008 R2 64bit. The commands are run using
the Administrator account. There is no Domain Controller there. This
is pretty much a standalone server in a simple Workgroup network.

Is there any other information I can provide to help figure this out?


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



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
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/



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
In reply to this post by Jimmy Jack
maybe we can isolate the issue by breaking it into steps.  this seems to
cause the problem:

C:\Program Files\PostgreSQL\9.4\bin>"C:\Program
Files\PostgreSQL\9.3\bin/pg_ctl" -w -l "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.

does that get us anywhere?

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
>

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



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Jimmy Jack
In reply to this post by Igal @ getRailo.org
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 <[hidden email]> 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/


Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
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


"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 <[hidden email]> 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/
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
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


"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 <[hidden email]> 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/
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Igal @ getRailo.org
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


"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 <[hidden email]> 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/
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Bruce Momjian
In reply to this post by Igal @ getRailo.org
On Thu, Jan 22, 2015 at 05:46:08PM -0800, 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?

So then it is now this bug report, which I already mentioned:

        http://www.postgresql.org/message-id/flat/CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@...#CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@...

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: pg_upgrade could not connect to server

Bruce Momjian
In reply to this post by Igal @ getRailo.org
On Thu, Jan 22, 2015 at 07:13:40PM -0800, Igal @ getRailo.org wrote:
> 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.

That URL I just emailed you explains the cause.

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general