PostgreSQL upgrade from 8.2.3 to 8.3.5 (and also data migration)
| От | leela |
|---|---|
| Тема | PostgreSQL upgrade from 8.2.3 to 8.3.5 (and also data migration) |
| Дата | |
| Msg-id | 485296.69868.qm@web56704.mail.re3.yahoo.com обсуждение исходный текст |
| Ответы |
Re: PostgreSQL upgrade from 8.2.3 to 8.3.5 (and also data
migration)
|
| Список | pgsql-general |
| 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.
В списке pgsql-general по дате отправления: