Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade 9.4 to 12 on windows system - Mailing list pgsql-general

From Asya Nevra Buyuksoy
Subject Re: Upgrade 9.4 to 12 on windows system
Date
Msg-id CADA48rFDfVdN5b0sU3tYOmufdNoOQ4HjMwFHSsSLrPpbGggdwQ@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade 9.4 to 12 on windows system  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 <adrian.klaver@aklaver.com>, 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
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Philip Semanchuk
Date:
Subject: Re: maintenance_work_mem
Next
From: Steve Baldwin
Date:
Subject: Locking and postgres_fdw extension