Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIQ4s-0001uI-Jp for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2014 22:02:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WIQ4s-0003W7-3c for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2014 22:02:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIQ4r-0003W0-23 for pgsql-admin@postgresql.org; Tue, 25 Feb 2014 22:02:13 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIQ4k-0002X0-06 for pgsql-admin@postgresql.org; Tue, 25 Feb 2014 22:02:12 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s1PM24wP000441; Tue, 25 Feb 2014 17:02:04 -0500 From: Tom Lane To: Alanoly Andrews cc: "'pgsql-admin@postgresql.org'" Subject: Re: Database upgrade from 8.4.7 to 9.1.4 In-reply-to: References: Comments: In-reply-to Alanoly Andrews message dated "Tue, 25 Feb 2014 20:21:15 +0000" Date: Tue, 25 Feb 2014 17:02:04 -0500 Message-ID: <440.1393365724@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Alanoly Andrews 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.schulergroup.com 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