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
Re: [pgsql-cluster-hackers] Fwd: Invalid version while creating PostgreSQL 9.1 cluster
From
Hannu Krosing
Date:
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/