Re: pg_upgrade could not connect to server - Mailing list pgsql-general

From Igal @ getRailo.org
Subject Re: pg_upgrade could not connect to server
Date
Msg-id 54C141D4.6050909@getrailo.org
Whole thread Raw
In response to pg_upgrade could not connect to server  ("Igal @ getRailo.org" <igal@getrailo.org>)
Responses Re: pg_upgrade could not connect to server  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
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/



pgsql-general by date:

Previous
From: "Igal @ getRailo.org"
Date:
Subject: pg_upgrade could not connect to server
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade could not connect to server