pg_upgrade could not connect to server

From: "Igal (at) getRailo(dot)org" <igal(at)getrailo(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade could not connect to server
Date: 2015-01-22 18:22:34
Message-ID: 54C13FEA.4090909@getrailo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igal @ getRailo.org 2015-01-22 18:30:44 Re: pg_upgrade could not connect to server
Previous Message Adrian Klaver 2015-01-22 17:21:06 Re: Problem with unixODBC and PostgreSQL