Обсуждение: Question about the contrib rpm ?
Hello, We have generated a rpm with PostGreSQL 8.1.2, from the "tar.gz" file, compiled with the "icc" Intel compiler on Red Hat Enterprise Linux 4 AS. During the compilation, we have had few warnings, but nevertheless, we work with this rpm without trouble. We have a question about the contrib rpm. To have some tools like the "start_scripts", should we : 1. specify an option or anything else during the generation of the rpm ? (from "tar.gz" file) 2. download the contrib rpm from the PostGreSQL web site and use it with our rpm ? 3. download the contrib rpm from the PostGreSQL web site and recompile it with the "icc" Intel compiler ? We think that it is a newbie question, but we haven't found some tips about this. Thanks a lot. Regards, Agnès & Alexandra
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: >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 > >---------------------------(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 > > >
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 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. > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings > > >
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/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Вложения
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/