Postgres Pro
Downloads
Home   >   mailing lists

Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database - Mailing list pgsql-general

From angeh
Subject Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database
Date
Msg-id 002901c1085c$f19d0ee0$b901a8c0@mediawebcreation.com
Whole thread Raw
Responses Re: Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database  (GH <grasshacker@over-yonder.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Fabrizio Mazzoni"
Date:
Subject: problems with rules and views
Next
From: "Richard Huxton"
Date:
Subject: Re: error handling. How to?