Re: Redhat 7 and PgSQL - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Redhat 7 and PgSQL
Date
Msg-id Pine.LNX.4.21.0009291859330.363-100000@peter
Whole thread Raw
In response to Re: Redhat 7 and PgSQL  (teg@redhat.com (Trond Eivind Glomsrød))
List pgsql-general
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/


pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: pg_dump's over 2GB
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Redhat 7 and PgSQL