[GENERAL] 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1
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 postgresql.init Description: application/shellscript ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1
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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Problem with 7.4 RPMS for Fedora Core 1
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 ---(end of broadcast)--- TIP 8: explain analyze is your friend