two issues with v12 beta3

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-pkg-yum(at)postgresql(dot)org
Subject: two issues with v12 beta3
Date: 2019-08-22 12:46:53
Message-ID: 20190822124653.GA15332@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

One of our customers is shutting down, so I took the opportunity to upgrade
their DB to v12b3.

I found 2 issues:

The initscript and refuses to start for beta versions.
|[pryzbyj(at)telsasoft ~]$ sudo /etc/init.d/postgresql-12 start
|
|An old version of the database format was found.
|You need to upgrade the data format before using PostgreSQL.
|See (Your System's documentation directory)/postgresql-12beta2/README.rpm-dist for more information.

Due to:
++ cat /var/lib/pgsql/12/data/PG_VERSION
+ '[' x12 '!=' x12beta2 ']'

# PGMAJORVERSION is major version, e.g., 10 (this should match PG_VERSION)
PGMAJORVERSION=`echo "$PGVERSION" | sed 's/^\([0-9]*\)\.[0-9]*$/\1/'`

I guess it should s/beta[0-9]*$//, or (I suggested in the past):
PGMAJORVERSION=${PGVERSION%%.*}

Also, for centos6, v12b2 is available but not 12b3??

[pryzbyj(at)telsasoft ~]$ sudo yum list --showdu postgresql12
Loaded plugins: fastestmirror, rhnplugin, security
There was an error communicating with RHN.
Red Hat Satellite or RHN Classic support will be disabled.
rhn-plugin: Error communicating with server. The message was:
Connection reset by peer
Loading mirror speeds from cached hostfile
* base: mirror.hostduplex.com
* extras: centos.mirrors.tds.net
* ius: ord.mirror.rackspace.com
* rpmforge: rpmfind.net
* updates: mirror.sfo12.us.leaseweb.net
Installed Packages
postgresql12.x86_64 12beta2-1PGDG.rhel6 @pgdg12-updates-testing
Available Packages
postgresql12.x86_64 12beta1-1PGDG.rhel6 pgdg12-updates-testing
postgresql12.x86_64 12beta2-1PGDG.rhel6 pgdg12-updates-testing

https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-6-x86_64/
Which is strange..since I've already upgraded to b3....

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Devrim Gündüz 2019-08-22 14:28:30 Re: postgresql 10 on s390x installation error
Previous Message Christophe Courtois 2019-08-22 12:02:53 PostGIS 2.5 on Cent OS 6