pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase upgrade from 8.4.7 to 9.1.4
4+ messages / 3 participants
[nested] [flat]
* Database upgrade from 8.4.7 to 9.1.4
@ 2014-02-25 20:21 Alanoly Andrews <alanolya@invera.com>
0 siblings, 2 replies; 4+ messages in thread
From: Alanoly Andrews @ 2014-02-25 20:21 UTC (permalink / raw)
To: 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 final step 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 where it 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 of ENTER 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 you do not press any key, nothing happens. The load does not proceed, as I confirmed by looking at the growth 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 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. Toute diffusion, 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.
****************************************************
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database upgrade from 8.4.7 to 9.1.4
@ 2014-02-25 21:20 desmodemone <desmodemone@gmail.com>
parent: Alanoly Andrews <alanolya@invera.com>
1 sibling, 1 reply; 4+ messages in thread
From: desmodemone @ 2014-02-25 21:20 UTC (permalink / raw)
To: Alanoly Andrews <alanolya@invera.com>; +Cc: pgsql-admin
2014-02-25 21:21 GMT+01:00 Alanoly Andrews <alanolya@invera.com>:
> 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 final step 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 where it 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 of ENTER 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 you do not press any key,
> nothing happens. The load does not proceed, as I confirmed by looking at
> the growth 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
> 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. Toute diffusion, 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.
> ****************************************************
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Hello Alanoly ,
which option you use to do the pg_dumpall ? did
you use insert mode or copy mode?
Have a nice day
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database upgrade from 8.4.7 to 9.1.4
@ 2014-02-25 22:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Alanoly Andrews <alanolya@invera.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2014-02-25 22:02 UTC (permalink / raw)
To: Alanoly Andrews <alanolya@invera.com>; +Cc: pgsql-admin
Alanoly Andrews <alanolya@invera.com> writes:
> 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 final step 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 where it seems to be
> waiting for user input.
That's very bizarre. I don't know what it's doing, but there are
certainly no "waits for user input" in a pg_dump-created SQL script.
I suspect you are seeing some sort of platform-specific misbehavior.
You might wish to join in this ongoing discussion about the state of
our AIX support (tl;dr: it's bad):
http://www.postgresql.org/message-id/flat/530B1EEC.1080402@spg.schulergroup.com#530B1EEC.1080402@spg...
Did you try the regression tests ("make check") on your 9.1.2 build?
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database upgrade from 8.4.7 to 9.1.4
@ 2014-02-26 13:53 Alanoly Andrews <alanolya@invera.com>
parent: desmodemone <desmodemone@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Alanoly Andrews @ 2014-02-26 13:53 UTC (permalink / raw)
To: desmodemone <desmodemone@gmail.com>; +Cc: pgsql-admin
Hi Des,
I did not use any options with the "pg_dumpall" command. Just "pg_dumpall > outputfile", as given in the Postgres Manual on upgrades. I guess the default option is the "copy" mode, not "inserts".
Alanoly.
From: desmodemone [mailto:desmodemone@gmail.com]
Sent: Tuesday, February 25, 2014 4:21 PM
To: Alanoly Andrews
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Database upgrade from 8.4.7 to 9.1.4
Hello Alanoly ,
which option you use to do the pg_dumpall ? did you use insert mode or copy mode?
Have a nice day
****************************************************
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 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. Toute diffusion, 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.
****************************************************
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2014-02-26 13:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-02-25 20:21 Database upgrade from 8.4.7 to 9.1.4 Alanoly Andrews <alanolya@invera.com>
2014-02-25 21:20 ` desmodemone <desmodemone@gmail.com>
2014-02-26 13:53 ` Alanoly Andrews <alanolya@invera.com>
2014-02-25 22:02 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox