| 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! Invite them now.
