Question about the contrib rpm ?

DANTE ALEXANDRA <ALEXANDRA.DANTE@BULL.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

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:

On 3/3/06, Agnes Bocchino <agnes.bocchino@bull.net> wrote:

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" ?

If you're building your own rpm you'll need to do it yourself - that's
getting beyond what this list can help you with.

Or should we used the "contrib" rpm available in the web site

No - because it's not built for your system or with your compiler, it
may work but you may also run into strange bugs.

Hello,

We are working with PostGreSQL since november 2005, and ours questions
are automatically those of novice persons, that's why your answer
suprises us.

The aim of our question about the "contrib" rpm was to understand why
this package exists, what it is used for, and how generate it. We know
that we are building our own rpm, but by doing this, we also test
PostGreSQL on an IA64 platform...

Thank you for your help.

Regards,
Agn�s & Alexandra

chris smith a �crit :

On Mon, Mar 06, 2006 at 02:17:16PM +0100, DANTE ALEXANDRA wrote:

Hello,

We are working with PostGreSQL since november 2005, and ours questions
are automatically those of novice persons, that's why your answer
suprises us.

The aim of our question about the "contrib" rpm was to understand why
this package exists, what it is used for, and how generate it. We know
that we are building our own rpm, but by doing this, we also test
PostGreSQL on an IA64 platform...

Sure. The contrib rpm contains everything in the contrib directory.
Look in there if you want to see what it is. They have README files.

The reason nobody can help you here is because not a lot of people here
know anything about rpms at all and thus don't know how to answer your
question. If you compile the stuff in contrib and include it in your
main package, fine. It's just seperated out because not everybody needs
it. It's not part of the core postgresql.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Martijn van Oosterhout a �crit :

On Mon, Mar 06, 2006 at 02:17:16PM +0100, DANTE ALEXANDRA wrote:

Hello,

We are working with PostGreSQL since november 2005, and ours questions
are automatically those of novice persons, that's why your answer
suprises us.

The aim of our question about the "contrib" rpm was to understand why
this package exists, what it is used for, and how generate it. We know
that we are building our own rpm, but by doing this, we also test
PostGreSQL on an IA64 platform...

Sure. The contrib rpm contains everything in the contrib directory.
Look in there if you want to see what it is. They have README files.

The reason nobody can help you here is because not a lot of people here
know anything about rpms at all and thus don't know how to answer your
question. If you compile the stuff in contrib and include it in your
main package, fine. It's just seperated out because not everybody needs
it. It's not part of the core postgresql.

Have a nice day,

Thank you for your answer.
We will try to generate a "contrib" rpm from the contrib directory on an
IA64 platform with the Intel compiler icc.

Regards,
Agn�s & Alexandra

DANTE ALEXANDRA wrote:

Martijn van Oosterhout a �crit :

On Mon, Mar 06, 2006 at 02:17:16PM +0100, DANTE ALEXANDRA wrote:

Hello,

We are working with PostGreSQL since november 2005, and ours
questions are automatically those of novice persons, that's why your
answer suprises us.

The aim of our question about the "contrib" rpm was to understand why
this package exists, what it is used for, and how generate it. We
know that we are building our own rpm, but by doing this, we also
test PostGreSQL on an IA64 platform...

Sure. The contrib rpm contains everything in the contrib directory.
Look in there if you want to see what it is. They have README files.

The reason nobody can help you here is because not a lot of people here
know anything about rpms at all and thus don't know how to answer your
question. If you compile the stuff in contrib and include it in your
main package, fine. It's just seperated out because not everybody needs
it. It's not part of the core postgresql.

Have a nice day,

Thank you for your answer.
We will try to generate a "contrib" rpm from the contrib directory on an
IA64 platform with the Intel compiler icc.

You could always take the .src.rpm and recompile it. It will create the
same packages as postgresql does (so -libs, -contrib, -devel etc) but
using your icc compiler.

--
Postgresql & php tutorials
http://www.designmagick.com/