Re: Problem pg_upgradecluster from 9.1 to 9.3

Поиск

Список

Период

Сортировка

От	Matthieu Lejeune
Тема	Re: Problem pg_upgradecluster from 9.1 to 9.3
Дата	5 декабря 2014 г. 13:24:33
Msg-id	548187D5.90209@exxoss.com обсуждение исходный текст
Ответ на	Problem pg_upgradecluster from 9.1 to 9.3 (Matthieu Lejeune <matthieu.lejeune@exxoss.com>)
Список	pgsql-admin

Дерево обсуждения

Hi,

I have try on time this is my output it's not working :

postgres@p2tstl2mondbm:~$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory               Log file
9.1 main    5432 online postgres /var/lib/postgresql/9.1/main /var/log/postgresql/postgresql-9.1-main.log
9.3 main    5433 down   postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log
postgres@p2tstl2mondbm:~$ logout
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
Error: target cluster 9.3/main already exists
root@p2tstl2mondbm:/var/lib/postgresql# pg_dropcluster --stop 9.3 main
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
Stopping old cluster...
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Creating new cluster 9.3/main ...
config /etc/postgresql/9.3/main
data   /var/lib/postgresql/9.3/main
locale C
port   5433
Disabling connections to the new cluster during upgrade...
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
root@p2tstl2mondbm:/var/lib/postgresql#

Thanks

Matthieu

Le 5/12/14 11:18, Jan Harasym a écrit :

Hi Matthieu,

Are you following the steps from here: http://nixmash.com/postgresql/upgrading-postgresql-9-1-to-9-3-in-ubuntu/

What's the current output of `pg_lscluster`?

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Matthieu Lejeune
Sent: December 05, 2014 11:06 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Problem pg_upgradecluster from 9.1 to 9.3

Hi all,

I have a problem when I try to upgrade my pgsql 9.1 cluster to 9.3

This is my output :

root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Removed stale pid file.
Creating new cluster 9.3/main ...   config /etc/postgresql/9.3/main   data   /var/lib/postgresql/9.3/main   locale C   port   5433
Disabling connections to the new cluster during upgrade...
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


On my db I have 2 tablespaces :


postgres=# \db+                                          List of tablespaces      Name     |  Owner   |                Location                 | 
Access privileges | Description
--------------+----------+-----------------------------------------+-------------------+-------------  envers       | postgres | /var/lib/postgresql/tablespaces/envers 
|                   |  indexes_fast | postgres | /var/lib/postgresql/tablespaces/indexes 
|                   |  pg_default   | postgres | |                   |  pg_global    | postgres | |                   |
(4 rows)

postgres=#

This is my path config :

postgres@p2tstl2mondbm:~$ cd /var/lib/postgresql/
postgres@p2tstl2mondbm:/var/lib/postgresql$ ls -all
total 36
drwxr-xr-x  6 postgres postgres  4096 Dec  4 12:22 .
drwxr-xr-x 27 root     root      4096 Dec  4 08:17 ..
drwxr-xr-x  4 postgres postgres  4096 Oct  7 07:42 9.1
drwxr-xr-x  2 postgres postgres  4096 Dec  5 10:58 9.3
drwx------  2 postgres postgres 16384 Mar  4  2013 lost+found
drwx------  4 postgres postgres  4096 Mar  8  2013 tablespaces
postgres@p2tstl2mondbm:/var/lib/postgresql$


My pgsql versions :

i  postgresql                             9.1+134wheezy4 
all                      object-relational SQL database (supported version)
ii  postgresql-9.1                         9.1.14-0+deb7u1 
amd64                    object-relational SQL database, version 9.1 server
ii  postgresql-9.3                         9.3.5-1.pgdg70+1 
amd64                    object-relational SQL database, version 9.3 server


I don't find any tips on the web to help me

Thank you for your advice.

Matthieu Lejeune

Matthieu Lejeune, System Engineer | Gsm: +32(0)491/52.70.66
Exxoss, SPRL
Rue de la station, 2, 4347, Fexhe-le-haut-clocher | Telephone: +32(0)4/341.25.81 | Fax: +32(0)4/371.94.06