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