X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B0D8352AA1 for ; Thu, 14 Jul 2005 13:35:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34507-05 for ; Thu, 14 Jul 2005 16:35:38 +0000 (GMT) Received: from palrel13.hp.com (palrel13.hp.com [156.153.255.238]) by svr1.postgresql.org (Postfix) with ESMTP id A223D52A22 for ; Thu, 14 Jul 2005 13:35:35 -0300 (ADT) Received: from redsea.india.hp.com (redsea.india.hp.com [15.76.97.3]) by palrel13.hp.com (Postfix) with ESMTP id 62CCC1C00545 for ; Sat, 16 Jul 2005 12:21:11 -0700 (PDT) Received: from eb98130 (eb98130.india.hp.com [15.76.98.130]) by redsea.india.hp.com (8.9.3 (PHNE_29774)/8.9.3 SMKit7.02) with ESMTP id WAA06096 for ; Thu, 14 Jul 2005 22:03:13 +0530 (IST) Message-Id: <200507141633.WAA06096@redsea.india.hp.com> From: "Gopal Srinivasa" To: Subject: pg_restore hangs on 'some' HP-UX machines Date: Thu, 14 Jul 2005 22:05:24 +0530 Organization: HP MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcWIkgiGLPkNXroNTuGOzf9wnGbBuA== X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/107 X-Sequence-Number: 18163 Hi, I am using PostgreSQL 7.4.2 on HP-UX systems. I am trying to pg_restore a dump created using pg_dump with the following command-line: pg_dump -Fc -fcerdump -Uemt -p10864 cer The dump only has one table "emt_str", with integers and strings as its attributes. Essentially, the table stores some strings used by our application. It has around 250+ records. When I run pg_restore (this is on a different machine), pg_restore creates the schema, but hangs while inserting data. The command-line I am using is: pg_restore -d cer -Uemt -p10864 cerdump The 'funny' thing is that it works perfectly on some HP-UX systems and hangs on some others. I've seen it happen on both IA and PA architectures. Also, sometimes deleting some strings and restoring works, but the process is not repeatable. I attached gdb to the pg_restore process and here is the output of "bt": (gdb) attach 9249 Attaching to program: /opt/iexpress/postgresql/bin/pg_restore, process 9249 0x60000000c058d890:0 in _poll_sys+0x30 () from /usr/lib/hpux32/libc.so.1 (gdb) bt #0 0x60000000c058d890:0 in _poll_sys+0x30 () from /usr/lib/hpux32/libc.so.1 #1 0x60000000c05a2860:0 in poll+0x120 () from /usr/lib/hpux32/libc.so.1 #2 0x60000000c189ee90:0 in pqSocketPoll+0x120 () from /usr/lib/hpux32/libpq.so.3 #3 0x60000000c189ec10:0 in pqSocketCheck+0xb0 () from /usr/lib/hpux32/libpq.so.3 #4 0x60000000c189ea60:0 in pqWaitTimed+0x40 () from /usr/lib/hpux32/libpq.so.3 #5 0x60000000c189ea00:0 in pqWait+0x40 () from /usr/lib/hpux32/libpq.so.3 #6 0x60000000c189e6f0:0 in pqSendSome+0x150 () from /usr/lib/hpux32/libpq.so.3 #7 0x60000000c18ab5a0:0 in pqEndcopy3+0x60 () from /usr/lib/hpux32/libpq.so.3 #8 0x60000000c189a620:0 in PQendcopy+0x70 () from /usr/lib/hpux32/libpq.so.3 #9 0x4019ef0:0 in _sendCopyLine+0x230 () #10 0x401a620:0 in ExecuteSqlCommandBuf+0x80 () #11 0x4013740:0 in ahwrite+0x2f0 () #12 0x401cdf0:0 in _PrintData+0x260 () #13 0x401c940:0 in _PrintTocData+0x2a0 () #14 0x4010540:0 in RestoreArchive+0xb30 () #15 0x400e960:0 in main+0xa80 () Another thing that happens is that postmaster always (well, almost always) starts up saying FATAL: the database system is starting up I looked in the source code and saw that the canAcceptConnections function in postmaster.c is returning CAC_STARTUP. Now, I don't have any applications trying to connect when postmaster starts, so I am lost trying to figure out why this is happening. We are using PostgreSQL 7.4.2 throughout. Any help will be greatly appreciated! Thanks! Gopal.