| 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: | Whole Thread | Raw Message | 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.
| 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 |