Search Postgresql Archives

Re: Upgrading from 7.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux