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

Re: Errors with pg_dump

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Errors with pg_dump
Date: 2002-08-29 14:06:40
Message-ID: akl9p9$1d9t$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
"Andre Schubert" <andre(dot)schubert(at)km3(dot)de> wrote in message
news:20020828103531(dot)0abf145b(dot)andre(dot)schubert(at)km3(dot)de(dot)(dot)(dot)
> Hi all,
>
> i have a little problem with dumping and restoring my databases.
> It seems that if i dump a schema from a database then that data
> were dumped in wrong order.
> For example, i have plpgsql-functions used for check-constraints
> in some tables.
> The create function statements come after the create table statement
> of the table using this function as check-constraint.
> The same behavior with views.
> I have some views were the create view statement comes before the
> create table statement in the dumped file.
>
> Are these errors known or do i have misconfigured pg_dump?

From the documentation:

[SNIP]
9.1.4. Caveats
pg_dump (and by implication pg_dumpall) has a few limitations which stem
from the difficulty to reconstruct certain information from the system
catalogs.
Specifically, the order in which pg_dump writes the objects is not very
sophisticated. This can lead to problems for example when functions are used
as column default values. The only answer is to manually reorder the dump.
If you created circular dependencies in your schema then you will have more
work to do.
For reasons of backward compatibility, pg_dump does not dump large objects
by default. To dump large objects you must use either the custom or the TAR
output format, and use the -b option in pg_dump. See the reference pages for
details. The directory contrib/pg_dumplo of the PostgreSQL source tree also
contains a program that can dump large objects.

[SNIP]


Ciao
Gaetano



In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2002-08-29 14:14:34
Subject: Re: Time slowly goes out of sync Cygwin+windows+psotgres
Previous:From: Mark McEahernDate: 2002-08-29 12:50:41
Subject: Re: programatically obtaining table layout

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