Re: Problem with 7.4 RPMS for Fedora Core 1

Hello, everybody

Thanks to Lamar Owen that I downloaded the rpms for Fedora Core 1 which
I expected all the time after 7.4 was released.

But I found a somewhat weird problem with it. My fedora installation has
no postgresql at all, then I installed all rpms of 7.4, and then run
"service postgresql start" with root, I noticed that the initdb is
executed correctly, and I can access it with psql successfully, all seem
good. But, when I run "service postgresql stop" and then run "service
postgresql start" again, it failed to startup and give the following errors:
----->
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee
/usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
<------

But I can run "postmaster -i" successfully with postgres user. So,
what's the problem?

Thanks you very much.
yours,
mili

On Friday 21 November 2003 09:15 pm, milimeter wrote:
> errors: ----->
> An old version of the database format was found.\nYou need to upgrade
> the data format before using PostgreSQL.\nSee
> /usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
> <------

Argh. Typo. Replace /etc/rc.d/init.d/postgresql with the attached script.
Rename it from postgresql.init to postgresql and put in /etc/rc.d/init.d

My apologies. I'll rebuild shortly.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu

On Friday 21 November 2003 09:33 pm, Lamar Owen wrote:
> On Friday 21 November 2003 09:15 pm, milimeter wrote:
> > errors: ----->
> > An old version of the database format was found.\nYou need to upgrade
> > the data format before using PostgreSQL.\nSee
> > /usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
> > <------
>
> Argh. Typo. Replace /etc/rc.d/init.d/postgresql with the attached script.
> Rename it from postgresql.init to postgresql and put in /etc/rc.d/init.d
>
> My apologies. I'll rebuild shortly.

Rebuilding now. While I was at it, I put in conditionals for the 7x and 89
builds. I'll rebuild my 8.0 and Aurora 1.0 builds shortly too; for now I'm
blowing them away on the server. Give me a little bit; rebuilding the rh8
one will take 30 minutes or more, and that's after the fedora one has built.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu

On Friday 21 November 2003 09:33 pm, Lamar Owen wrote:
> On Friday 21 November 2003 09:15 pm, milimeter wrote:
> > errors: ----->
> > An old version of the database format was found.\nYou need to upgrade
> > the data format before using PostgreSQL.\nSee
> > /usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
> > <------
>
> Argh. Typo. Replace /etc/rc.d/init.d/postgresql with the attached script.
> Rename it from postgresql.init to postgresql and put in /etc/rc.d/init.d
>
> My apologies. I'll rebuild shortly.

Rebuilding, and have uploaded Aurora 1.0 and Fedora Core 1 RPMS for PostgreSQL
7.4-0.2PGDG. The same source RPM works for both, and works for Red Hat 8.0
(I'm building that one now; my RH8 machine is a creaky old Pentium 150).

To rebuild on Red Hat 6.2, executing this should work (but I don't have a 6.2
machine on which to try it....)
rpm --define 'build6x 1' --define 'plperl 0' --rebuild
postgresql-7.4-0.2PGDG.src.rpm

To rebuild on Red Hat 7.3:
rpmbuild --define 'build7x' --define 'plperl 0' --rebuild ....

To rebuild on Red Hat 8.0 and 9:
rpmbuild --define 'build89' --rebuild ....

To rebuild on Fedora Core
rpmbuild --rebuild ...

I fixed the initscript this time, I think, and made it more portable on the
build.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu