Error: "When checking a pre-PG 9.1 live old server, you must specify the old server's port number."

On 07/28/2015 06:12 AM, Furlong, Shane wrote:

I am trying to upgrade my PostgreSQL instance from 9.0.22 to 9.4.4.

However, I am getting the following error when executing pg_upgrade.

�When checking a pre-PG 9.1 live old server, you must specify the old
server's port number.

Failure, exiting�

I am executing the following command. I have tried substituting -o '�p
50432' instead of -o '�p 5438'

I get the same result.

It appears as though I am not successfully passing the old instance port
assignment into the pg_upgrade script.

Anyone seen this one before?

/app/PostgreSQL/9.4/bin/pg_upgrade -b /app/PostgreSQL/9.0/bin -B
/app/PostgreSQL/9.4/bin -d /pgsql/stip/data9 -D /pgsql/stip/data94 -o
'�p 5438' �U furlongs_a -c -v

Try:

/app/PostgreSQL/9.4/bin/pg_upgrade -b /app/PostgreSQL/9.0/bin -B
/app/PostgreSQL/9.4/bin -d /pgsql/stip/data9 -D /pgsql/stip/data94 -p
5438 �U furlongs_a -c -v

Thank you,

*Shane Furlong*

U.S. Department of Energy

Office of Scientific and Technical Information (OSTI)

(865) 574-9316, Rm 206-1, office

(865) 973-3276 mobile

furlongs@osti.gov <mailto:furlongs@osti.gov>

--
Adrian Klaver
adrian.klaver@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