Message-ID: <548B1645.1030102@exxoss.com>
Date: Fri, 12 Dec 2014 17:22:29 +0100
From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10;
 rv:31.0) Gecko/20100101 Thunderbird/31.3.0
MIME-Version: 1.0
To: Peter Eisentraut <peter_e@gmx.net>, pgsql-admin@postgresql.org
References: <5481838E.6020409@exxoss.com> <54827D54.6010907@gmx.net>
 <5482BAF2.70307@exxoss.com> <54830B26.7050602@gmx.net>
 <5485551F.9080407@exxoss.com> <5487BE4F.30009@gmx.net>
In-Reply-To: <5487BE4F.30009@gmx.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi,

I have try manualy with pg_upgrade but I got this error :


root@p2tstl2mondbm:/# sudo su - postgres -c 
'/usr/lib/postgresql/9.3/bin/pg_upgrade \
                         -b /usr/lib/postgresql/9.1/bin \
                         -B /usr/lib/postgresql/9.3/bin \
                         -d /var/lib/postgresql/9.1/main/ \
                         -D /var/lib/postgresql/9.3/main/ \
                         -O " -c 
config_file=/etc/postgresql/9.3/main/postgresql.conf" \
                         -o " -c 
config_file=/etc/postgresql/9.1/main/postgresql.conf"'
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Checking database user is a superuser                       ok
Checking for prepared transactions                          ok
Checking for reg* system OID user data types                ok
Checking for contrib/isn with bigint-passing mismatch       ok
Creating dump of global objects                             ok
Creating dump of database schemas
                                                             ok
Checking for presence of required libraries                 fatal

Your installation references loadable libraries that are missing from the
new installation.  You can add these libraries to the new installation,
or remove the functions using them from the old installation.  A list of
problem libraries is in the file:
     loadable_libraries.txt

Failure, exiting

root@p2tstl2mondbm:/# cat /home/LAMPIRIS/postgres/loadable_libraries.txt
Could not load library "$libdir/pg_buffercache"
ERROR:  could not access file "$libdir/pg_buffercache": No such file or 
directory

Could not load library "$libdir/pg_trgm"
ERROR:  could not access file "$libdir/pg_trgm": No such file or directory

Could not load library "$libdir/uuid-ossp"
ERROR:  could not access file "$libdir/uuid-ossp": No such file or directory

root@p2tstl2mondbm:/#

But the first time it was working, I canceled to find a way ton optimise 
the cpu/ram usage of the process...
But now i got the error

Any idea?

Thanks

Matthieu


Le 10/12/14 04:30, Peter Eisentraut a écrit :
> On 12/8/14 2:37 AM, Matthieu Lejeune wrote:
>> I have upgraded the postgresql-common and postgresql-client-common :
>> 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
> At this point, I think you should add some manual debug statements into
> the script and see what's going on.  The script itself is not very
> complicated, so you can tweak to make it work for you.
>
>
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin