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.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu