Re: [HACKERS] Minor problems reloading dump in 7.0beta1

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi!
> 
> When upgrading a server from version 6.5.2 to 7.0beta1, we hit the following
> problems when reloading the data from pg_dumpall:
> 
> - Is it a "known feature" that when using "psql -f pgfull.dump" it aborts on
> the "\connect" lines from pg_dumpall? The dump works fine if I start psql
> and use \i to load it. (I reliase the documentation says use "psql <
> filename", but I didn't read that far :-)

This is a new psql feature that scripts exit on first failure, I think.

> - It fails to reload datetime indexes, because of "DefineIndex: datetime_ops
> class not found". I take it this is because of the new datetime stuff, but
> it should at least be put into some notes somewhere that you have to tweak
> the pg_dump output for these.

We need to fix that somehow.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026