Re: downward dump compatibility

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxx]
> Sent: 18 April 2006 2:28 pm
> To: andy.shellam@xxxxxxxxxxxxxxxxx
> Cc: pgsql-admin@xxxxxxxxxxxxxx
> 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!
> 




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux