Thank you very much. It works fine now.
Jaime Casanova schrieb:
>On 1/30/06, Oleg <evdakov(at)iwk(dot)uka(dot)de> wrote:
>>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
>>Under windows I am creating new DB (it is automatically PostGIS db) and
>>psql -f myDBdump.sql -d myWinDB -U postgres
>>After accomplishing this request WinDB missing some Views. The problem
>>is that myDBdump.sql has in some places wrong order of CREATE VIEW and
>>CREATE TABLE statements.
>>CREATE VIEW myView AS SELECT .... myTable...;
>>is located before the:
>>CREATE TABLE myTable ....
>>while trying to create view the "relation "myTable" does not exist"
>>What is the right way to copy Database from one computer to another?
>>Thanks a lot in advance
>use the pg_dump from the the 8.1 to make the backup:
>pg_dump --host <host> --port <port> <your options> base > base.sql
>(DBA: DataBase Aniquilator ;)
In response to
pgsql-novice by date
|Next:||From: Luis Silva||Date: 2006-01-30 15:41:10|
|Subject: quering NULL values|
|Previous:||From: Christian Hofmann||Date: 2006-01-30 15:31:07|
|Subject: Help, 400 million rows, query slow, I stopped after 5 days|