Re: Problem pg_upgradecluster from 9.1 to 9.3

Matthieu Lejeune <matthieu.lejeune@xxxxxxxxxx> · Sat, 06 Dec 2014 09:14:42 +0100

    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.

    -- 

          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