RE: Qn on best way to upgrade from 7.0.2 to 7.0.3 on pr oduction database

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: "'angeh'" <enghian(at)mediaweb(dot)com(dot)sg>, pgsql-general(at)postgresql(dot)org
Subject: RE: Qn on best way to upgrade from 7.0.2 to 7.0.3 on pr oduction database
Date: 2001-07-09 11:28:01
Message-ID: 996802F75C3CD411B424001083FA445B059584@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You shouldn't have to dump the DB to upgrade between point releases. The DB
format should not have changed. I've not done it but I assume that you
uninstall 7.0.2 and then install 7.0.3, start the backend and you are off.
And IMHO it may be time to update to 7.1.2 which has a pgdump which can read
7.0.x DBs I'm not sure how this works but it'll be worth the effort ;-).

Regards

Ben

-----Original Message-----
From: angeh [mailto:enghian(at)mediaweb(dot)com(dot)sg]
Sent: 09 July 2001 10:52
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] 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

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Mayo 2001-07-09 11:52:55 Postgresql revisited. Some questions about the product
Previous Message GH 2001-07-09 10:16:24 Re: Qn on best way to upgrade from 7.0.2 to 7.0.3 on production database