Re: Upgrading 6.5.1 - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Upgrading 6.5.1
Date
Msg-id 200212170337.gBH3bG722728@candle.pha.pa.us
Whole thread Raw
In response to Upgrading 6.5.1  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: Upgrading 6.5.1  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Re: Upgrading 6.5.1  (Lamar Owen <lamar.owen@wgcr.org>)
List pgsql-general
Jean-Christian Imbeault wrote:
> 6.5.1 is *really* old. Are there any docs still left lying around on
> things I should watch out for (data types that are no longer supported
> for example) when moving the data? Or is it as simple as doing a pg_dump
> of the old DB and loading it into the new one; I'm assuming there *is* a
> pg_dump in 6.5.1?
>
> Also, assuming we run the new version on the same hardware what kind of
> a performance increase should I expect to see. Maybe about 20x faster?

Let's see --- how fast does dust move --- that would be your 6.5.1
server.  :-)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Upgrading 6.5.1
Next
From: Tom Lane
Date:
Subject: Re: Upgrading 6.5.1