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:[EMAIL PROTECTED] > Sent: 18 April 2006 2:28 pm > To: [EMAIL PROTECTED] > Cc: pgsql-admin@postgresql.org > Subject: RE: [ADMIN] downward dump compatibility > > 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 > > > !DSPAM:14,4444e97833691830183257! > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
