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/
