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 EDF0611F6AC6 for ; Tue, 18 Apr 2006 10:32:39 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.007 X-Spam-Level: * X-Spam-Status: No, score=1.007 required=5 tests=[AWL=0.080, MSGID_FROM_MTA_ID=0.927] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id N5mPKFFrXLsd for ; Tue, 18 Apr 2006 10:32:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 1587411F6234 for ; Tue, 18 Apr 2006 10:32:35 -0300 (ADT) Received: from [213.146.143.243] (port=4706 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FVqJo-00018l-AG; Tue, 18 Apr 2006 14:32:36 +0100 Reply-To: From: "Andy Shellam" To: "'tony'" Cc: Subject: Re: downward dump compatibility Date: Tue, 18 Apr 2006 14:32:36 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-reply-to: <1145366896.6569.34.camel@hush.localdomain> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZi6/hYN6tpQOC/R1SHq+LKj/K0QQAADUrA Message-Id: <20060418133235.1587411F6234@postgresql.org> X-Archive-Number: 200604/164 X-Sequence-Number: 21333 The source isn't too difficult to build for Redhat - I've done it on = Fedora 3, 4 and 5 - I sometimes prefer to build the source so I can rule out compatibility with my system if I come across any problems in the = future. What app are you using for the dump? The built-in pg_dump? What = version? If you're using the 7.3 pg_dump, try telling the 8.1 to connect to your public server - that way you'll have an 8.1-compatible dump anyway. If you're using your 8.1 already, try the 7.3, to rule out the = possibility of anything in your DB causing a problem to the 8.1 pg_dump. Andy > -----Original Message----- > From: tony [mailto:tony@tgds.net] > Sent: 18 April 2006 2:28 pm > To: andy.shellam@mailnetwork.co.uk > Cc: pgsql-admin@postgresql.org > Subject: RE: [ADMIN] downward dump compatibility >=20 > Le mardi 18 avril 2006 =E0 14:18 +0100, Andy Shellam a =E9crit : > > Nothing to do with file size limitations is there? >=20 > Not to my knowledge >=20 > > What are your system specs? >=20 > The public server has about 20 Gb free. It is a RHEL3 system with 1Gb > RAM. >=20 > 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. >=20 > 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. >=20 > 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 >=20 > Cheers >=20 > Tony >=20 >=20 > !DSPAM:14,4444e97833691830183257! >=20