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.kla...@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.kla...@aklaver.com > > >