Обсуждение: Invalid version while creating PostgreSQL 9.1 cluster

Поиск
Список
Период
Сортировка

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.


Re: Invalid version while creating PostgreSQL 9.1 cluster

От
Martin Pitt
Дата:
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)