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
>
> 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!
>