Re: Upgrade 9.4 to 12 on windows system

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
>
>