Re: Problem pg_upgradecluster from 9.1 to 9.3 - Mailing list pgsql-admin
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 :
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Matthieu Lejeune Sent: December 05, 2014 11:06 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] 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
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: