Re: Cannot read back pg_dump from 7.2 into 7.4

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "Gerwin Philippo" <gerwin(at)vernet(dot)nl>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Cannot read back pg_dump from 7.2 into 7.4
Date: 2003-11-24 22:22:15
Message-ID: 200311241722.15996.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

A few thoughts: what command are you using to produce the 7.2 dump? what is
the exact version of the 7.2 server?

Try and see if you can get a good dump using the 7.4 pg_dump against the 7.2
database.

Robert Treat

On Monday 24 November 2003 08:43, Gerwin Philippo wrote:
> Oops, last message was not entirely correct: Unfortunately the 7.2 version
> is also unable to read back the dumps it made. The dumps created look
> completely impossible to run to me:
>
> line100: create view "vw1" as select field1 from table1;
>
> line200: create table1 (field1 integer);
>
> If the server went down today, I'd be in big trouble! Please help!
>
> Gerwin
>
> "Gerwin Philippo" <gerwin(at)vernet(dot)nl> schreef in bericht
> news:3fc1eecd$0$1508$e4fe514c(at)news(dot)xs4all(dot)nl(dot)(dot)(dot)
>
> > I'm testing 7.4, and tried to read a pg_dump file created in 7.2 into a
>
> 7.4
>
> > database.
> > I get a lot of error messages when creating views from tables because the
> > tables are not created yet.
> > Looking into the dump file, the order in which objects are created looks
> > funny: first some views, then the tables on which these views are based.
> > This seems impossible to me, but the odd thing is that with the 7.2
> > server
>
> I
>
> > can read this dump into a new database without any problems.
> > Any ideas?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nathan 2003-11-24 23:14:40 Re: WHAT IS THE ADVANTAGE
Previous Message Björn Lundin 2003-11-24 20:34:36 Re: Associating client PIDs with backend PIDs