pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddownward dump compatibility
9+ messages / 4 participants
[nested] [flat]
* downward dump compatibility
@ 2006-04-17 12:38 tony <tony@tgds.net>
0 siblings, 2 replies; 9+ messages in thread
From: tony @ 2006-04-17 12:38 UTC (permalink / raw)
To: pgsql-admin
Hello,
Is it possible to import a 8.1.1 dump file (standard format) into a
7.3.9 database?
I have an intranet with the most recent version and a public serveur
with selected data which is still running 7.3.
I am seeing an error with "\N"
Cheers
Tony
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-17 18:23 Guido Barosio <gbarosio@gmail.com>
parent: tony <tony@tgds.net>
1 sibling, 2 replies; 9+ messages in thread
From: Guido Barosio @ 2006-04-17 18:23 UTC (permalink / raw)
To: tony <tony@tgds.net>; +Cc: pgsql-admin
Dunno, but it sounds like a "no" at a first sight.
What about dumping with INSERTS instead of COPY ?
That should work tho.
g.-
On 4/17/06, tony <tony@tgds.net> wrote:
> Hello,
>
> Is it possible to import a 8.1.1 dump file (standard format) into a
> 7.3.9 database?
>
> I have an intranet with the most recent version and a public serveur
> with selected data which is still running 7.3.
>
> I am seeing an error with "\N"
>
> Cheers
>
> Tony
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
Guido Barosio
-----------------------
http://www.globant.com
guido.barosio@globant.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-17 20:47 Bruno Wolff III <bruno@wolff.to>
parent: tony <tony@tgds.net>
1 sibling, 0 replies; 9+ messages in thread
From: Bruno Wolff III @ 2006-04-17 20:47 UTC (permalink / raw)
To: tony <tony@tgds.net>; +Cc: pgsql-admin
On Mon, Apr 17, 2006 at 14:38:24 +0200,
tony <tony@tgds.net> wrote:
> Hello,
>
> Is it possible to import a 8.1.1 dump file (standard format) into a
> 7.3.9 database?
>
> I have an intranet with the most recent version and a public serveur
> with selected data which is still running 7.3.
>
> I am seeing an error with "\N"
It isn't likely to work without manual intervention. However, you probably
get it to work by editing the dump file without doing a lot of work.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 12:48 tony <tony@tgds.net>
parent: Guido Barosio <gbarosio@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: tony @ 2006-04-18 12:48 UTC (permalink / raw)
To: Guido Barosio <gbarosio@gmail.com>; +Cc: pgsql-admin
Le lundi 17 avril 2006 à 19:23 +0100, Guido Barosio a écrit :
> Dunno, but it sounds like a "no" at a first sight.
>
> What about dumping with INSERTS instead of COPY ?
> That should work tho.
INSERTS in a heap of data then blocks the CPU at 90% abd just sits
there...
I'm thinking up a better plan.
Cheers
Tony
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 13:15 tony <tony@tgds.net>
parent: Guido Barosio <gbarosio@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: tony @ 2006-04-18 13:15 UTC (permalink / raw)
To: pgsql-admin
Le lundi 17 avril 2006 à 19:23 +0100, Guido Barosio a écrit :
> Dunno, but it sounds like a "no" at a first sight.
>
> What about dumping with INSERTS instead of COPY ?
> That should work tho.
Something is preventing the creation of all the tables, about three key
tables are missing...
Back to the drawing board
Tony
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 13:18 Andy Shellam <andy.shellam@mailnetwork.co.uk>
parent: tony <tony@tgds.net>
0 siblings, 0 replies; 9+ messages in thread
From: Andy Shellam @ 2006-04-18 13:18 UTC (permalink / raw)
To: 'tony' <tony@tgds.net>; +Cc: pgsql-admin
Nothing to do with file size limitations is there?
What are your system specs?
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of tony
> Sent: 18 April 2006 2:16 pm
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] downward dump compatibility
>
> Le lundi 17 avril 2006 à 19:23 +0100, Guido Barosio a écrit :
> > Dunno, but it sounds like a "no" at a first sight.
> >
> > What about dumping with INSERTS instead of COPY ?
> > That should work tho.
>
> Something is preventing the creation of all the tables, about three key
> tables are missing...
>
> Back to the drawing board
>
> Tony
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,4444e6ee33693675863041!
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 13:28 tony <tony@tgds.net>
0 siblings, 1 reply; 9+ messages in thread
From: tony @ 2006-04-18 13:28 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 13:32 Andy Shellam <andy.shellam@mailnetwork.co.uk>
parent: tony <tony@tgds.net>
0 siblings, 0 replies; 9+ messages in thread
From: Andy Shellam @ 2006-04-18 13:32 UTC (permalink / raw)
To: 'tony' <tony@tgds.net>; +Cc: pgsql-admin
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!
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: downward dump compatibility
@ 2006-04-18 13:42 tony <tony@tgds.net>
0 siblings, 0 replies; 9+ messages in thread
From: tony @ 2006-04-18 13:42 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: pgsql-admin
Le mardi 18 avril 2006 à 14:32 +0100, Andy Shellam a écrit :
> 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.
Something along the line of creating a ssh tunnel to the intranet server
from the public server.
ssh -v -L 5433:localhost:5432 my.intranet.url
Then pg_dump --port=5433 dbname > /var/lib/pgsql/data/db.out
I'll wait until they've finished work...
Tony
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-04-18 13:42 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-17 12:38 downward dump compatibility tony <tony@tgds.net>
2006-04-17 18:23 ` Guido Barosio <gbarosio@gmail.com>
2006-04-18 12:48 ` tony <tony@tgds.net>
2006-04-18 13:15 ` tony <tony@tgds.net>
2006-04-18 13:18 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-04-17 20:47 ` Bruno Wolff III <bruno@wolff.to>
2006-04-18 13:28 Re: downward dump compatibility tony <tony@tgds.net>
2006-04-18 13:32 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-04-18 13:42 Re: downward dump compatibility tony <tony@tgds.net>
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