Skip site navigation (1) Skip section navigation (2)

Re: wrong objects order using pg_dump

From: Oleg <evdakov(at)iwk(dot)uka(dot)de>
To: Jaime Casanova <systemguards(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: wrong objects order using pg_dump
Date: 2006-01-30 15:32:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi Jaime
Thank you very much. It works fine now.
Best regards

Jaime Casanova schrieb:

>On 1/30/06, Oleg <evdakov(at)iwk(dot)uka(dot)de> wrote:
>>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
>use the pg_dump from the the 8.1 to make the backup:
>pg_dump --host <host> --port <port> <your options> base > base.sql
>Jaime Casanova
>(DBA: DataBase Aniquilator ;)

In response to

pgsql-novice by date

Next:From: Luis SilvaDate: 2006-01-30 15:41:10
Subject: quering NULL values
Previous:From: Christian HofmannDate: 2006-01-30 15:31:07
Subject: Help, 400 million rows, query slow, I stopped after 5 days

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group