Thread: 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