pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed7.3.4 -> 7.3.8 - a little stuck
6+ messages / 3 participants
[nested] [flat]
* 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 04:58 ogjunk-pgjedan@yahoo.com
0 siblings, 1 reply; 6+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2004-11-17 04:58 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 06:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: ogjunk-pgjedan@yahoo.com
0 siblings, 2 replies; 6+ messages in thread
From: Tom Lane @ 2004-11-17 06:25 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; +Cc: pgsql-admin
<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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 08:37 Devrim GUNDUZ <devrim@gunduz.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 6+ messages in thread
From: Devrim GUNDUZ @ 2004-11-17 08:37 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: ogjunk-pgjedan@yahoo.com; pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 13:20 ogjunk-pgjedan@yahoo.com
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 6+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2004-11-17 13:20 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 13:22 ogjunk-pgjedan@yahoo.com
parent: Devrim GUNDUZ <devrim@gunduz.org>
0 siblings, 1 reply; 6+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2004-11-17 13:22 UTC (permalink / raw)
To: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 7.3.4 -> 7.3.8 - a little stuck
@ 2004-11-17 22:20 Devrim GUNDUZ <devrim@gunduz.org>
parent: ogjunk-pgjedan@yahoo.com
0 siblings, 0 replies; 6+ messages in thread
From: Devrim GUNDUZ @ 2004-11-17 22:20 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; +Cc: pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-11-17 22:20 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-17 04:58 7.3.4 -> 7.3.8 - a little stuck ogjunk-pgjedan@yahoo.com
2004-11-17 06:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-17 08:37 ` Devrim GUNDUZ <devrim@gunduz.org>
2004-11-17 13:22 ` ogjunk-pgjedan@yahoo.com
2004-11-17 22:20 ` Devrim GUNDUZ <devrim@gunduz.org>
2004-11-17 13:20 ` ogjunk-pgjedan@yahoo.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox