question for upgrade pg 8.2.5 to pg 8.3.3

From: ProAce <proace(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: question for upgrade pg 8.2.5 to pg 8.3.3
Date: 2008-09-02 12:07:13
Message-ID: 737a6d270809020507xed51a60t42654eb6f8ed4a74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just want to transfer only one db in pg 8.2.5 to pg 8.3.3, others
are still remained on pg 8.2.5.

I call the only one db as "db-foo", and the db owner as "user-foo" following.
The IP for pg 8.2.5 is 10.10.10.1 , IP for pg 8.3.3 is 10.10.10.2.

My operations are listed below:
1. install a new pg 8.3.3 on new machine.
2. create the "user-foo" on pg 8.3.3
3. create the "db-foo" and assign the "user-foo" to owner on pg 8.3.3
4. pg_dump -f db-foo.dump -U pgsql -E UTF-8 -h 10.10.10.1 db-foo
5. psql -f db-foo.dump -U pgsql -h 10.10.10.2 db-foo

Are there any problems about the procedure?

It seems ok and run successfully on my test environment, but still
worried that some problems on the new pg 8.3.3.

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-09-02 12:11:09 Re: MERGE: performance advices
Previous Message Raymond O'Donnell 2008-09-02 11:21:09 Re: plpgsql returning resultset