Description

Introduction to PostgreSQL

PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

Program Objectives

• Installing PostgreSQL
  • Compiling and Installing PostgreSQL on Linux/Unix
  • Post-Installation Setup
  • The PostgreSQL Windows Installer
• Creating a Database and Testing the Server
  • Initializing a Cluster
  • Creating a Database
  • Starting the Database Server
  • The psql Client
  • Startup Failures and Client Connection Problems