Re: pg_dump index/constraint creation order - Mailing list pgsql-general

From Vivek Khera
Subject Re: pg_dump index/constraint creation order
Date
Msg-id 7FD6A354-16AF-4CDD-AC4B-0FED9741FF40@khera.org
Whole thread Raw
In response to pg_dump index/constraint creation order  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: pg_dump index/constraint creation order
List pgsql-general
On May 14, 2006, at 12:27 AM, Ed L. wrote:

> While watching a 9-hour 60GB network load from 7.4.6 pg_dump into
> 8.1.2, I noticed the order in which indices and constraints are
> created appears to be their creation order.

If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 DB,
what is the order like?
I suspect it would be more to what you're expecting.  In general, you
should use the pg_dump  corresponding to the version into which you
are loading for best results.


Attachment

pgsql-general by date:

Previous
From: "Rafael Alves"
Date:
Subject: Erro ao tentar inserir um array de bytes
Next
From: "Florian G. Pflug"
Date:
Subject: Re: GUI Interface