Re: 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/