pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem pg_upgradecluster from 9.1 to 9.3
13+ messages / 4 participants
[nested] [flat]
* Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-05 10:06 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
0 siblings, 2 replies; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-05 10:06 UTC (permalink / raw)
To: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-05 10:18 Jan Harasym <jan.harasym@massive.se>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
1 sibling, 1 reply; 13+ messages in thread
From: Jan Harasym @ 2014-12-05 10:18 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-05 10:24 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Jan Harasym <jan.harasym@massive.se>
0 siblings, 0 replies; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-05 10:24 UTC (permalink / raw)
To: Jan Harasym <jan.harasym@massive.se>; 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 :
> 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) download
view image
twitter.png (image/png, 3.3K) download
view image
facebook.png (image/png, 3.4K) download
view image
linkedin.png (image/png, 3.5K) download
view image
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-06 03:51 Peter Eisentraut <peter_e@gmx.net>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
1 sibling, 1 reply; 13+ messages in thread
From: Peter Eisentraut @ 2014-12-06 03:51 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; pgsql-admin
On 12/5/14 5:06 AM, Matthieu Lejeune wrote:
> Error: automatic upgrade of tablespaces is not supported
This restriction appears to be outdated, because you can now upgrade
tablespaces in place.
If you are slightly daring, you can just patch the check out of the script.
Of you can use --method=upgrade, which does not contain that check.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-06 08:14 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-06 08:14 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
Hi,
I have try, but I got a different error :
postgres 27166 0.9 0.6 1163312 49676 ? S 09:18 0:00
/usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main -c
config_file=/etc/po
postgres 27168 0.0 0.0 1163812 5604 ? Ss 09:18 0:00 \_
postgres: writer process
postgres 27169 0.0 0.0 1163812 1668 ? Ss 09:18 0:00 \_
postgres: wal writer process
postgres 27170 0.0 0.0 1164656 2996 ? Ss 09:18 0:00 \_
postgres: autovacuum launcher process
postgres 27171 0.0 0.0 67832 1784 ? Ss 09:18 0:00 \_
postgres: stats collector process
postgres 27621 0.7 0.1 212072 15388 ? S 09:19 0:00
/usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c
config_file=/etc/po
postgres 27623 0.0 0.0 212072 1764 ? Ss 09:19 0:00 \_
postgres: checkpointer process
postgres 27624 0.0 0.0 212072 1768 ? Ss 09:19 0:00 \_
postgres: writer process
postgres 27625 0.0 0.0 212072 1544 ? Ss 09:19 0:00 \_
postgres: wal writer process
postgres 27626 0.0 0.0 212784 2840 ? Ss 09:19 0:00 \_
postgres: autovacuum launcher process
postgres 27627 0.0 0.0 67748 1580 ? Ss 09:19 0:00 \_
postgres: stats collector process
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
--method=upgrade
Error: target cluster 9.3/main already exists
root@p2tstl2mondbm:/var/lib/postgresql# pg_dropcluster 9.3 main --stop
root@p2tstl2mondbm:/var/lib/postgresql# pg_upgradecluster 9.1 main
--method=upgrade
Stopping old cluster...
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#
Thanks a lot
Matthieu
Le 6/12/14 04:51, Peter Eisentraut a écrit :
> On 12/5/14 5:06 AM, Matthieu Lejeune wrote:
>> Error: automatic upgrade of tablespaces is not supported
> This restriction appears to be outdated, because you can now upgrade
> tablespaces in place.
>
> If you are slightly daring, you can just patch the check out of the script.
>
> Of you can use --method=upgrade, which does not contain that check.
>
>
>
--
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) download
view image
twitter.png (image/png, 3.3K) download
view image
facebook.png (image/png, 3.4K) download
view image
linkedin.png (image/png, 3.5K) download
view image
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-06 13:56 Peter Eisentraut <peter_e@gmx.net>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
0 siblings, 1 reply; 13+ messages in thread
From: Peter Eisentraut @ 2014-12-06 13:56 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-08 07:37 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-08 07:37 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; pgsql-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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-10 03:30 Peter Eisentraut <peter_e@gmx.net>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
0 siblings, 1 reply; 13+ messages in thread
From: Peter Eisentraut @ 2014-12-10 03:30 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-12 16:22 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-12 16:22 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-12 18:09 Bruce Momjian <bruce@momjian.us>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2014-12-12 18:09 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-12 18:49 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-12 18:49 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
Do you have a documentation to do this ?
Thanks for your answer
Envoyé de mon iPhone
> Le 12 déc. 2014 à 19:09, Bruce Momjian <bruce@momjian.us> 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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-12 20:36 Bruce Momjian <bruce@momjian.us>
parent: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2014-12-12 20:36 UTC (permalink / raw)
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
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@momjian.us> 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@postgresql.org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgsql-admin
> >
> > --
> > Bruce Momjian <bruce@momjian.us> http://momjian.us
> > EnterpriseDB http://enterprisedb.com
> >
> > + Everyone has their own god. +
> >
> >
> > --
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem pg_upgradecluster from 9.1 to 9.3
@ 2014-12-15 11:02 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 13+ messages in thread
From: Matthieu Lejeune @ 2014-12-15 11:02 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
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@momjian.us> 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@postgresql.org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-admin
>>> --
>>> Bruce Momjian <bruce@momjian.us> http://momjian.us
>>> EnterpriseDB http://enterprisedb.com
>>>
>>> + Everyone has their own god. +
>>>
>>>
>>> --
>>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2014-12-15 11:02 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-05 10:06 Problem pg_upgradecluster from 9.1 to 9.3 Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-05 10:18 ` Jan Harasym <jan.harasym@massive.se>
2014-12-05 10:24 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-06 03:51 ` Peter Eisentraut <peter_e@gmx.net>
2014-12-06 08:14 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-06 13:56 ` Peter Eisentraut <peter_e@gmx.net>
2014-12-08 07:37 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-10 03:30 ` Peter Eisentraut <peter_e@gmx.net>
2014-12-12 16:22 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-12 18:09 ` Bruce Momjian <bruce@momjian.us>
2014-12-12 18:49 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
2014-12-12 20:36 ` Bruce Momjian <bruce@momjian.us>
2014-12-15 11:02 ` Matthieu Lejeune <matthieu.lejeune@exxoss.com>
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