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 BDA13D1B18F for ; Tue, 6 Jul 2004 06:08:02 -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 90963-05 for ; Tue, 6 Jul 2004 09:07:59 +0000 (GMT) Received: from tinet.org (mail.tinet.org [195.77.216.130]) by svr1.postgresql.org (Postfix) with ESMTP id F17CED1B19F for ; Tue, 6 Jul 2004 06:07:53 -0300 (ADT) Received: (qmail 29352 invoked from network); 6 Jul 2004 09:07:52 -0000 Received: from aitana.altanet.org (HELO tinet.org) ([195.76.233.3]) (envelope-sender ) by mail.tinet.org (SMTP OASI) with SMTP for ; 6 Jul 2004 09:07:52 -0000 Message-ID: <40EA6B91.50504@tinet.org> Date: Tue, 06 Jul 2004 11:06:25 +0200 From: Daniel Rubio User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Upgrade problems with OID type ... Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/67 X-Sequence-Number: 14135 Hi all! I'm trying to upgrade from 7.3.2 to 7.4.3 but I've a problem with a database (1 I know, there could be more) containing a table with an oid type field. I run the migration doing: ../bin/pg_dumpall -o -p 5432 | /apps/pgs-7.4.3/bin/psql -d template1 -p 5433 1>/tmp/out 2>/tmp/err The command runs fine, with no ERRORS on the output files, but when the user accesses their application (web) the images he was storing does'nt appear, and I can see errors like this on the logfile: 2004-07-06 09:54:52 ERROR: large object 417988 does not exist First I was doing the dump without the -o, but now I use it and the problem persists ... Ideas? Thanks in advance ... -- ******************************************************** Daniel Rubio Rodríguez OASI (Organisme Autňnom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: drubio a oasi.org ********************************************************