Re: Question about the contrib rpm ?

Hello Tom, hello List,

Sorry if we haven't been clear in our first mail.
We don't really understand your answer.
So, we try to clarify our general question and give more details :

When we go on the web site to download PostgreSQL 8.1.2,
we find not only the serveur rpm but also some others rpms.
and we don't kow which of them we have to install together with our rpm
make from the 8.1.2 targz.

We are making our rpm on Novascale Ia64
We have used the "postgresql-8.1.2.tar.gz" file downloaded from the
PostGreSQL web site. From that file, we have re-compiled PostGreSQL for
IA64 on Red Hat Enterprise Linux 4 AS, with the "icc" Intel compiler.
We would like to 'deliver' a more complete set as possible.
and we don't know if we have to package some others packages..
For the langage python,perl,tcl .......we know that if we need them we
have to use the --with option when we compile.
It seems also to us that it is not necessary to have the lib rpm as the
necessary librairies are include in the rpm when wecompile and package it.
but ..............we dont' know what doing with the *contrib *rpm
available on the net, should we have to deliver it with our rpm.

Why this question ?
When we have extract files from the archive file, we have obtained these
directories :
[/BUILD/postgresql-8.1.2]$ ls -ltr
total 1528
-rw-r--r-- 1 postdev pgsql 445 Apr 23 2004 aclocal.m4
-rw-r--r-- 1 postdev pgsql 1375 Oct 1 2004 README
-rw-r--r-- 1 postdev pgsql 1412 Oct 6 2004 Makefile
-rw-r--r-- 1 postdev pgsql 1192 Dec 31 2004 COPYRIGHT
-rw-r--r-- 1 postdev pgsql 3435 May 1 2005 GNUmakefile.in
-rwxr-xr-x 1 postdev pgsql 689752 Jan 5 05:02 configure
-rw-r--r-- 1 postdev pgsql 43596 Jan 5 05:02 configure.in
-rw-r--r-- 1 postdev pgsql 387774 Jan 6 05:09 HISTORY
-rw-r--r-- 1 postdev pgsql 44484 Jan 6 05:09 INSTALL
drwxr-xr-x 2 postdev pgsql 4096 Jan 6 05:09 config
drwxr-xr-x 35 postdev pgsql 4096 Jan 6 05:09 *contrib*
-rw-r--r-- 1 postdev pgsql 3435 Feb 16 12:22 GNUmakefile
-rwxr-xr-x 1 postdev pgsql 56658 Feb 16 12:22 config.status
drwxr-xr-x 15 postdev pgsql 4096 Feb 16 12:22 src
drwxr-xr-x 7 postdev pgsql 4096 Feb 16 12:22 doc
-rw-r--r-- 1 postdev pgsql 278305 Feb 16 12:22 config.log

Under the "contrib" repertory, we have among others things
"*start-scripts*" directory which contains the "linux" file which allows
to launch automatically PostGreSQL each time the machine reboots.
[ contrib]# ls
adddepend dblink intarray mSQL-interface
pgstattuple tablefunc
btree_gist dbmirror isbn_issn oid2name
pg_trgm tips
chkpass earthdistance lo oracle
README tsearch2
contrib-global.mk fulltextindex ltree pgbench
seg userlock
cube fuzzystrmatch mac pg_buffercache
spi vacuumlo
dbase intagg Makefile pgcrypto
start-scripts xml2

And when we install our rpm, we don't have a "contrib" directory such as
this obtains after having extracted the files from the tar.gz archive.
Our question is how to add in the rpm that we have generated a "contrib"
directory, in order to have scripts like "linux" ?
Or should we used the "contrib" rpm available in the web site
Or we have to regenerate the contrib rpm from the source rpm?
Or should we install the "contrib" rpm available in the web site, even
if it has not been compiled for IA64 ?
Or Should we recompile this rpm with gcc and it will be compatible with
our rpm compiled with icc?

We found in the archive documentation information about start-script,
we don't find anything else about init script, what do you mean with
'init script' , is-it the pg_ctl command ?

and is there a documentation abou all 'things' we see under the contrib
directory (from the targz)

Thank you having read us until the end ............
and thanks again for your help

regards
A&A

Tom Lane wrote:

>DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET> writes:
>
>
>>We have a question about the contrib rpm.
>>To have some tools like the "start_scripts", should we :
>>
>>
>
>I don't believe the RPM distribution includes contrib/start-scripts
>(mainly because that contrib directory has no Makefile that would
>install the scripts). I cannot see why you'd want them, since
>the postgresql-server RPM already has an init script that is
>considerably more appropriate for RPM-based distros than the one
>that's in contrib.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
>