Invalid version while creating PostgreSQL 9.1 cluster

Lists: pgsql-pkg-debian
From: Виктор Столбин <viktor(dot)stolbin(at)gmail(dot)com>
To: pgsql-cluster-hackers(at)postgresql(dot)org, pgsql-pkg-debian(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Invalid version while creating PostgreSQL 9.1 cluster
Date: 2011-09-23 11:53:57
Message-ID: 4E7C7355.3040608@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-pkg-debian

Hello!
I'm trying create a cluster with existing data directory on Debian
2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installed from apt-get and
PostgreSQL 9.1 installed from
[OpenSCG](http://www.openscg.org/se/oscg_download.jsp?file=packages/postgres-9.1.0-1.i386.openscg.deb&user=)
I want to create cluster with existing data directory and add it to
postgresql-commons using command:

pg_createcluster -d /opt/postgres/9.1/data/ -e UTF8 --locale ru_Ru
-p 6432 9.1 MAIN_RU

The result is:

Error: invalid version: 9.1

I found this question
http://serverfault.com/questions/288612/cant-create-clusters-in-postgresql-9-0
but it seems in my case the problem is in postresql-commons package or
in PostgreSQL 9.1 package that is installed.

aptitude show postgresql-common
Package: postgresql-common
New: yes
State: installed
Automatically installed: yes
Version: 94lenny1
Priority: optional
Section: misc
Maintainer: Martin Pitt <mpitt(at)debian(dot)org>
Uncompressed Size: 496k
Depends: postgresql-client-common (>= 94lenny1), procps, adduser,
debconf (>=
0.5.00) | debconf-2.0, lsb-base (>= 3.0-3)
Recommends: ssl-cert (>= 1.0.11)
Conflicts: postgresql (< 7.5), postgresql-7.4 (< 1:7.4.8-10),
postgresql-8.0 (<
8.0.3-7), postgresql-client (< 7.5)
Replaces: postgresql (< 7.5), postgresql-client (< 7.5)

Update.

I check this on Ubuntu 2.6.32-24-generic #39 with same deb packages, the
problem is the same. I think it's in postgresql-commons facilities
packaged in OpenSCG deb. PostgreSQL 9.1 is released 2011-09-11.

Any help would be appreciated.


From: Martin Pitt <mpitt(at)debian(dot)org>
To: Виктор Столбин <viktor(dot)stolbin(at)gmail(dot)com>
Cc: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Re: Invalid version while creating PostgreSQL 9.1 cluster
Date: 2011-09-30 20:32:58
Message-ID: 20110930203258.GC3467@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-pkg-debian

Hello Виктор,

Виктор Столбин [2011-09-23 15:53 +0400]:
> I'm trying create a cluster with existing data directory on Debian
> 2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installed from apt-get
> and PostgreSQL 9.1 installed from [OpenSCG](http://www.openscg.org/se/oscg_download.jsp?file=packages/postgres-9.1.0-1.i386.openscg.deb&user=)

Seems I need to specify an email address/account there, so I'm not
that fancy trying it myself. Is that package actually built for usage
with postgresql-common? If it's a completely independent packaging
from upstream release, it's most probably not (postgresql-common is
Debian/Ubuntu specific and requires the Debian/Ubuntu packages of
postgresql-9.1).

If you need 9.1 and want to use p-common tools, I rather recommend you
to install from backports.org (Debian) or my Ubuntu PostgreSQL
backports PPA (https://launchpad.net/~pitti/+archive/postgresql)

Otherwise you need to read the documentation at openscg, I'm afraid I
don't know how these packages work.

Thanks,

Martin

--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)