wrong objects order using pg_dump

Поиск
Список
Период
Сортировка
Искать
От
Oleg
Тема
wrong objects order using pg_dump
Дата
Msg-id
43DDFC6F.5050403@iwk.uka.de
Список
Дерево обсуждения
wrong objects order using pg_dump Oleg <evdakov@iwk.uka.de>
Re: wrong objects order using pg_dump Tom Lane <tgl@sss.pgh.pa.us>
Re: wrong objects order using pg_dump Jaime Casanova <systemguards@gmail.com>
Re: wrong objects order using pg_dump Oleg <evdakov@iwk.uka.de>
Dear All,
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 
then using
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.
For example:
CREATE VIEW myView AS SELECT .... myTable...;
is located before the:
CREATE TABLE myTable ....

while trying to create view the "relation "myTable" does not exist" 
ERROR arised.

What is the right way to copy Database from one computer to another?
Thanks a lot in advance
Oleg

В списке pgsql-novice по дате отправления
От: Sean Davis
Дата:
От: Luzmar Caicedo Useche
Дата:
Сообщение: Re: Problem with pg_dump
FAQ