Re: Upgrade 9.4 to 12 on windows system

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Upgrade 9.4 to 12 on windows system
Дата
Msg-id 10fa7293-1194-7227-47a6-bbf08e26c623@aklaver.com
обсуждение исходный текст
Ответ на Re: Upgrade 9.4 to 12 on windows system  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Upgrade 9.4 to 12 on windows system  (Asya Nevra Buyuksoy <ayisan1096@gmail.com>)
Список 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.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Upgrade 9.4 to 12 on windows system
Следующее
От: Philip Semanchuk
Дата:
Сообщение: Re: maintenance_work_mem