Re: Cannot read back pg_dump from 7.2 into 7.4

From: "Gerwin Philippo" <gerwin(at)vernet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Cannot read back pg_dump from 7.2 into 7.4
Date: 2003-11-25 10:41:21
Message-ID: 3fc331d2$0$1489$e4fe514c@news.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks for the help, I found the problem(s).
1. There was always a problem with reading back dumps into an empty database
in 7.2, and the views had to be done separately. The former admin had a file
for that. When I ran that on a 7.2 database, things were fine.
2. When I tried this on the 7.4 database, it didn't work, because this
database is more strict about typecasting. Wether this is the version or the
config on the new server I don't know. Anyway, I had to rewrite the file
with the view-definitions with some explicit type-casts, and then it worked.
It was the combinations of these two things that tricked me.

Gerwin
"Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> schreef in bericht
news:200311241722(dot)15996(dot)xzilla(at)users(dot)sourceforge(dot)net(dot)(dot)(dot)
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Fielding 2003-11-25 11:43:13 ERROR: pltcl: Cache lookup for attribute
Previous Message Shravan 2003-11-25 07:18:42 How to interact with the db using java