Postgres server installation and Configuration
Linux downloads (RedHat/CentOS/Fedora/Scientific)
Linux downloads (RedHat/CentOS/Fedora/Scientific)
PostgreSQL is available on these platforms by default. However,
each version of the platform normally "snapshots" a specific version of
PostgreSQL that is then supported throughout the lifetime of this platform.
Since this can often mean a different version than preferred, the PostgreSQL
project provides a repository of packages of all supported versions.
Should packages not be available for your distribution, or there are issues with your package manager, there are graphical installers available.
Finally, most Linux systems make it easy to build from source.
Which version of PostgreSQL you get will depend on the version of the distribution:
The repository contains many different packages including third party
addons. The most common and important packages are (substitute the
version number as required):
To use the yum repository, you must first install the repository RPM. To do this, download the correct RPM from the repository RPM listing, and install it with commands like:
Once this is done, you can proceed to install and update packages the same way as the ones included in the distribution.
Package names in the PostgreSQL yum repository follows the same standard as the ones included in the main repositories, but include the version number, such as:
Download the packages from OpenSCG for all supported versions.
Note: The cross distribution packages do not fully integrate with the platform-specific packaging systems.
Download the installer from EnterpriseDB for all supported versions.
Note: The installers do not integrate with platform-specific packaging systems.
Should packages not be available for your distribution, or there are issues with your package manager, there are graphical installers available.
Finally, most Linux systems make it easy to build from source.
Included in distribution
These distributions all include PostgreSQL by default. To install PostgreSQL from these repositories, use the yum command:
yum install postgresql
Which version of PostgreSQL you get will depend on the version of the distribution:
| Distribution | Version |
|---|---|
| RHEL/CentOS/SL 5 | 8.1 (also supplies package postgresql84) |
| RHEL/CentOS/SL 6 | 8.4 |
| Fedora 16, 17 | 9.1 |
| Fedora 18 | 9.2 |
- postgresql - client libraries and client binaries
- postgresql-server - core database server
- postgresql-contrib - additional supplied modules
- postgresql-devel - libraries and headers for C language development
- pgadmin3 - pgAdmin III graphical administration utility
Post-installation
Due to policies for RedHat style distributions, the PostgreSQL installation will not be enabled for automatic start or have the database initialized automatically. To make your database installation complete, you need to perform these two steps:
service postgresql initdb
chkconfig postgresql on
or, on Fedora 19 and other later derived distributions:
postgresql-setup initdb
chkconfig postgresql on
PostgreSQL Yum Repository
If the version supplied by your operating system is not the one you want, you can use the PostgreSQL Yum Repository. This repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL.To use the yum repository, you must first install the repository RPM. To do this, download the correct RPM from the repository RPM listing, and install it with commands like:
rpm -i http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
Once this is done, you can proceed to install and update packages the same way as the ones included in the distribution.
yum install postgresql92-server postgresql92-contrib
service postgresql-9.2 initdb
chkconfig postgresql-9.2 on
Package names in the PostgreSQL yum repository follows the same standard as the ones included in the main repositories, but include the version number, such as:
- postgresql92
- postgresql92-server
- postgresql92-contrib
- pgadmin3_92
Direct RPM download
If you cannot, or do not want to, use the yum based installation method, all the RPMs that are in the yum repository are available for direct download and manual installation as well.Cross distribution packages
Generic RPM and DEB packages that provide a server-only distibution are avaliable for some 32 and 64-bit Linux distributions. These packages provide a single set of binaries and consistent packaging across different Linux distributions. They are designed for server installation where a GUI is not available and consistency across multiple distributions is a requirement.Download the packages from OpenSCG for all supported versions.
Note: The cross distribution packages do not fully integrate with the platform-specific packaging systems.
Graphical installer
Installers are available for 32 and 64 bit Linux distributions and include PostgreSQL, pgAdmin and the StackBuilder utility for installation of additional packages. The PostgreSQL 8.4 installers have been tested with a number of Linux distributions and should work on Ubuntu 6.06 and above, Fedora 6 and above, CentOS/RedHat Enterprise Linux 4 and above and others. The 9.0 and later installers have only been tested on more recent distributions.Download the installer from EnterpriseDB for all supported versions.
Note: The installers do not integrate with platform-specific packaging systems.
No comments:
Post a Comment