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@xxxxxxxx <mailto:furlongs@xxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
