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@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,
>