Re: Upgrading from 7.1

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Upgrading from 7.1
Дата
Msg-id 20050728002716.GU1832@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Upgrading from 7.1  (Chris Travers <chris@travelamericas.com>)
Ответы Re: Upgrading from 7.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, Jul 27, 2005 at 05:13:01PM -0700, Chris Travers wrote:
> Thomas F. O'Connell wrote:
>
> >The implicit indexes are no big deal; they're just a sign of indexes
> >getting created by PRIMARY KEYs on your tables.
> >
> >I'm not sure why you're getting errors. Is there a reason you did the
> >schema dump separately from the data dump rather than a monolithic
> >dump/restore?
> >
> I seem to remember encountering an issue some time ago with pg_dump
> dumping tables in an order that prevented them from being reloaded.

This problem is solved in 8.0's pg_dump.  Not sure if 7.1 has enough
information in catalogs to make the algorithm run correctly -- I wonder
if pg_depend is needed, because AFAIR there was no pg_depend in 7.1.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"The Gord often wonders why people threaten never to come back after they've
been told never to return" (www.actsofgord.com)

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: transaction timeout
Следующее
От: "Jonathan Villa"
Дата:
Сообщение: Re: Upgrading from 7.1