Database Reference
In-Depth Information
CHAPTER 1
The Basics
In this chapter, we'll get you started with PostgreSQL. We begin by pointing you to
resources for downloading and installing it. Next we provide an overview of indispen‐
sable administration tools and review PostgreSQL nomenclature. At the time of writing,
PostgreSQL 9.4 is awaiting release, and we'll highlight some of the new features you'll
find in it. We close the chapter with resources to turn to when you need help.
Where to Get PostgreSQL
Years ago, if you wanted PostgreSQL, you had to compile it from source. Thankfully,
those days are long gone. Granted, you can still compile the source if you so choose, but
most users nowadays use packaged installers. A few clicks or keystrokes, and you're on
your way.
If you're installing PostgreSQL for the first time and have no existing database to up‐
grade, you should install the latest stable release version for your OS. The
downloads
page for the PostgreSQL Core Distribution
maintains a listing of places where you can
download PostgreSQL binaries for various OSes. In
Appendix A
, you'll find useful in‐
stallation instructions and links to additional custom distributions.
Administration Tools
There are four tools we commonly use to manage and use PostgreSQL: psql, pgAdmin,
phpPgAdmin, and Adminer. PostgreSQL core developers actively maintain the first
three; therefore, they tend to stay in sync with PostgreSQL releases. Adminer, while not
specific to PostgreSQL, is useful if you also need to manage other relational databases:
SQLite, MySQL, SQL Server, or Oracle. Beyond the four that we cover, you can find
plenty of other excellent administration tools, both open source and proprietary.
