|
Hi,
I have try on time this is my output it's not working : postgres@p2tstl2mondbm:~$ pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 9.1 main 5432 online postgres /var/lib/postgresql/9.1/main /var/log/postgresql/postgresql-9.1-main.log 9.3 main 5433 down postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log postgres@p2tstl2mondbm:~$ logout root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main Error: target cluster 9.3/main already exists root@p2tstl2mondbm:/var/lib/postgresql# pg_dropcluster --stop 9.3 main root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main Stopping old cluster... Disabling connections to the old cluster during upgrade... Restarting old cluster with restricted connections... Creating new cluster 9.3/main ... config /etc/postgresql/9.3/main data /var/lib/postgresql/9.3/main locale C port 5433 Disabling connections to the new cluster during upgrade... Error: automatic upgrade of tablespaces is not supported Re-enabling connections to the old cluster... Re-enabling connections to the new cluster... Error during cluster dumping, removing new cluster root@p2tstl2mondbm:/var/lib/postgresql# Thanks Matthieu Le 5/12/14 11:18, Jan Harasym a écrit : Hi Matthieu, Are you following the steps from here: http://nixmash.com/postgresql/upgrading-postgresql-9-1-to-9-3-in-ubuntu/ What's the current output of `pg_lscluster`? -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Matthieu Lejeune Sent: December 05, 2014 11:06 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Problem pg_upgradecluster from 9.1 to 9.3 Hi all, I have a problem when I try to upgrade my pgsql 9.1 cluster to 9.3 This is my output : root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main Disabling connections to the old cluster during upgrade... Restarting old cluster with restricted connections... Removed stale pid file. Creating new cluster 9.3/main ... config /etc/postgresql/9.3/main data /var/lib/postgresql/9.3/main locale C port 5433 Disabling connections to the new cluster during upgrade... Error: automatic upgrade of tablespaces is not supported Re-enabling connections to the old cluster... Re-enabling connections to the new cluster... Error during cluster dumping, removing new cluster On my db I have 2 tablespaces : postgres=# \db+ List of tablespaces Name | Owner | Location | Access privileges | Description --------------+----------+-----------------------------------------+-------------------+------------- envers | postgres | /var/lib/postgresql/tablespaces/envers | | indexes_fast | postgres | /var/lib/postgresql/tablespaces/indexes | | pg_default | postgres | | | pg_global | postgres | | | (4 rows) postgres=# This is my path config : postgres@p2tstl2mondbm:~$ cd /var/lib/postgresql/ postgres@p2tstl2mondbm:/var/lib/postgresql$ ls -all total 36 drwxr-xr-x 6 postgres postgres 4096 Dec 4 12:22 . drwxr-xr-x 27 root root 4096 Dec 4 08:17 .. drwxr-xr-x 4 postgres postgres 4096 Oct 7 07:42 9.1 drwxr-xr-x 2 postgres postgres 4096 Dec 5 10:58 9.3 drwx------ 2 postgres postgres 16384 Mar 4 2013 lost+found drwx------ 4 postgres postgres 4096 Mar 8 2013 tablespaces postgres@p2tstl2mondbm:/var/lib/postgresql$ My pgsql versions : i postgresql 9.1+134wheezy4 all object-relational SQL database (supported version) ii postgresql-9.1 9.1.14-0+deb7u1 amd64 object-relational SQL database, version 9.1 server ii postgresql-9.3 9.3.5-1.pgdg70+1 amd64 object-relational SQL database, version 9.3 server I don't find any tips on the web to help me Thank you for your advice. Matthieu Lejeune --
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 
|
