Strange port in pg_upgrade output

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Strange port in pg_upgrade output
Date: 2017-06-12 21:07:36
Message-ID: 0103BA61-66D8-4B72-BA33-B6939B7EE944@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/0 00: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/0 00: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/0 00: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/0 00: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 ?

Thanks
Armand

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-06-12 21:16:56 Re: Strange port in pg_upgrade output
Previous Message Adrian Klaver 2017-06-12 20:53:32 Re: ERROR: type " " does not exist