Thread: RPM contents for 9.2 community release.
Hi, I tried installing using the Direct Download RPMs for two systems I am using. The installation using the rpm files did not install in one case and the other did not install all files to the target directory I was expecting. 1) Upgrading postgresql on a 64 bit Fedora 16 desktop from 9.1.5 to 9.2 using the rpms provided in the download section. I tried installing with yum the rpm files but getting an error message. $ ls postgresql92-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-devel-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-server-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-contrib-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-docs-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-test-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64.rpm postgresql92-libs-9.2.0-1PGDG.f16.x86_64.rpm $ sudo yum install ./postgresql92-* Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks, presto, refresh-packagekit Examining ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-9.2.0-1PGDG.f16.x86_64 ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-contrib-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-contrib-9.2.0-1PGDG.f16.x86_64 ./postgresql92-contrib-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64 ./postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-devel-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-devel-9.2.0-1PGDG.f16.x86_64 ./postgresql92-devel-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-docs-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-docs-9.2.0-1PGDG.f16.x86_64 ./postgresql92-docs-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-libs-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-libs-9.2.0-1PGDG.f16.x86_64 ./postgresql92-libs-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-server-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-server-9.2.0-1PGDG.f16.x86_64 ./postgresql92-server-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Examining ./postgresql92-test-9.2.0-1PGDG.f16.x86_64.rpm: postgresql92-test-9.2.0-1PGDG.f16.x86_64 ./postgresql92-test-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed package. Error: Nothing to do http://yum.postgresql.org/9.2/fedora/fedora-16-x86_64/repoview/ Did I down the correct rpms ? 2) The second install was to a 64 bit RHEL6 server. The RPM files installed using yum successfully. Downloaded the files from http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/repoview/ However the files to provide postgresql tooling and server execution were not installed into /usr/bin I was trying to execute initdb. I did find it in an the 'postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm' file but the installation target directory is /usr/pgsql-9.2/bin $ ls postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm postgresql92-docs-9.2.0-1PGDG.rhel6.x86_64.rpm postgresql92-contrib-9.2.0-1PGDG.rhel6.x86_64.rpm postgresql92-libs-9.2.0-1PGDG.rhel6.x86_64.rpm postgresql92-devel-9.2.0-1PGDG.rhel6.x86_64.rpm postgresql92-server-9.2.0-1PGDG.rhel6.x86_64.rpm $ ls /usr/pgsql-9.2/bin clusterdb droplang pg_archivecleanup pg_ctl pg_restore postgres vacuumlo createdb dropuser pg_basebackup pg_dump pg_standby postmaster createlang ecpg pgbench pg_dumpall pg_test_fsync psql createuser initdb pg_config pg_receivexlog pg_test_timing reindexdb dropdb oid2name pg_controldata pg_resetxlog pg_upgrade vacuumdb [postgres@benchserver2 tmp]$ That means users on the system cannot immediately execute these files. Was there a mistake in the packaging paths of these files in the RPM ? Regards, Jeremy -- Jeremy Whiting
Hi Jeremy, On Wed, September 12, 2012 6:23 pm, Jeremy Whiting wrote: > I tried installing using the Direct Download RPMs for two systems I am > using. The installation using the rpm files did not install in one case > and the other did not install all files to the target directory I was > expecting. > > 1) Upgrading postgresql on a 64 bit Fedora 16 desktop from 9.1.5 to 9.2 > using the rpms provided in the download section. I tried installing with > yum the rpm files but getting an error message. > > $ ls > postgresql92-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-devel-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-server-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-contrib-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-docs-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-test-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64.rpm > postgresql92-libs-9.2.0-1PGDG.f16.x86_64.rpm > $ sudo yum install ./postgresql92-* > Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks, presto, > refresh-packagekit > Examining ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: > postgresql92-9.2.0-1PGDG.f16.x86_64 > ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed > package. <snip> Community RPMs cannot be used to upgrade Fedora's own RPMs, since the package names are different and we have a different layout, so this seems ok to me. > http://yum.postgresql.org/9.2/fedora/fedora-16-x86_64/repoview/ > > Did I down the correct rpms ? Yes. > 2) The second install was to a 64 bit RHEL6 server. The RPM files > installed using yum successfully. Downloaded the files from > > http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/repoview/ > > However the files to provide postgresql tooling and server execution > were not installed into > > /usr/bin > > I was trying to execute initdb. I did find it in an the > 'postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm' file but the installation > target directory is > > /usr/pgsql-9.2/bin Right. I have a blog post regarding this in here: http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html (though this post needs some fixes, like init script name, etc) I changed the layout, so that we can install multiple versions in parallel. For initdb, you can use service postgresql-9.2 initdb > $ ls > postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm > postgresql92-docs-9.2.0-1PGDG.rhel6.x86_64.rpm > postgresql92-contrib-9.2.0-1PGDG.rhel6.x86_64.rpm > postgresql92-libs-9.2.0-1PGDG.rhel6.x86_64.rpm > postgresql92-devel-9.2.0-1PGDG.rhel6.x86_64.rpm > postgresql92-server-9.2.0-1PGDG.rhel6.x86_64.rpm > $ ls /usr/pgsql-9.2/bin > clusterdb droplang pg_archivecleanup pg_ctl pg_restore > postgres vacuumlo > createdb dropuser pg_basebackup pg_dump pg_standby > postmaster > createlang ecpg pgbench pg_dumpall pg_test_fsync > psql > createuser initdb pg_config pg_receivexlog pg_test_timing > reindexdb > dropdb oid2name pg_controldata pg_resetxlog pg_upgrade > vacuumdb > [postgres@benchserver2 tmp]$ > > That means users on the system cannot immediately execute these files. > > Was there a mistake in the packaging paths of these files in the RPM ? That is intentional. See here: http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/postgresql-9.2.spec#L576 The binaries I put under /usr/bin are the ones that can be used for multiple versions, like psql, etc. Utilities like pg_ctl, initdb, pg_controldata and pg_resetxlog are not among these, so they are kept under /usr/pgsql-9.2/bin. Regards, -- Temporarily using a webmail program.
Hi Devrim, Thank you for pointing these facts out. Very helpful and I now have my installations working without issue. Changing the scripts as you have done is very useful for parallel installations. It will make my work easier. Regards, Jeremy On 12/09/12 16:57, Devrim GUNDUZ wrote: > Hi Jeremy, > > On Wed, September 12, 2012 6:23 pm, Jeremy Whiting wrote: > >> I tried installing using the Direct Download RPMs for two systems I am >> using. The installation using the rpm files did not install in one case >> and the other did not install all files to the target directory I was >> expecting. >> >> 1) Upgrading postgresql on a 64 bit Fedora 16 desktop from 9.1.5 to 9.2 >> using the rpms provided in the download section. I tried installing with >> yum the rpm files but getting an error message. >> >> $ ls >> postgresql92-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-devel-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-server-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-contrib-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-docs-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-test-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-debuginfo-9.2.0-1PGDG.f16.x86_64.rpm >> postgresql92-libs-9.2.0-1PGDG.f16.x86_64.rpm >> $ sudo yum install ./postgresql92-* >> Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks, presto, >> refresh-packagekit >> Examining ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: >> postgresql92-9.2.0-1PGDG.f16.x86_64 >> ./postgresql92-9.2.0-1PGDG.f16.x86_64.rpm: does not update installed >> package. > <snip> > > Community RPMs cannot be used to upgrade Fedora's own RPMs, since the > package names are different and we have a different layout, so this seems > ok to me. > >> http://yum.postgresql.org/9.2/fedora/fedora-16-x86_64/repoview/ >> >> Did I down the correct rpms ? > Yes. > >> 2) The second install was to a 64 bit RHEL6 server. The RPM files >> installed using yum successfully. Downloaded the files from >> >> http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/repoview/ >> >> However the files to provide postgresql tooling and server execution >> were not installed into >> >> /usr/bin >> >> I was trying to execute initdb. I did find it in an the >> 'postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm' file but the installation >> target directory is >> >> /usr/pgsql-9.2/bin > Right. I have a blog post regarding this in here: > http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html > > (though this post needs some fixes, like init script name, etc) > > I changed the layout, so that we can install multiple versions in parallel. > > For initdb, you can use > > service postgresql-9.2 initdb > >> $ ls >> postgresql92-9.2.0-1PGDG.rhel6.x86_64.rpm >> postgresql92-docs-9.2.0-1PGDG.rhel6.x86_64.rpm >> postgresql92-contrib-9.2.0-1PGDG.rhel6.x86_64.rpm >> postgresql92-libs-9.2.0-1PGDG.rhel6.x86_64.rpm >> postgresql92-devel-9.2.0-1PGDG.rhel6.x86_64.rpm >> postgresql92-server-9.2.0-1PGDG.rhel6.x86_64.rpm >> $ ls /usr/pgsql-9.2/bin >> clusterdb droplang pg_archivecleanup pg_ctl pg_restore >> postgres vacuumlo >> createdb dropuser pg_basebackup pg_dump pg_standby >> postmaster >> createlang ecpg pgbench pg_dumpall pg_test_fsync >> psql >> createuser initdb pg_config pg_receivexlog pg_test_timing >> reindexdb >> dropdb oid2name pg_controldata pg_resetxlog pg_upgrade >> vacuumdb >> [postgres@benchserver2 tmp]$ >> >> That means users on the system cannot immediately execute these files. >> >> Was there a mistake in the packaging paths of these files in the RPM ? > That is intentional. See here: > http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/postgresql-9.2.spec#L576 > > The binaries I put under /usr/bin are the ones that can be used for > multiple versions, like psql, etc. Utilities like pg_ctl, initdb, > pg_controldata and pg_resetxlog are not among these, so they are kept > under /usr/pgsql-9.2/bin. > > Regards, >