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.
