Re: Problem pg_upgradecluster from 9.1 to 9.3

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>