[Pkg-postgresql-public] Problem with pg_upgradecluster

[Bernard Moreton]

Hi Martin -

Further problems with pg_upgradecluster on Ubuntu 10.04, line 348 (see below):

sudo pg_upgradecluster -v 8.4 --lc-collate=POSIX 8.2 main
Error: target cluster 8.4/main already exists
mbm at hp-ubuntu:~$ sudo pg_dropcluster 8.4 main --stop
mbm at hp-ubuntu:~$ sudo pg_upgradecluster -v 8.4 --lc-collate=POSIX 8.2 main
Creating new cluster (configuration: /etc/postgresql/8.4/main, data: /var/lib/postgresql/8.4/main)...
Moving configuration file /var/lib/postgresql/8.4/main/postgresql.conf to /etc/postgresql/8.4/main...
Moving configuration file /var/lib/postgresql/8.4/main/pg_hba.conf to /etc/postgresql/8.4/main...
Moving configuration file /var/lib/postgresql/8.4/main/pg_ident.conf to /etc/postgresql/8.4/main...
Configuring postgresql.conf to use port 5433...
Disabling connections to the old cluster during upgrade...
Disabling connections to the new cluster during upgrade...
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Use of uninitialized value $buffer in string ne at /usr/bin/pg_upgradecluster line 348.
Error: automatic upgrade of tablespaces is not supported
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Error during cluster dumping, removing new cluster
mbm at hp-ubuntu:~$

I thought the problem with psql 'could not connect' might be due to the '--stop', but it appears not.

As far as I know, tablespaces are not in use on my 8.2 cluster:
simas=# \db
       List of tablespaces
    Name    |  Owner   | Location 
------------+----------+----------
 pg_default | postgres | 
 pg_global  | postgres | 
(2 rows)


Greetings,
Bernard

-- 
Bernard Moreton


On Tue, 17 Aug 2010 13:06:13 +0100
Bernard <bernard at tnauk.org.uk> wrote:

> Hi Martin,
> 
> Yes, /usr/lib/postgresql/8.4/bin/initdb does not exist.
> 
> dpkg -s postgresql-8.4:
> Package `postgresql-8.4' is not installed and no info is available.
> Use dpkg --info ... dpkg --contents...
> Both return "failed to read archive `postgresql-8.4'  No such file or directory.
> 
> 8.4 was got and intalled using synaptic (Ubuntu 10.04, not 9.04!!), and no error 
> messages were returned - or if they were, did not stay visible.
> 
> On reviewing Synaptic, I see that postgresql-8.4 is not marked as installed - 
> presumably the cause of the problem!
> 
> Given the confusion that surrounds upgrading postgres, would it be possible to 
> provide install and upgrade scripts that would cover all the requirements?
> 
> Many thanks for your advice!
> Bernard
> 
> 
> Bernard Moreton
> IT Director, National Talking Newspapers and Magazines (TNAUK)
> Charity registered in the UK 293656
> 
> DDI: 01 435 869 316
> 
> On 17/08/2010 05:52, Martin Pitt wrote:
> > Hello Bernard,
> >
> > Bernard [2010-08-16 14:43 +0100]:
> >> I have Postgres 8.2 running on Ubuntu 9.04, and have got down the 8.4 packages.
> >> But on trying
> >> sudo pg_upgradecluster --lc_collate=POSIX 8.2 main
> >> with or without -v 8.4
> >> I get
> >> Error: invalid version: 8.4
> >
> > This means that /usr/lib/postgresql/8.4/bin/initdb does not exist. Are
> > you sure that the "postgresql-8.4" package is properly installed? What
> > does
> >
> >    dpkg -s postgresql-8.4
> >
> > say?
> >
> > Martin


-- 
Bernard Moreton