PostgreSQL is the default database on Mac OS X Server as of version 10.7. The standard version of Mac OS X includes only the PostgreSQL commandline client utilities.
Mac OS X Server 10.7 ships with PostgreSQL 9.0. Minor updates are provided by Apple, but not necessarily right after a new PostgreSQL minor release.
There are several other installers available for PostgreSQL on Mac OS X, which is the recommended way to install.
A one click installer is available for for Mac OS X that includes PostgreSQL, pgAdmin, PL/Java and the PL/pgSQL debugger plugin. The installer for PostgreSQL 8.3 and 8.4 supports Mac OS X 10.4 and above on Intel and PPC. For PostgreSQL 9.0 and later, Mac OS X 10.5 and above are supported for 32 and 64-bit Intel CPUs.
Download the installer from EnterpriseDB for all supported versions.
Postgres.app is a simple, native Mac OS X app that runs in the menubar without the need of an installer. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.
PostgreSQL packages are available for Mac OS X from the Fink Project. Please see the Fink documentation for information on how to install packages.
A list of PostgreSQL packages can be found using the package search tool on the Fink website.
PostgreSQL packages are also available for Mac OS X from the MacPorts Project. Please see the MacPorts documentation for information on how to install ports.
A list of PostgreSQL packages can be found using the portfiles search tool on the MacPorts website.