From: | Matthieu Lejeune <matthieu(dot)lejeune(at)exxoss(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Problem pg_upgradecluster from 9.1 to 9.3 |
Date: | 2014-12-06 08:14:42 |
Message-ID: | 5482BAF2.70307@exxoss.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(at)p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
--method=upgrade
Error: target cluster 9.3/main already exists
root(at)p2tstl2mondbm:/var/lib/postgresql# pg_dropcluster 9.3 main --stop
root(at)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(at)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>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2014-12-06 13:26:32 | Re: Does "pg_ctl stop" wait for archiving to complete? |
Previous Message | Peter Eisentraut | 2014-12-06 03:51:48 | Re: Problem pg_upgradecluster from 9.1 to 9.3 |