[CentOS-devel] Upgrading postgresql (Re: CentOS/RHEL 5.3)
Les Mikesell
lesmikesell at gmail.com
Thu Jan 22 17:25:30 UTC 2009
Joshua Kramer wrote:
> Any major database version upgrade requires the attention of a qualified
> DBA who knows how to test data and applications against the new DB
> version, and then dump/upgrade/restore.
>
> For example, PostgreSQL introduced some minor syntactical differences with
> 8.3. If your application uses the features affected by these changes, it
> would be impossible to simply 'dump/restore' without some massaging of the
> data and the application.
>
> PostgreSQL does ship with a dumper, pg_dump. If you have the current
> version of postmaster, then you use pg_dump to connect to that and dump
> your data in a version-agnostic format. IMHO, the effort of writing a
> standalone dumper that can recognize all the old file formats is not worth
> it, because it is a mistake to delete the old version of postmaster off
> your system before you've done a dump of the database.
So how do you package such a thing in RPM so it can permit both new and
old instances to run simultaneously while you do all of this required
testing? I suppose these days virtualbox is an almost-reasonable answer
but it just seems wrong to have a system that by design doesn't let you
test a new instance before replacing the old one.
--
Les Mikesell
lesmikesell at gmail.com
More information about the CentOS-devel
mailing list