Upgrade 9.4 to 12 on windows system

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Upgrade 9.4 to 12 on windows system

Asya Nevra Buyuksoy
Hello my friends,

I want to upgrade my Postgres DBMS 9.4 to 12 on the Windows system. I follow these steps on this website. (https://qasymphony.zendesk.com/hc/en-us/articles/115002398166-09-Upgrade-PostgreSQL-9-4-to-9-5-on-Windows )
However when everything goes ok, the same error is raising in every cmd running.

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 source postmaster started with the command:
"C:/Program Files/PostgreSQL/9.4/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "C:/Program Files/PostgreSQL/9.4/data" -o "-p 50432 -b " start

I ran this upgrade on Windows Server 12 64 bit.  I researched this error and why it raises but I don't find any proper solution. If anyone relates this problem, I can share my log files. 

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade 9.4 to 12 on windows system

Andreas Kretschmer-3


Am 19.11.20 um 15:05 schrieb Asya Nevra Buyuksoy:

>
>
> 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?
>


have you a firewall installed on the machine? Is port 50432 blocked?
Default port for PostgreSQL is 5432, not 50432.


Andreas


--
2ndQuadrant, an EDB company
www.2ndQuadrant.com / www.enterprisedb.com



Reply | Threaded
Open this post in threaded view
|

Re: Upgrade 9.4 to 12 on windows system

Adrian Klaver-4
On 11/19/20 7:08 AM, Andreas Kretschmer wrote:

>
>
> Am 19.11.20 um 15:05 schrieb Asya Nevra Buyuksoy:
>>
>>
>> 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?
>>
>
>
> have you a firewall installed on the machine? Is port 50432 blocked?
> Default port for PostgreSQL is 5432, not 50432.

Port 50432 is what pg_upgrade uses to stay clear of existing ports:

https://www.postgresql.org/docs/12/pgupgrade.html

"Obviously, no one should be accessing the clusters during the upgrade.
pg_upgrade defaults to running servers on port 50432 to avoid unintended
client connections."



> Andreas
>
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Upgrade 9.4 to 12 on windows system

Asya Nevra Buyuksoy
I set my firewall to off however there is no change. 
I think my problem is windows user name tries to login with the wrong name instead of postgres user name.

2020-11-19 04:06:10 PST FATAL:  role "WIN-EGPKV5AU75R$" does not exist (pg_log file)

my user name seemed like  WIN-EGPKV5AU75R\postgres
How can I fix this issue?


Adrian Klaver <[hidden email]>, 19 Kas 2020 Per, 18:17 tarihinde şunu yazdı:
On 11/19/20 7:08 AM, Andreas Kretschmer wrote:
>
>
> Am 19.11.20 um 15:05 schrieb Asya Nevra Buyuksoy:
>>
>>
>> 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?
>>
>
>
> have you a firewall installed on the machine? Is port 50432 blocked?
> Default port for PostgreSQL is 5432, not 50432.

Port 50432 is what pg_upgrade uses to stay clear of existing ports:

https://www.postgresql.org/docs/12/pgupgrade.html

"Obviously, no one should be accessing the clusters during the upgrade.
pg_upgrade defaults to running servers on port 50432 to avoid unintended
client connections."



> Andreas
>
>


--
Adrian Klaver
[hidden email]