pg_upgrade could not connect to server

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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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?

/messages/by-id/CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@mail.gmail.com

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

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

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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

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

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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

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

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 <igal@getrailo.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/

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

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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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@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@getrailo.org <mailto:igal@getrailo.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/

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@getrailo.org <mailto:igal@getrailo.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/

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@getrailo.org <mailto:igal@getrailo.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/

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:

/messages/by-id/CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@mail.gmail.com

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

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

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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

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