From: Alanoly Andrews <alanolya@invera.com>
To: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Database upgrade from 8.4.7 to 9.1.4
Thread-Topic: Database upgrade from 8.4.7 to 9.1.4
Thread-Index: AQHPMmVlEwLutVDKYEmOd3MV3EY5SQ==
Date: Tue, 25 Feb 2014 20:21:15 +0000
Message-ID: <c12856200b6c4ab8a3ed423e1e3a8c4c@exch1.invera.com>
Accept-Language: en-GB, en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hello,

OS level=3D AIX 6.1.9

I'm testing out an upgrade of an existing postgres 8.4.7 instance to 9.1.2,=
 using "pg_dumpall". All went well until the final step in which the data i=
s to be restored. I gave the following command:

psql -d database -f outputfile

This command creates all the tables, starts loading some tables and then su=
ddenly comes to a halt on a "lo_create" line where it seems to be waiting f=
or user input. See below the last screen output of the psql command:

ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
 lo_create
-----------
    102660
(1 row)
=20
Standard input: END


At this stage, if I press ENTER, the lo_create moves on to the next row, an=
d so on. See below the result of a sequence of ENTER hits:

    114811
(1 row)
=20
 lo_create
-----------
    114812
(1 row)
=20
 lo_create
-----------
    114813
(1 row)
=20
 lo_create
-----------
    114814
(1 row)
=20
 lo_create
-----------
    114815
(1 row)


So it appears that the program needs the user to press the ENTER key (or th=
e space key) to move on to the next row. If you do not press any key, nothi=
ng happens. The load does not proceed, as I confirmed by looking at the gro=
wth of files in the PGDATA area. I exited by killing the psql session.

Is there a way to force the load of all rows without user input?

Thanks.

Alanoly Andrews.
alanolya@invera.com
****************************************************
This e-mail may be privileged and/or confidential, and the sender does not =
waive any related rights and obligations. Any distribution, use or copying =
of this e-mail or the information it contains by other than an intended rec=
ipient is unauthorized. If you received this e-mail in error, please advise=
 me (by return e-mail or otherwise) immediately.
=20
Ce courriel est confidentiel et prot=E9g=E9. L'exp=E9diteur ne renonce pas =
aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation =
ou copie de ce message ou des renseignements qu'il contient par une personn=
e autre que le (les) destinataire(s) d=E9sign=E9(s) est interdite. Si vous =
recevez ce courriel par erreur, veuillez m'en aviser imm=E9diatement, par r=
etour de courriel ou par un autre moyen.
****************************************************


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