X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4FFD811F6ACC for ; Tue, 18 Apr 2006 10:28:19 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.12 X-Spam-Level: X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 1Akca+qdOS1X for ; Tue, 18 Apr 2006 10:28:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.tgds.net (tgds.net [212.100.249.157]) by postgresql.org (Postfix) with ESMTP id C8F0F11F670B for ; Tue, 18 Apr 2006 10:28:16 -0300 (ADT) Received: from hush.localdomain (localhost [127.0.0.1]) by mail.tgds.net (Postfix) with ESMTP id CFDFC1435E5; Tue, 18 Apr 2006 14:26:59 +0100 (BST) Subject: Re: downward dump compatibility From: tony To: andy.shellam@mailnetwork.co.uk Cc: pgsql-admin@postgresql.org In-Reply-To: <20060418131710.36C691435E5@mail.tgds.net> References: <20060418131710.36C691435E5@mail.tgds.net> Content-Type: text/plain; charset=ISO-8859-15 Date: Tue, 18 Apr 2006 15:28:15 +0200 Message-Id: <1145366896.6569.34.camel@hush.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Archive-Number: 200604/163 X-Sequence-Number: 21332 Le mardi 18 avril 2006 à 14:18 +0100, Andy Shellam a écrit : > Nothing to do with file size limitations is there? Not to my knowledge > What are your system specs? The public server has about 20 Gb free. It is a RHEL3 system with 1Gb RAM. I think that I am running up against the impossibility to load a 8.1.x dump into a 7.3.x database because of something in my dump that isn't compatible. This 8.1 database was converted from 7.1 a while back and it was not an easy task. I still have to convert it to UTF-8 and sanitise a few things. I think I shall sit down and write a dump script that only dumps out the tables required by the public web app. And I think that I will migrate the public server to 8.1.x if I find the RPMs for RHEL3 Cheers Tony