Обсуждение: 7.3.4 -> 7.3.8 - a little stuck
Hello, I was using 7.3.4 and decided to upgrade to 7.3.8. I did this via RPMs for RH9. RPM installed OK, and the migration of data looks like it worked. I have one remaining problem: I can start the DB with `pg_ctl -D /var/lib/pgsql/data start', but I cannot start it with `/etc/rc.d/init.d/postgresql start'. The error I get is the same one that I was getting before I 'upgraded' the data: "An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgresql-7.4/README.rpm-dist for more information." Does anyone know what I could do to get this to work? Also: Although I upgraded to 7.3.8, I saw several incorrect(?) references to 7.4 (e.g. PGVERSION=7.4 in that init script). Mistakes? Should I just be upgrading to the latest 7.4.* version instead? To migrate/upgrade the data after the DB install, I followed these directions: http://developer.postgresql.org/docs/postgres/migration.html However, I also had to recreate the user (createuser) and the DB itself (createdb). Is this normal, or did I do something wrong? Thank you, Otis
<ogjunk-pgjedan@yahoo.com> writes:
> Although I upgraded to 7.3.8, I saw several incorrect(?) references to
> 7.4 (e.g. PGVERSION=7.4 in that init script). Mistakes?
Yes ... yours. You may have thought you updated to 7.3.8, but you
evidently installed 7.4.something.
regards, tom lane
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 17 Nov 2004, Tom Lane wrote:
>> Although I upgraded to 7.3.8, I saw several incorrect(?) references to
>> 7.4 (e.g. PGVERSION=7.4 in that init script). Mistakes?
>
> Yes ... yours. You may have thought you updated to 7.3.8, but you
> evidently installed 7.4.something.
Umm, I think it's completely my fault :-( I did the same mistake in
pgadmin3 package! PGVERSION is really 7.4, in init script :( Maybe this is
the same problem as Simon is also experiencing :( The problem occurs in
all 7.3.8 RPMS and possibly in all 7.2.6 RPMs! 7.4.6 seems correct. A
fresh install seems to create no problem but an upgrade will fail.
Otis... I'll be rebuilding the RPMS ASAP. Until then, could you please
change PGVERSION value to 7.3 in init script and give it a try?
Thanks,
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBmw3jtl86P3SPfQ4RAgZYAJ9ODJwpCJj2mnONb9wqx+fbGA9RKQCfSJ5P
oGiOWEhHqiWsq1iFPgdpTTw=
=mhC5
-----END PGP SIGNATURE-----
Hello, --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > <ogjunk-pgjedan@yahoo.com> writes: > > Although I upgraded to 7.3.8, I saw several incorrect(?) references > to > > 7.4 (e.g. PGVERSION=7.4 in that init script). Mistakes? > > Yes ... yours. You may have thought you updated to 7.3.8, but you > evidently installed 7.4.something. I double-checked and it looks like I installed 7.3.8, just like I intended: $ rpm -qa | grep postg postgresql-tcl-7.3.8-2PGDG postgresql-libs-7.3.8-2PGDG postgresql-7.3.8-2PGDG postgresql-jdbc-7.3.8-2PGDG postgresql-server-7.3.8-2PGDG postgresql-pl-7.3.8-2PGDG postgresql-python-7.3.8-2PGDG postgresql-contrib-7.3.8-2PGDG Could be a mistake in the RPM, no? Otis
Aha! :) No problem Devrim - I did this last night and everything worked. The init script must be from the 7.4.* versions, because there are also changelog-type messages mentioning 7.4.* in there. Otis --- Devrim GUNDUZ <devrim@gunduz.org> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Hi, > > On Wed, 17 Nov 2004, Tom Lane wrote: > > >> Although I upgraded to 7.3.8, I saw several incorrect(?) > references to > >> 7.4 (e.g. PGVERSION=7.4 in that init script). Mistakes? > > > > Yes ... yours. You may have thought you updated to 7.3.8, but you > > evidently installed 7.4.something. > > Umm, I think it's completely my fault :-( I did the same mistake in > pgadmin3 package! PGVERSION is really 7.4, in init script :( Maybe > this is > the same problem as Simon is also experiencing :( The problem occurs > in > all 7.3.8 RPMS and possibly in all 7.2.6 RPMs! 7.4.6 seems correct. A > > fresh install seems to create no problem but an upgrade will fail. > > Otis... I'll be rebuilding the RPMS ASAP. Until then, could you > please > change PGVERSION value to 7.3 in init script and give it a try? > > Thanks, > > Regards, > - -- > Devrim GUNDUZ > devrim~gunduz.org devrim.gunduz~linux.org.tr > http://www.tdmsoft.com > http://www.gunduz.org > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQFBmw3jtl86P3SPfQ4RAgZYAJ9ODJwpCJj2mnONb9wqx+fbGA9RKQCfSJ5P > oGiOWEhHqiWsq1iFPgdpTTw= > =mhC5 > -----END PGP SIGNATURE----- > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 17 Nov 2004 ogjunk-pgjedan@yahoo.com wrote:
> No problem Devrim - I did this last night and everything worked. The
> init script must be from the 7.4.* versions, because there are also
> changelog-type messages mentioning 7.4.* in there.
Ok, thanks for the report.
I've rebuilt RPMS and SRPMS for
* Red Hat Linux 9
* Red Hat Enterprise Linux 3
* Fedora Core 3
They are on the main FTP server now, tagged as 7.3.8-3PGDG. RPMs for FC1
and FC2 can be easily rebuilt using the SRPMs.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBm86Ttl86P3SPfQ4RAs0yAKC2a7ucyubtB2osQCWkWwgB4yj94gCg1nAm
3DLjS+1OjmzhuvMjjBQI0sc=
=dSuL
-----END PGP SIGNATURE-----