PostgreSQL upgrade from 8.2.3 to 8.3.5 (and also data migration)

Hi Friends,
 This is Leela from India.

I am working on a project that requires upgrade on PostgreSQL version from 8.2.3 to 8.3.5 on Unix platforms. Iam trying to write a shell script to do the same.

I search on the forum and found that I need to use pg_dump and psql utility for data migration from 8.2.3 to 8.3.5.

I am not sure how many databases clusters are running on the machine. I would like know the best to Upgrade postgreSQL so that there is no dataloss.

I see there are default databases like postgres, template0 and template1, I am sure we are not creating those databases. Do we need to take care of migration of postgreSQL and template0 and template1 also while doing backup?

In order to migrate data i saw that there is a utility to backup ALL using pg_dumpall. Can using this utility help me in doing my take easier.

Iam new to PostgreSQL and just getting started, iam pretty much impressed it in a very short time.. kudos to the team who developed it..

To put my problem in simple words:

I want to upgrade PostgreSQL from 8.2.3 to 8.3.5 without any dataloss. There are around 60k rows in a database we have created.

Thanks,
Leela

Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/