Thread: pg_upgrade could not connect to server
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/
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/
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@mail.gmail.com#CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@mail.gmail.com -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
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. +
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/
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. +
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:
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
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/
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/
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:
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/
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.
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 <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...
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 <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
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 <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: http://www.postgresql.org/message-id/flat/CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@mail.gmail.com#CAEB4t-OHNE95=n5U4ySsYkWipQsWeQuTBSJkaYJ63_1VzkzkhA@mail.gmail.com -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
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. +