Problem with 7.4 RPMS for Fedora Core 1

[milimeter]

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.\nSe e
/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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Lamar Owen]

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.\nSe e
/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
[phone]
www.pari.edu
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Lamar Owen]

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.\nSe e
/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
[phone]
www.pari.edu
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Lamar Owen]

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.\nSe e
/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
[phone]
www.pari.edu
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend