Database Reference
In-Depth Information
core server, but you can also retrieve popular add-ons. PostgreSQL developers maintain
this repository and release patches and updates as soon as they are available. At the time
of writing, PostgreSQL Yum repository is available for Fedora 14-20, Red Hat Enterprise
Linux 4-6, CentOS 4-6, and Scientific Linux 5-6. If you have older versions of the OS or
still need PostgreSQL 8.3, check the documentation to see what the repository still
maintains. For detailed installation instructions using YUM, refer to the
Yum section
of our PostgresOnLine journal site.
Debian, Ubuntu
Ubuntu stays up to date with latest versions of PostgreSQL. Debian tends to be a bit
slower. You can install the latest PostgreSQL with:
sudo apt-get install postgresql-9.3
If you plan to compile add-ons generally not packaged with PostgreSQL, such as PostGIS
or R, then you'll want to install the development libraries:
sudo apt-get install postgresql-server-dev-9.3
If your repository doesn't have the latest version of PostgreSQL, try visiting the
Apt
PostgreSQL packages
for the latest stable and beta releases. They also offer additional
packages such as PL/V8 and PostGIS. At last check, they have packages for Debian 6-7
and Ubuntu 10-14.
FreeBSD
FreeBSD is a popular platform for PostgreSQL. However, many people who use FreeBSD
tend to compile their own directly from source rather than using a packaged distribu‐
tion. You can find the latest beta versions of PostgreSQL at
FreeBSD
.
Mac OS X
We've seen a variety of ways to install PostgreSQL on Macs. EnterpriseDB offers an
installer. The Homebrew is gaining popularity and attracts advanced Mac users. Kyng‐
Chaos is suitable for folks looking for an up-to-date and complete open source GIS
experience. Postgres.app is a newcomer geared for the novice. The long-standing Mac‐
Ports and Fink distributions are still around. We do advise against mixing installers for
Mac users. For instance, if you installed PostgreSQL using KyngChaos, don't go to En‐
terpriseDB to get add-ons:
•
EnterpriseDB
maintains an easy-to-use, one-step installer for Mac OS X. PgAdmin
comes as part of the installer. For add-ons, EnterpriseDB offers a stack builder
program, from which you can install popular extensions, drivers, languages, and
administration tools.
