Upgrade Information

Поиск
Список
Период
Сортировка
Искать
От
Naomi Walker
Тема
Upgrade Information
Дата
Msg-id
4.2.2.20020208105518.00abce30@ecint.ecinet.com
Ответ на
Список
Дерево обсуждения
Two tables with same name in different user not allowed ? "Kumar, Lakshmi (Cognizant)" <NLakshmi@chn.cognizant.com>
Re: Two tables with same name in different user not allowed Bruce Momjian <pgman@candle.pha.pa.us>
Upgrade Information Naomi Walker <nwalker@eldocomp.com>
Re: Upgrade Information Bruce Momjian <pgman@candle.pha.pa.us>
Re: Upgrade Information Naomi Walker <nwalker@eldocomp.com>
We are currently using Postgresql 7.1.2, running on a E3500 server, OS 
Solaris 2.6. We would like to upgrade to postgresql 7.2.

1) Do you all consider it stable enough now to upgrade?

2) If I understand correctly, to upgrade, step would be:

           a) pg_dumpall
           b) reset PGHOME to new version of postgresql
           c) pg_restore

Is this correct?

If so, that seems pretty drastic.  I cannot imagine that once our databases 
start getting really huge that this will last as an upgrade method.  I 
thought we would be using pg_upgrade, but I see a note that it will not 
work with versions of postgres 7.1 and higher.

Why did pg_upgrade go away, and can we look forward to one in the future?

Thanks,
Naomi

--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242 

В списке pgsql-admin по дате отправления
От: Simone Tellini
Дата:
Сообщение: Re: PG 7.2 tarball
От: Bruce Momjian
Дата:
Сообщение: Re: Upgrade Information
FAQ