Subject: Re: [pgsql-cluster-hackers] Fwd: Invalid version while creating
	PostgreSQL 9.1 cluster
From: Hannu Krosing <hannu@2ndQuadrant.com>
To: =?UTF-8?Q?=D0=92=D0=B8=D0=BA=D1=82=D0=BE=D1=80_?=
	=?UTF-8?Q?=D0=A1=D1=82=D0=BE=D0=BB=D0=B1=D0=B8=D0=BD?=
	<viktor.stolbin@gmail.com>
Cc: pgsql-cluster-hackers@postgresql.org, pgsql-pkg-debian@postgresql.org,
	pgsql-admin@postgresql.org
In-Reply-To: <4E7C7DA8.6060809@gmail.com>
References: <4E7C7DA8.6060809@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Date: Fri, 23 Sep 2011 20:26:41 +0200
Message-ID: <1316802401.2907.19.camel@hvost>
Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable

On Fri, 2011-09-23 at 16:38 +0400, =D0=92=D0=B8=D0=BA=D1=82=D0=BE=D1=80 =D0=
=A1=D1=82=D0=BE=D0=BB=D0=B1=D0=B8=D0=BD wrote:
> Hello!

Firts, this list is not for pg_*cluster, but rather clustering, high
availability and replication solutions=20

> I'm trying create a cluster with existing data directory on Debian=20
> 2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installed from apt-get and=20
> PostgreSQL 9.1 installed from=20
> [OpenSCG](http://www.openscg.org/se/oscg_download.jsp?file=3Dpackages/pos=
tgres-9.1.0-1.i386.openscg.deb&user=3D)=20
> I want to create cluster with existing data directory and add it to=20
> postgresql-commons using command:
>=20
> pg_createcluster -d /opt/postgres/9.1/data/ -e UTF8 --locale ru_Ru -p=20
> 6432 9.1 MAIN_RU
>=20
> The result is:
>=20
> Error: invalid version: 9.1

Looks like your version of postgresql-common does not yet know about 9.1

Try using packages from=20

https://launchpad.net/~pitti/+archive/postgresql

> I found this question=20
> http://serverfault.com/questions/288612/cant-create-clusters-in-postgresq=
l-9-0=20
> but it seems in my case the problem is in postresql-commons package or=20
> in PostgreSQL 9.1 package that is installed.
>=20
> aptitude show postgresql-common
> Package: postgresql-common
> New: yes
> State: installed
> Automatically installed: yes
> Version: 94lenny1
> Priority: optional
> Section: misc
> Maintainer: Martin Pitt <mpitt@debian.org>
> Uncompressed Size: 496k
> Depends: postgresql-client-common (>=3D 94lenny1), procps, adduser,
> debconf (>=3D
> 0.5.00) | debconf-2.0, lsb-base (>=3D 3.0-3)
> Recommends: ssl-cert (>=3D 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)
>=20
>=20
> Update.
>=20
> I check this on Ubuntu 2.6.32-24-generic #39 with same deb packages, the=20
> problem is the same. I think it's in postgresql-commons facilities=20
> packaged in OpenSCG deb. PostgreSQL 9.1 is released 2011-09-11.
>=20
> Any help would be appreciated!
>=20
> Best Regurds,
> Viktor Stolbin
> Grffolabs LTD
>=20
>=20

--=20
-------
Hannu Krosing
PostgreSQL Unlimited Scalability and Performance Consultant
2ndQuadrant Nordic
PG Admin Book: http://www.2ndQuadrant.com/books/