Thread: Fwd: Invalid version while creating PostgreSQL 9.1 cluster

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@debian.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!

Best Regurds,
Viktor Stolbin
Grffolabs LTD

On Fri, 2011-09-23 at 16:38 +0400, Виктор Столбин wrote:
> Hello!

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

> 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

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

Try using packages from

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

> 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@debian.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!
>
> Best Regurds,
> Viktor Stolbin
> Grffolabs LTD
>
>

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

Re: Виктор Столбин 2011-09-23 <4E7C7DA8.6060809@gmail.com>
> 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=)

Why don't you use the 9.1 packages from Debian? The backport versions
(backports.debian.org) should become available any day now.

Christoph
--
cb@df7cb.de | http://www.df7cb.de/