Thread: Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database
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
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