Thread: 7.3.4 -> 7.3.8 - a little stuck

7.3.4 -> 7.3.8 - a little stuck

From
Date:
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


Re: 7.3.4 -> 7.3.8 - a little stuck

From
Tom Lane
Date:
<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

Re: 7.3.4 -> 7.3.8 - a little stuck

From
Devrim GUNDUZ
Date:
-----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-----

Re: 7.3.4 -> 7.3.8 - a little stuck

From
Date:
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

Re: 7.3.4 -> 7.3.8 - a little stuck

From
Date:
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
>


Re: 7.3.4 -> 7.3.8 - a little stuck

From
Devrim GUNDUZ
Date:
-----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-----