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, how am 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])