Re: RPM contents for 9.2 community release.

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(at)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,
>