| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Upgrade 9.4 to 12 on windows system |
| Date: | 2020-11-19 15:17:03 |
| Message-ID: | 10fa7293-1194-7227-47a6-bbf08e26c623@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Semanchuk | 2020-11-19 16:43:18 | Re: maintenance_work_mem |
| Previous Message | Andreas Kretschmer | 2020-11-19 15:08:47 | Re: Upgrade 9.4 to 12 on windows system |