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

pg_dump bug?

From: "Thilo Hille" <thilo(at)resourcery(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: pg_dump bug?
Date: 2003-10-29 12:28:38
Message-ID: 002301c39e18$2e6ffa00$0b00a8c0@resourcery.de (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,
I am using postgresl 7.2.3. Yesterday i have dumped a database using pg_dump
everthing was fine, but the dump was in the wrong order. There were indexes
and views createded before the corresponding table was created.
Its not a big deal but editing 250MB asciifiles isnt actually fun :)

i used "pg_dump dbname > dbname.sql" to dump and "pgsql dbname < dbname.sql"
to restore the database.

Did i missed something?
Are files dumped with pg_dump supposed to be restored with pg_restore or is
it a bug?

Regards
Thilo Hille


In response to

Responses

pgsql-novice by date

Next:From: Jim BeckstromDate: 2003-10-29 13:50:50
Subject: foxpro to postgresql 7.x
Previous:From: Godshall MichaelDate: 2003-10-29 04:29:51
Subject: Re: Postgres and Crystal Reports

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