Re: Problem pg_upgradecluster from 9.1 to 9.3 - Mailing list 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@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 :
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 supportedThis 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.
--
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
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
Attachment
pgsql-admin by date: