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