Re: [GENERAL] Strange port in pg_upgrade output

[armand pirvu]

Got it



Thank you

> On Jun 12, 2017, at 4:16 PM, Adrian Klaver  wrote:
> 
> On 06/12/2017 02:07 PM, armand pirvu wrote:
>> Hi
>> I was doing a test upgrade from 9.5 to 9.6 and the following lines caught my 
>> eye
>> postgres 10967 10911  0 15:59 pts/000:00:00 
>> /usr/pgsql-9.6/bin/pg_upgrade -d /var/lib/pgsql/9.5/data -D 
>> /var/lib/pgsql/9.6/data -b /usr/pgsql-9.5/bin -B /usr/pgsql-9.6/bin -k -v
>> postgres 11141 1  0 16:00 pts/000:00:00 /usr/pgsql-9.6/bin/postgres 
>> -D /var/lib/pgsql/9.6/data -p 50432 -b -c synchronous_commit=off -c 
>> fsync=off -c full_page_writes=off -c listen_addresses= -c 
>> unix_socket_permissions=0700 -c unix_so
>> postgres 11160 10967  0 16:00 pts/000:00:00 sh -c 
>> "/usr/pgsql-9.6/bin/pg_restore" --host '/var/lib/pgsql' --port 50432 
>> --username 'postgres' --exit-on-error --verbose --dbname 'dbname=birstdb' 
>> "pg_upgrade_dump_25288.custom" >> "pg_upgrad
>> postgres 11161 11160  6 16:00 pts/000:00:00 
>> /usr/pgsql-9.6/bin/pg_restore --host /var/lib/pgsql --port 50432 --username 
>> postgres --exit-on-error --verbose --dbname dbname=birstdb 
>> pg_upgrade_dump_25288.custom
>> sudo grep -i port /var/lib/pgsql/9.6/data/postgresql.conf
>> [sudo] password for armandp:
>> port = 5432  # (change requires restart)
>>  # supported by the operating system:
>> Is it something that I missed or is it intentionally using a non default 
>> port to avoid unintended client connections ?
> 
> https://www.postgresql.org/docs/9.6/static/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. You can use the same port number for both clusters when 
> doing an upgrade because the old and new clusters will not be running at the 
> same time. However, when checking an old running server, the old and new port 
> numbers must be different."
> 
>> Thanks
>> Armand
> 
> 
> -- 
> Adrian Klaver
> adrian.kla...@aklaver.com 

Re: [GENERAL] Strange port in pg_upgrade output

[Adrian Klaver]

On 06/12/2017 02:07 PM, armand pirvu wrote:

Hi

I was doing a test upgrade from 9.5 to 9.6 and the following lines caught my eye

postgres 10967 10911  0 15:59 pts/000:00:00 /usr/pgsql-9.6/bin/pg_upgrade 
-d /var/lib/pgsql/9.5/data -D /var/lib/pgsql/9.6/data -b /usr/pgsql-9.5/bin -B 
/usr/pgsql-9.6/bin -k -v
postgres 11141 1  0 16:00 pts/000:00:00 /usr/pgsql-9.6/bin/postgres -D 
/var/lib/pgsql/9.6/data -p 50432 -b -c synchronous_commit=off -c fsync=off -c 
full_page_writes=off -c listen_addresses= -c unix_socket_permissions=0700 -c 
unix_so
postgres 11160 10967  0 16:00 pts/000:00:00 sh -c "/usr/pgsql-9.6/bin/pg_restore" --host 
'/var/lib/pgsql' --port 50432 --username 'postgres' --exit-on-error --verbose --dbname 'dbname=birstdb' 
"pg_upgrade_dump_25288.custom" >> "pg_upgrad
postgres 11161 11160  6 16:00 pts/000:00:00 /usr/pgsql-9.6/bin/pg_restore 
--host /var/lib/pgsql --port 50432 --username postgres --exit-on-error 
--verbose --dbname dbname=birstdb pg_upgrade_dump_25288.custom

sudo grep -i port /var/lib/pgsql/9.6/data/postgresql.conf
[sudo] password for armandp:
port = 5432 # (change requires restart)
# supported by the operating system:


Is it something that I missed or is it intentionally using a non default port 
to avoid unintended client connections ?


https://www.postgresql.org/docs/9.6/static/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. You can use the same port number for both clusters 
when doing an upgrade because the old and new clusters will not be 
running at the same time. However, when checking an old running server, 
the old and new port numbers must be different."





Thanks
Armand






--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general