pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Andy Shellam <andy.shellam@mailnetwork.co.uk>
To: 'tony' <tony@tgds.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: downward dump compatibility
Date: Tue, 18 Apr 2006 14:32:36 +0100
Message-ID: <20060418133235.1587411F6234@postgresql.org> (raw)
In-Reply-To: <1145366896.6569.34.camel@hush.localdomain>
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!
>
view thread (9+ messages) latest in thread
Message-ID: <20060418133235.1587411F6234@postgresql.org> Permalink: ../20060418133235.1587411F6234@postgresql.org/ Also on: postgresql.org/message-id/20060418133235.1587411F6234@postgresql.org ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-admin@postgresql.org Cc: andy.shellam@mailnetwork.co.uk, tony@tgds.net Subject: Re: downward dump compatibility In-Reply-To: <20060418133235.1587411F6234@postgresql.org> References: <1145366896.6569.34.camel@hush.localdomain> <20060418133235.1587411F6234@postgresql.org> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox