Mladen Gogala wrote:
> Kasia Tuszynska wrote:
>
>> Mladen,
>> You used pg_upgrade to migrate to 9.0?
>> I ,perhaps mistakenly, assumed that it is for use once the db is at 9.0 to migrate in the future.
>> Kasia
>>
>>
> Yes, I did use pg_uprade. The purpose of pg_upgrade is to migrate from
> the earlier releases to PgSQL 9.0. It works flawlessly with 8.4.4.
> having in mind the size of the database, I used pg_upgrade --link, which
> makes it impossible to re-open the database with the version 8.4.4.
> Basically, you define (and export, of course) the following environment
> variables:
>
Before you do all that, you have to initialize the new 9.0 cluster with
initdb.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions