From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
To: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
Date: Sat, 06 Dec 2014 09:14:42 +0100
Message-ID: <5482BAF2.70307@exxoss.com> (raw)
In-Reply-To: <54827D54.6010907@gmx.net>
References: <5481838E.6020409@exxoss.com>
<54827D54.6010907@gmx.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I have try, but I got a different error :
postgres 27166 0.9 0.6 1163312 49676 ? S 09:18 0:00
/usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main -c
config_file=/etc/po
postgres 27168 0.0 0.0 1163812 5604 ? Ss 09:18 0:00 \_
postgres: writer process
postgres 27169 0.0 0.0 1163812 1668 ? Ss 09:18 0:00 \_
postgres: wal writer process
postgres 27170 0.0 0.0 1164656 2996 ? Ss 09:18 0:00 \_
postgres: autovacuum launcher process
postgres 27171 0.0 0.0 67832 1784 ? Ss 09:18 0:00 \_
postgres: stats collector process
postgres 27621 0.7 0.1 212072 15388 ? S 09:19 0:00
/usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c
config_file=/etc/po
postgres 27623 0.0 0.0 212072 1764 ? Ss 09:19 0:00 \_
postgres: checkpointer process
postgres 27624 0.0 0.0 212072 1768 ? Ss 09:19 0:00 \_
postgres: writer process
postgres 27625 0.0 0.0 212072 1544 ? Ss 09:19 0:00 \_
postgres: wal writer process
postgres 27626 0.0 0.0 212784 2840 ? Ss 09:19 0:00 \_
postgres: autovacuum launcher process
postgres 27627 0.0 0.0 67748 1580 ? Ss 09:19 0:00 \_
postgres: stats collector process
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
--method=upgrade
Error: target cluster 9.3/main already exists
root@p2tstl2mondbm:/var/lib/postgresql# pg_dropcluster 9.3 main --stop
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
--method=upgrade
Stopping old cluster...
Creating new cluster 9.3/main ...
config /etc/postgresql/9.3/main
data /var/lib/postgresql/9.3/main
locale C
port 5433
Error: could not symlink configuration file
Error during cluster dumping, removing new cluster
pg_ctl: PID file "/var/lib/postgresql/9.1/main/postmaster.pid" does not
exist
Is server running?
Error: could not reload old cluster, please do that manually
root@p2tstl2mondbm:/var/lib/postgresql#
Thanks a lot
Matthieu
Le 6/12/14 04:51, Peter Eisentraut a écrit :
> On 12/5/14 5:06 AM, Matthieu Lejeune wrote:
>> Error: automatic upgrade of tablespaces is not supported
> This restriction appears to be outdated, because you can now upgrade
> tablespaces in place.
>
> If you are slightly daring, you can just patch the check out of the script.
>
> Of you can use --method=upgrade, which does not contain that check.
>
>
>
--
Exxoss <http://www.exxoss.com;
*Matthieu Lejeune*, System Engineer | Gsm: +32(0)491/52.70.66
*Exxoss, SPRL <http://www.exxoss.com>*
Rue de la station, 2, 4347, Fexhe-le-haut-clocher | Telephone:
+32(0)4/341.25.81 | Fax: +32(0)4/371.94.06
Twitter <http://twitter.com/exxossIT; Facebook
<http://facebook.com/exxoss; Linked In
<https://www.linkedin.com/company/exxoss;
Attachments:exxoss.png (image/png, 15.9K) downloadview imagetwitter.png (image/png, 3.3K) downloadview imagefacebook.png (image/png, 3.4K) downloadview imagelinkedin.png (image/png, 3.5K) downloadview image
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, peter_e@gmx.net
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
In-Reply-To: <5482BAF2.70307@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