Campbell, Lance wrote:
I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do
the following command in order to load the new database after install?
pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ /dbname///
Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is
PostgreSQL 8.2.4.
Should be fine, as long as you ensure that the pg_dump you use, is the
one from your 8.2.4 installation, and not the 8.1.4 version.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
