Thread: Installing Postgres - newbie
Hi, I am installing Postgres for the first time on my Linux machine , I found the following RPM packages for the RedHat 9 postgresql-7.4.6-2PGDG.i686.rpm postgresql-contrib-7.4.6-2PGDG.i686.rpm postgresql-devel-7.4.6-2PGDG.i686.rpm postgresql-docs-7.4.6-2PGDG.i686.rpm postgresql-jdbc-7.4.6-2PGDG.i686.rpm postgresql-libs-7.4.6-2PGDG.i686.rpm postgresql-pl-7.4.6-2PGDG.i686.rpm postgresql-python-7.4.6-2PGDG.i686.rpm postgresql-server-7.4.6-2PGDG.i686.rpm postgresql-tcl-7.4.6-2PGDG.i686.rpm postgresql-test-7.4.6-2PGDG.i686.rpm How do i know which one is for installing the Postgres server and what are the other packages for ? do i have to install all these packages too ? Can anyone please tell what these each packages are for ? Thanks! Pallav
Pallav Kalva <pkalva@deg.cc> writes: > How do i know which one is for installing the Postgres server and > what are the other packages for ? You could read the package descriptions ... > do i have to install all these packages too ? Might as well. The ones that could reasonably be considered optional aren't really big enough to be worth leaving out, with the possible exception of -test and even that's only a megabyte. regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Thu, 4 Nov 2004, Pallav Kalva wrote: > I am installing Postgres for the first time on my Linux machine , I found > the following RPM packages for the RedHat 9 > > postgresql-7.4.6-2PGDG.i686.rpm postgresql-contrib-7.4.6-2PGDG.i686.rpm > postgresql-devel-7.4.6-2PGDG.i686.rpm postgresql-docs-7.4.6-2PGDG.i686.rpm > postgresql-jdbc-7.4.6-2PGDG.i686.rpm postgresql-libs-7.4.6-2PGDG.i686.rpm > postgresql-pl-7.4.6-2PGDG.i686.rpm postgresql-python-7.4.6-2PGDG.i686.rpm > postgresql-server-7.4.6-2PGDG.i686.rpm postgresql-tcl-7.4.6-2PGDG.i686.rpm > postgresql-test-7.4.6-2PGDG.i686.rpm > > How do i know which one is for installing the Postgres server and what are > the other packages for ? do i have to install all these packages too ? > Can anyone please tell what these each packages are for ? Here they are: postgresql : If you want to manipulate a PostgreSQL database on a remote PostgreSQL server, you need this package. postgresql-libs : The postgresql-libs package provides the essential shared libraries for any PostgreSQL client program or interface. You will need to install this package to use any other PostgreSQL package or any clients that need to connect to a PostgreSQL server. postgresql-contrib : The postgresql-contrib package includes the contrib tree distributed with the PostgreSQL tarball. Selected contrib modules are prebuilt. postgresql-devel : The postgresql-devel package contains the header files and libraries needed to compile C or C++ applications which will directly interact with a PostgreSQL database management server and the ecpg Embedded C Postgres preprocessor. You need to install this package if you want to develop applications which will interact with a PostgreSQL server. postgresql-docs : The postgresql-docs package includes the SGML source for the documentation as well as the documentation in other formats, and more. Install this package if you want to help with the PostgreSQL documentation project, or if you want to generate printed documentation. postgresql-jdbc : PostgreSQL is an advanced Object-Relational database management system. The postgresql-jdbc package includes the .jar file needed for Java programs to access a PostgreSQL database. postgresql-pl : PostgreSQL is an advanced Object-Relational database management system. The postgresql-pl package contains the the PL/Perl, PL/Tcl, and PL/Python procedural languages for the backend. PL/Pgsql is part of the core server package. postgresql-python : The postgresql-python package includes a module for developers to use when writing Python code for accessing a PostgreSQL database. postgresql-test : The postgresql-test package includes the sources and pre-built binaries of various tests for the PostgreSQL database management system, including regression tests and benchmarks. postgresql-server : The postgresql-server package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. You should install postgresql-server if you want to create and maintain your own PostgreSQL databases and/or your own PostgreSQL server. You also need to install the postgresql package. postgresql-tcl : The postgresql-tcl package contains the libpgtcl client library, the pg-enhanced pgtclsh, and the PL/Tcl procedural language for the backend. So... If you want to install a server, you have to install postgresql-libs, postgresql and postgresql-server packages, at minimum. Regards, - -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBipJntl86P3SPfQ4RAgWMAKDeh8KeR3SuWiVnpKh8zfZ5xXytgwCgptFH Vz9juQD3jScTYULCsS+oIic= =yjZ7 -----END PGP SIGNATURE-----
Pallav Kalva wrote: > How do i know which one is for installing the Postgres server and > what are the other packages for ? rpm -qpi packagefile -- Peter Eisentraut http://developer.postgresql.org/~petere/
Thanks! for all the quick replies, looks like it is better to install all the packages as our environment needs all of them. I was under the impression that (postgresql-7.4.6-2PGDG.i686.rpm or postgresql-server-7.4.6-2PGDG.i686.rpm ) one of these packages is the super set of all the packages and if I just install that package it would be fine, I guess i am wrong. I have to check out the Online backups option for the new Postgres 8.0 beta version too and I couldnt find any RPMS for this version yet in the ftp site, but there are tar files for this version postgresql-8.0.0beta4.tar.gz postgresql-base-8.0.0beta4.tar.gz postgresql-docs-8.0.0beta4.tar.gz postgresql-opt-8.0.0beta4.tar.gz postgresql-test-8.0.0beta4.tar.gz Do i need to install all these files or is the postgresql-8.0.0beta4.tar.gz superset of all the other files ? Thanks! again. Devrim GUNDUZ wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Hi, > > On Thu, 4 Nov 2004, Pallav Kalva wrote: > >> I am installing Postgres for the first time on my Linux machine , I >> found the following RPM packages for the RedHat 9 >> >> postgresql-7.4.6-2PGDG.i686.rpm >> postgresql-contrib-7.4.6-2PGDG.i686.rpm >> postgresql-devel-7.4.6-2PGDG.i686.rpm >> postgresql-docs-7.4.6-2PGDG.i686.rpm >> postgresql-jdbc-7.4.6-2PGDG.i686.rpm >> postgresql-libs-7.4.6-2PGDG.i686.rpm >> postgresql-pl-7.4.6-2PGDG.i686.rpm >> postgresql-python-7.4.6-2PGDG.i686.rpm >> postgresql-server-7.4.6-2PGDG.i686.rpm >> postgresql-tcl-7.4.6-2PGDG.i686.rpm postgresql-test-7.4.6-2PGDG.i686.rpm >> >> How do i know which one is for installing the Postgres server and >> what are the other packages for ? do i have to install all these >> packages too ? >> Can anyone please tell what these each packages are for ? > > > Here they are: > > postgresql : If you want to manipulate a PostgreSQL database on a > remote PostgreSQL server, you need this package. > > postgresql-libs : The postgresql-libs package provides the essential > shared libraries for any PostgreSQL client program or interface. You > will need to install this package to use any other PostgreSQL package > or any > clients that need to connect to a PostgreSQL server. > > postgresql-contrib : The postgresql-contrib package includes the > contrib tree distributed with the PostgreSQL tarball. Selected contrib > modules are prebuilt. > > postgresql-devel : The postgresql-devel package contains the header > files and libraries needed to compile C or C++ applications which will > directly interact with a PostgreSQL database management server and the > ecpg Embedded C Postgres preprocessor. You need to install this > package if you want to develop applications which will interact with a > PostgreSQL server. > > postgresql-docs : The postgresql-docs package includes the SGML source > for the documentation as well as the documentation in other formats, > and more. > Install this package if you want to help with the PostgreSQL > documentation project, or if you want to generate printed documentation. > > postgresql-jdbc : PostgreSQL is an advanced Object-Relational database > management system. The postgresql-jdbc package includes the .jar file > needed for Java programs to access a PostgreSQL database. > > postgresql-pl : PostgreSQL is an advanced Object-Relational database > management system. The postgresql-pl package contains the the > PL/Perl, PL/Tcl, and PL/Python procedural languages for the backend. > PL/Pgsql is part of the core server package. > > postgresql-python : The postgresql-python package includes a module > for developers to use when writing Python code for accessing a > PostgreSQL database. > > postgresql-test : The postgresql-test package includes the sources and > pre-built binaries of various tests for the PostgreSQL database > management > system, including regression tests and benchmarks. > > postgresql-server : The postgresql-server package includes the > programs needed to create and run a PostgreSQL server, which will in > turn allow you to create and maintain PostgreSQL databases. You should > install postgresql-server if you want to create and maintain your own > PostgreSQL databases and/or your own PostgreSQL server. You also need > to install the > postgresql package. > > postgresql-tcl : The postgresql-tcl package contains the libpgtcl client > library, the pg-enhanced pgtclsh, and the PL/Tcl procedural language > for the backend. > > > So... If you want to install a server, you have to install > postgresql-libs, postgresql and postgresql-server packages, at minimum. > > Regards, > > - -- > Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr > http://www.tdmsoft.com > http://www.gunduz.org > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQFBipJntl86P3SPfQ4RAgWMAKDeh8KeR3SuWiVnpKh8zfZ5xXytgwCgptFH > Vz9juQD3jScTYULCsS+oIic= > =yjZ7 > -----END PGP SIGNATURE----- >