Hi,
It's works perfectly
I have forget to install postgresql-contrib
Thanks for your help community
Matthieu
Le 12/12/14 21:36, Bruce Momjian a écrit :
On Fri, Dec 12, 2014 at 07:49:09PM +0100, Matthieu Lejeune wrote:
Do you have a documentation to do this ?
No. CREATE EXTENSION is that you want, but these would be obvious to
anyone who installed them in the old cluster.
---------------------------------------------------------------------------
Thanks for your answer
Envoyé de mon iPhone
Le 12 déc. 2014 à 19:09, Bruce Momjian <bruce@xxxxxxxxxx> a écrit :
On Fri, Dec 12, 2014 at 05:22:29PM +0100, Matthieu Lejeune wrote:
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
So you need to install the shared objects into the new cluster that were
used in the old cluster.
---------------------------------------------------------------------------
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
