Re: Cannot read back pg_dump from 7.2 into 7.4 - Mailing list 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@users.sourceforge.net> schreef in bericht
news:200311241722.15996.xzilla@users.sourceforge.net...
> 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@vernet.nl> schreef in bericht
> > news:3fc1eecd$0$1508$e4fe514c@news.xs4all.nl...
> >
> > > 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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>