From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
To: Jan Harasym <jan.harasym@massive.se>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
Date: Fri, 05 Dec 2014 11:24:21 +0100
Message-ID: <548187D5.90209@exxoss.com> (raw)
In-Reply-To: <a6d5fa80ff6d4b619d20a33403ba3346@pdc-mail-exch05.ubisoft.org>
References: <5481838E.6020409@exxoss.com>
<a6d5fa80ff6d4b619d20a33403ba3346@pdc-mail-exch05.ubisoft.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 :
> 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
>
>
>
--
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;
Attachments:exxoss.png (image/png, 15.9K) downloadview imagetwitter.png (image/png, 3.3K) downloadview imagefacebook.png (image/png, 3.4K) downloadview imagelinkedin.png (image/png, 3.5K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matthieu.lejeune@exxoss.com, jan.harasym@massive.se
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
In-Reply-To: <548187D5.90209@exxoss.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox