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 D30B852AA2 for ; Tue, 29 Mar 2005 19:53:50 +0100 (BST) 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 50990-06 for ; Tue, 29 Mar 2005 18:53:42 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id 52B8F538D5 for ; Tue, 29 Mar 2005 19:53:37 +0100 (BST) Received: from yahoo.com.ar (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j2TIpKe29723 for ; Tue, 29 Mar 2005 14:51:21 -0400 Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.8.4]); Tue, 29 Mar 2005 15:53:15 -0300 From: "Dario Pudlo" To: Subject: postgres 7.2.1 pg_restore large objects Date: Tue, 29 Mar 2005 15:53:15 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/40 X-Sequence-Number: 17053 Problem: Not being able to restore a database with lo. I have already read forums and doc. Probably I'm loosing something, but I just can figure. Reading forums I think I finally got the "right" way to do it. I'm running this as OS postgres which is a super user pg_dump -Ft -o -b base > base.tar 2>log_err2 # If I untar the file, i see table data, and blob data, toc and restore.sql. /usr/local/pgsql/bin/pg_restore -Ft -s -v -d base2 base.tar 2>elogerr #creates schema psql -f src/contrib/lo.sql base2 #creates lo type and functions... my base.tar includes lo type definition. O also tried to delete the type previously, and did not make any difference. If I do not do this, pg_restore claims that I lo and oid must be explicity casted. One more thing, I can't make lo_manage to work. I don use it. I delete blobs from app. /usr/local/pgsql/bin/pg_restore -Ft -a -v -d base2 base.tar 2>flogerr the pg_restore fails with the following error. ---------------------------------- pg_restore log (flogerr file) pg_restore: [archiver (db)] error while updating column "tca_texto" of table "tca": server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_restore: *** aborted because of error ---------------------------------- postgres log file DEBUG: server process (pid 25276) was terminated by signal 11 DEBUG: terminating any other active server processes NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. DEBUG: all server processes terminated; reinitializing shared memory and semaphores ---------------------------------- I tried to create a table with oid column instead of lo, restore (worked in this way), I renamed table, I created a table with lo datatype, but when tried to update, same error occurs. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. I have two different versions of postgres, one compiled by someone here, and another version, installed via rpm. unlikely, upgrading to a different version, is not an option, I probably update to 7.2.(last version), but only if this specific problem is solved. I have read the release section of the manual and did not apeared explicity... greetings. TIA to all "Hoy es un buen dia para morir" (today is a good day to die, Klingon en espaņol)!