Обсуждение: Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database

Поиск
Список
Период
Сортировка

Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database

От
"angeh"
Дата:
I hv a production postgres 7.0.2 on Mandrake 7.2.
 
there is a bug on timestamp, where I cannot restore back the data created by pg_dump.
 
therefore I need to upgrade to 7.0.3.
 
the doc says to do dump/restore when upgrading the database. however, since pg_dump has problem with timestamp data, how am I going to restore back the data after upgrade?!!!
 
pls help. Thanks

Re: Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database

От
GH
Дата:
On Mon, Jul 09, 2001 at 05:52:21PM +0800, some SMTP stream spewed forth:
[...]
> therefore I need to upgrade to 7.0.3.
>
> the doc says to do dump/restore when upgrading the database. however, since pg_dump has problem with timestamp data,
howam I going to restore back the data after upgrade?!!! 
>
> pls help. Thanks

It is my understanding that no dump/restore is necessary for minor
version upgrades (e.g. .2 to .3). You should be fine, but don't take my
word for it.

gh
--
> What, no one sings along with Ricky Martin anymore?
My kid sister does (but then, she prefers pico to vi ...)
    -- Suresh Ramasubramanian, alt.sysadmin.recovery