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.
