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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Minor problems reloading dump in 7.0beta1
Дата
Msg-id 200002241518.KAA17550@candle.pha.pa.us
обсуждение исходный текст
Ответ на Minor problems reloading dump in 7.0beta1  (Magnus Hagander <mha@sollentuna.net>)
Список pgsql-hackers
[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
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Karl DeBisschop
Дата:
Сообщение: Re: AW: [GENERAL] Re: [HACKERS] TRANSACTIONS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [BUGS] First experiences with Postgresql 7.0