| From: | Mladen Gogala <mgogala(at)vmsinfo(dot)com> |
|---|---|
| To: | Kasia Tuszynska <ktuszynska(at)esri(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Excellent job! |
| Date: | 2010-10-04 22:43:04 |
| Message-ID: | 4CAA5878.70307@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Barnes | 2010-10-04 22:49:21 | Re: Incremental Backup |
| Previous Message | Mladen Gogala | 2010-10-04 22:40:38 | Re: Excellent job! |