Database upgrade from 8.4.7 to 9.1.4

Поиск
Список
Период
Сортировка
От Alanoly Andrews
Тема Database upgrade from 8.4.7 to 9.1.4
Дата
Msg-id c12856200b6c4ab8a3ed423e1e3a8c4c@exch1.invera.com
обсуждение исходный текст
Ответы Re: Database upgrade from 8.4.7 to 9.1.4  (desmodemone <desmodemone@gmail.com>)
Re: Database upgrade from 8.4.7 to 9.1.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello,

OS level= 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
finalstep in which the data is 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 suddenly comes to a halt on a "lo_create" line
whereit seems to be waiting for 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)

Standard input: END


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

    114811
(1 row)

 lo_create
-----------
    114812
(1 row)

 lo_create
-----------
    114813
(1 row)

 lo_create
-----------
    114814
(1 row)

 lo_create
-----------
    114815
(1 row)


So it appears that the program needs the user to press the ENTER key (or the space key) to move on to the next row. If
youdo not press any key, nothing happens. The load does not proceed, as I confirmed by looking at the growth of files
inthe 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.
Anydistribution, use or copying of this e-mail or the information it contains by other than an intended recipient is
unauthorized.If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. 

Ce courriel est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent.
Toutediffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le
(les)destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser
imm�diatement,par retour de courriel ou par un autre moyen. 
****************************************************



В списке pgsql-admin по дате отправления:

Предыдущее
От: Murthy Nunna
Дата:
Сообщение: Re: PITR
Следующее
От: desmodemone
Дата:
Сообщение: Re: Database upgrade from 8.4.7 to 9.1.4