Обсуждение: pg_dump restore error

Hello,

Restoring a backup generated with pg_dump/pg_dumpall in plain text
format and the --clean option will report errors if the backup is loaded
in an other or empty database. I mean that the backup file contains all
SQL order to drop the database's objects before recreating them, so if
you load this backup into a new database it will throw errors on each
DROP call complaining that the objects doesn't exists.

This is not very important because everything goes fine but these error
reports can be easily prevented with the addition of IF EXISTS clauses
and this will probably be less confusing. I've attached a patch adding
those IF EXISTS on each DROP and ALTER statements.

Best regards,

--
Gilles Darold
http://dalibo.com - http://dalibo.org

Gilles Darold <gilles.darold@dalibo.com> writes:
> Restoring a backup generated with pg_dump/pg_dumpall in plain text
> format and the --clean option will report errors if the backup is loaded
> in an other or empty database.

This is intentional.  What you propose amounts to a fundamental change
in the semantics of --clean, and I don't think that it's really much
of an improvement.
        regards, tom lane

Le 14/10/2012 18:50, Tom Lane a écrit :
> Gilles Darold <gilles.darold@dalibo.com> writes:
>> Restoring a backup generated with pg_dump/pg_dumpall in plain text
>> format and the --clean option will report errors if the backup is loaded
>> in an other or empty database.
> This is intentional.  What you propose amounts to a fundamental change
> in the semantics of --clean, and I don't think that it's really much
> of an improvement.

I'm agree that this is not an improvement, I used to work with it
because I know it's harmless error messages. The request comes from a
client that claims that replaying his backup on a new server was always
producing those errors.

I was just thinking that cleaning if exists was also harmless, but it is
probably better to have error reported in most of the cases.

Regards,

--
Gilles Darold
Administrateur de bases de données
http://dalibo.com - http://dalibo.org