Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong objects order using pg_dump - Mailing list pgsql-novice

From Tom Lane
Subject Re: wrong objects order using pg_dump
Date
Msg-id 5288.1138634210@sss.pgh.pa.us
Whole thread Raw
In response to wrong objects order using pg_dump  (Oleg <evdakov@iwk.uka.de>)
List pgsql-novice
Tree view 
Oleg <evdakov@iwk.uka.de> writes:
> I am trying to copy the PostGIS Database from Linux computer to Windows.
> Under Linux Debian we have PostgreSQL 7.4.6, under Windows XP we have
> PostgreSQL 8.1.0-2 .
> I am creating dump under Linux with pg_dump myDB > myDBdump.sql

Try using the 8.1 pg_dump to suck data from the 7.4 database.  7.4's
pg_dump is not very smart about inter-object dependencies, especially
not if you ALTERed any objects after initially creating them.  8.0 or
8.1 pg_dump should get this right though.

            regards, tom lane

pgsql-novice by date:

Previous
From: "chris preston"
Date:
Subject: Schema with Postgress 8.1
Next
From: "Christian Hofmann"
Date:
Subject: Help, 400 million rows, query slow, I stopped after 5 days