Thread: pg_upgrade missing
All,
I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded it today).
however, pg_upgrade is not showing in the 9.1 bin.
Here are the steps I executed:
rpm -ivh ./pgdg-centos91-9.1-4.noarch.rpm
yum install postgresql91-server which gave me a dependency error so I ran rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64
then
yum install postgresql91-server again and it worked.
but there is no pg_upgrade in the new bin dir.
[root@sociallinux bin]# pwd
/usr/pgsql-9.0/bin
[root@sociallinux bin]# ls
clusterdb createdb createlang createuser dropdb droplang dropuser oid2name pg_archivecleanup pgbench pg_dump pg_dumpall pg_restore pg_standby pg_upgrade psql reindexdb vacuumdb vacuumlo
[root@sociallinux bin]#
pwd
/usr/pgsql-9.1/bin
[root@sociallinux bin]# ls
clusterdb createlang dropdb dropuser pg_basebackup pg_controldata pg_dump pg_resetxlog pg_test_fsync postmaster reindexdb
createdb createuser droplang initdb pg_config pg_ctl pg_dumpall pg_restore postgres psql vacuumdb
[root@sociallinux bin]#
Not sure how to proceed.
Thanks
Matthias
On Wed, 2012-06-06 at 11:35 -0400, Matthias Howell wrote: > > > I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded > it today) > > however, pg_upgrade is not showing in the 9.1 bin. You need -contrib subpackage for pg_upgrade. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
"Matthias Howell" <Matthias.Howell@voxco.com> writes: > I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded > it today). > however, pg_upgrade is not showing in the 9.1 bin. Not sure about how Devrim is doing this, but in my RPM sets, pg_upgrade is in a separate subpackage postgresql-upgrade, so that you can easily remove it (along with its requisite copy of the 9.0 programs) when you're done with it. Check the repo you're pulling from for more subpackages ... regards, tom lane
On Wed, 2012-06-06 at 12:07 -0400, Matthias Howell wrote: > Checking current, bin, and data directories > check for /usr/pgsql-9.0/bin/postgres failed - No such file or > directory > Failure, exiting > > > Not sure where to go from here. (Please keep the list in the CC) The message is simple: You need to keep 9.0 RPMs around, so that pg_upgrade can run. Install them, too. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
To bring some closure:
I installed the -contrib as well which gave me pg_upgrade.
Then I ran into a missing postgres file issue with pg_upgrade.
I realized that the rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64 that I had run probably caused the issue so I reinstalled 9.0
Then I hit this issue and used the instructions here to get it to run.
http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php
It completed successfully.
Thanks for the help.
Matthias
From: Matthias Howell
Sent: Wednesday, June 06, 2012 11:36 AM
To: 'pgsql-novice@postgresql.org'
Subject: pg_upgrade missing
All,
I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded it today).
however, pg_upgrade is not showing in the 9.1 bin.
Here are the steps I executed:
rpm -ivh ./pgdg-centos91-9.1-4.noarch.rpm
yum install postgresql91-server which gave me a dependency error so I ran rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64
then
yum install postgresql91-server again and it worked.
but there is no pg_upgrade in the new bin dir.
[root@sociallinux bin]# pwd
/usr/pgsql-9.0/bin
[root@sociallinux bin]# ls
clusterdb createdb createlang createuser dropdb droplang dropuser oid2name pg_archivecleanup pgbench pg_dump pg_dumpall pg_restore pg_standby pg_upgrade psql reindexdb vacuumdb vacuumlo
[root@sociallinux bin]#
pwd
/usr/pgsql-9.1/bin
[root@sociallinux bin]# ls
clusterdb createlang dropdb dropuser pg_basebackup pg_controldata pg_dump pg_resetxlog pg_test_fsync postmaster reindexdb
createdb createuser droplang initdb pg_config pg_ctl pg_dumpall pg_restore postgres psql vacuumdb
[root@sociallinux bin]#
Not sure how to proceed.
Thanks
Matthias
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> writes: > The message is simple: You need to keep 9.0 RPMs around, so that > pg_upgrade can run. Install them, too. You might want to think about adopting the packaging layout I'm using for Fedora: pg_upgrade and back-branch executables all wrapped into a separate subpackage. Prevents this type of mistake. regards, tom lane
On Wed, 2012-06-06 at 16:42 -0400, Tom Lane wrote: > Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> writes: > > The message is simple: You need to keep 9.0 RPMs around, so that > > pg_upgrade can run. Install them, too. > > You might want to think about adopting the packaging layout I'm using > for Fedora: pg_upgrade and back-branch executables all wrapped into > a separate subpackage. Prevents this type of mistake. It is nice for Fedora, but PGDG RPMs have the parallel installation capability, so those binaries would conflict with the previous version. Still, I could push a "pg_upgrade_from_9.1_to_9.2" (or whatever) RPM, that would require both 9.0 and 9.1 to be installed, and use your scripts to upgrade 9.1 to 9.2 (or so) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz