From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
To: pgsql-admin@postgresql.org
Subject: Problem pg_upgradecluster from 9.1 to 9.3
Date: Fri, 05 Dec 2014 11:06:06 +0100
Message-ID: <5481838E.6020409@exxoss.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matthieu.lejeune@exxoss.com
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
In-Reply-To: <5481838E.6020409@exxoss.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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