Alanoly Andrews <alanolya@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxx#530B1EEC.1080402@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
