pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Fwd: Invalid version while creating PostgreSQL 9.1 cluster
3+ messages / 3 participants
[nested] [flat]

* Fwd: Invalid version while creating PostgreSQL 9.1 cluster
@ 2011-09-23 12:38  Виктор Столбин <viktor.stolbin@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Виктор Столбин @ 2011-09-23 12:38 UTC (permalink / raw)
  To: pgsql-cluster-hackers@postgresql.org; pgsql-pkg-debian@postgresql.org; pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [pgsql-cluster-hackers] Fwd: Invalid version while creating PostgreSQL 9.1 cluster
@ 2011-09-23 18:26  Hannu Krosing <hannu@2ndQuadrant.com>
  parent: Виктор Столбин <viktor.stolbin@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Hannu Krosing @ 2011-09-23 18:26 UTC (permalink / raw)
  To: Виктор Столбин <viktor.stolbin@gmail.com>; +Cc: pgsql-cluster-hackers@postgresql.org; pgsql-pkg-debian@postgresql.org; pgsql-admin

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/




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [pgsql-pkg-debian] Fwd: Invalid version while creating PostgreSQL 9.1 cluster
@ 2011-09-23 21:00  Christoph Berg <myon@debian.org>
  parent: Виктор Столбин <viktor.stolbin@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Christoph Berg @ 2011-09-23 21:00 UTC (permalink / raw)
  To: Виктор Столбин <viktor.stolbin@gmail.com>; +Cc: pgsql-cluster-hackers@postgresql.org; pgsql-pkg-debian@postgresql.org; pgsql-admin

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/

Attachments:

  signature.asc (application/pgp-signature, 835B) download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-09-23 21:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-23 12:38 Fwd: Invalid version while creating PostgreSQL 9.1 cluster Виктор Столбин <viktor.stolbin@gmail.com>
2011-09-23 18:26 ` Hannu Krosing <hannu@2ndQuadrant.com>
2011-09-23 21:00 ` Christoph Berg <myon@debian.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox