From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
To: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
Date: Mon, 08 Dec 2014 08:37:03 +0100
Message-ID: <5485551F.9080407@exxoss.com> (raw)
In-Reply-To: <54830B26.7050602@gmx.net>
References: <5481838E.6020409@exxoss.com>
<54827D54.6010907@gmx.net>
<5482BAF2.70307@exxoss.com>
<54830B26.7050602@gmx.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I have upgraded the postgresql-common and postgresql-client-common :
ii postgresql-9.1 9.1.14-1.pgdg70+1 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
ii postgresql-client-9.1 9.1.14-1.pgdg70+1
amd64 front-end programs for PostgreSQL 9.1
ii postgresql-client-9.3 9.3.5-1.pgdg70+1
amd64 front-end programs for PostgreSQL 9.3
ii postgresql-client-common 163
all manager for multiple PostgreSQL client versions
iF postgresql-common 163
all PostgreSQL database-cluster manager
But I got the same error :
root@p2tstl2mondbm:/var/lib# pg_upgradecluster 9.1 main --method=upgrade
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Stopping old cluster...
Creating new cluster 9.3/main ...
config /etc/postgresql/9.3/main
data /var/lib/postgresql/9.3/main
locale C
Flags of /var/lib/postgresql/9.3/main set as ---------------C
port 5433
Error: could not create symlink /var/lib/postgresql/9.1/main/pg_ident.conf
Re-enabling connections to the old cluster...
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#
Thanks a lot for your help
Matthieu
Le 6/12/14 14:56, Peter Eisentraut a écrit :
> On 12/6/14 3:14 AM, Matthieu Lejeune wrote:
>> 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#
> It's trying to symlink the configuration files into the data directory
> before calling pg_upgrade. I think it complains that the symlinks are
> already there, from a previous runs. Could could try manually removing
> them from the data directory.
>
> This was apparently fixed in postgresql-common version 155 (see
> https://github.com/petere/postgresql-common/commit/323253ed95ec00faaf042217749e3f4c7e3617b3).
> If you want to, you could also try to get an updated version from
> apt.postgresql.org.
>
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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, peter_e@gmx.net
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
In-Reply-To: <5485551F.9080407@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