Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Jakov Sosic
On Tue, 16 Jun 2009 23:10:40 +0200 Jakov Sosic wrote: > This is not a rpm/yum/etc's fault. It's your fault... > > Also, "yum update" *quietly upgraded* is nonsense. Either you run yum > update -y, or you choose yes after yum offered packages. > > So it's your and your fault only... Please don't

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Jakov Sosic
On Mon, 15 Jun 2009 15:42:38 -0700 Konstantin Gredeskoul wrote: > Dear PostgreSQL admins and gurus, > > I always knew that installing Postgres using Yum/RPM/etc is a very > bad idea, but decided to try it on one my boxes that runs local > wiki/Trac. > > I added /etc/yum.repos.d/pgdg-84-centos.r

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Konstantin Gredeskoul
I agree, I did not realize that the yum repository I setup was still the development version, and that minor upgrades would render data directory incompatible. My bad. All in all, I want to thank you all for quick responses, and for keeping PG software moving along. I've been using PG for

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Scott Marlowe
2009/6/16 Tom Lane : > Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: >> Anyway, we are talking about an issue which should never ever happen, if >> docs were read. I announced -devel RPMs lots of times, and each one >> included a notice for dump/reload action. > > I think the real issue here is that

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: > Anyway, we are talking about an issue which should never ever happen, if > docs were read. I announced -devel RPMs lots of times, and each one > included a notice for dump/reload action. I think the real issue here is that the OP was confused about whe

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Devrim GÜNDÜZ
On Tue, 2009-06-16 at 17:46 +0100, Andy Shellam wrote: > > As Konstantin mentioned in another e-mail, PostgreSQL is normally > compiled from source and installed > into /usr/local/postgres-. Actually the "default" is /usr/local/pgsql , which means it still could be overwritten ;) Anyway, we ar

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Andy Shellam
Hi, As Scott wrote: This is **not** yum's fault. It is your fault actually. Even if you did this upgrade from sources, it would still be broken. PostgreSQL does not guarantee not to change on-disk data structure between development snapshots. I sort of agree with both sides of the issue - i

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Alvaro Herrera
Konstantin Gredeskoul escribió: > Still, I consider automatic yum updates for Postgres fundamentally > broken, if they invalidate your database directory. A 2 minute update > may cost an hour of downtime for someone who is not expecting this, like > I wasn't. You shouldn't have been using u

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Devrim GÜNDÜZ
On Tue, 2009-06-16 at 10:10 +0300, Devrim GÜNDÜZ wrote: > As Scoot wrote Scott, sorry for the typo. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc D

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-16 Thread Devrim GÜNDÜZ
On Mon, 2009-06-15 at 23:09 -0700, Konstantin Gredeskoul wrote: > > Still, I consider automatic yum updates for Postgres fundamentally > broken, if they invalidate your database directory. A 2 minute > update may cost an hour of downtime for someone who is not expecting > this, like I wasn

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-15 Thread Konstantin Gredeskoul
Thanks all for your help. I installed from the RPM, found the sources (although it wasn't obvious), rebuilt the identical version that i had before and I am up and running. Still, I consider automatic yum updates for Postgres fundamentally broken, if they invalidate your database directory

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-15 Thread Scott Mead
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 wrote: > > > This is NOT yum's fault. P

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-15 Thread Devrim GÜNDÜZ
On Mon, 2009-06-15 at 22:10 -0600, Scott Marlowe wrote: > > Got a backup of the original 8.4devel_20090310-1PGDG.rhel5.i386 > package? I'd think reinstalling that would fix your problen. Unfortunately I removed binary -devel packages from the repository. However, SRPM do exist: http://yum.pgsql

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-15 Thread Scott Marlowe
On Mon, Jun 15, 2009 at 4:42 PM, Konstantin Gredeskoul wrote: > Dear PostgreSQL admins and gurus, > > I always knew that installing Postgres using Yum/RPM/etc is a very bad idea, > but decided to try it on one my boxes that runs local wiki/Trac. > > I added /etc/yum.repos.d/pgdg-84-centos.repo to m

[ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

2009-06-15 Thread Konstantin Gredeskoul
Dear PostgreSQL admins and gurus, I always knew that installing Postgres using Yum/RPM/etc is a very bad idea, but decided to try it on one my boxes that runs local wiki/Trac. I added /etc/yum.repos.d/pgdg-84-centos.repo to my yum configuration and installed PostgreSQL version 8.4devel_2009