Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable
От
Scott Mead
Тема
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable
Дата
Msg-id
d3ab2ec80906152224h59f0ebcbk17046f6c891a715d@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable Konstantin Gredeskoul <kig@dropinmedia.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Jakov Sosic <jakov.sosic@srce.hr>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Jakov Sosic <jakov.sosic@srce.hr>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
dataunusable "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
dataunusable Iñigo Martinez Lasala <imartinez@vectorsf.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Scott Marlowe <scott.marlowe@gmail.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
data unusable Devrim GÜNDÜZ <devrim@gunduz.org>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable Konstantin Gredeskoul <kig@dropinmedia.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
data unusable Devrim GÜNDÜZ <devrim@gunduz.org>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
data unusable Devrim GÜNDÜZ <devrim@gunduz.org>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Andy Shellam <andy-lists@networkmail.eu>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1
rendered data unusable Devrim GÜNDÜZ <devrim@gunduz.org>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable Tom Lane <tgl@sss.pgh.pa.us>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable Konstantin Gredeskoul <kig@dropinmedia.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Scott Marlowe <scott.marlowe@gmail.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered
data unusable Alvaro Herrera <alvherre@commandprompt.com>
Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data
unusable Scott Mead <scott.lists@enterprisedb.com>
OP: Downgrade to your original version, then do a pg_dump.
I'm not sure the yum command to do this, but there must be some. To be version specific you can look at the PG_VERSION file in your data directory.
On Tue, Jun 16, 2009 at 12:10 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
This is NOT yum's fault. PostgreSQL does not guarantee data directory
consistency from one rc to another, through beta, etc. Until 8.4.0
comes out, it could change each and every time.
I agree it's not YUM's fault... however, I think it may make sense for those of us in the community to work with packagers on this issue. I realize that RPM's are supposed to keep all files everywhere up to date, and it's nice to have them all in /usr/bin, but this can cause big problems in this case. Would it not make more sense to simply install in /usr/pgsql/<version> ?? And have /var/lib/pgsql/<version>/pgdata? I guess this has just never been a thought in packager's minds, but is a serious problem once you use a database for more than your personal CD collection :-).
Of course, in-place upgrade *may* resolve some of these types of queries, but personally, I would rather have each version of the database binaries around in case all goes very, very wonky.
--Scott
В списке pgsql-admin по дате отправления
От: Devrim GÜNDÜZ
Дата:
От: Konstantin Gredeskoul
Дата:
