Re: Redhat 7 and PgSQL

Trond Eivind Glomsrød writes:

> Incidentally, you can dump data from a database. You can also insert
> data into a database. If you do this before and after upgrading,
> you'll hopefully have the same data in the database.

If there's a problem with pg_dump then pg_dump needs to be fixed, and
incidentally, Philip Warner has been doing just that.

But claiming that you can't upgrade is painting over what might rather be
a deficiency in the RPM mechanism, ISTM.  Why can't you have a spec file
like this:

%preupgrade
pg_dumpall >somewhere

%postupgrade
...
psql -f somewhere


--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/