PostgreSQL

From Glitchdata
Jump to: navigation, search
ACTIVE TECHNOLOGY
Postgresql logo.jpg

This is a database server with a similar featureset to other enterprise platforms. It support for OSes like Linux, Windows, MacOS.

  • Reliability
    • ACID compliant
    • Transaction support
    • Savepoint support
    • Write ahead logging
    • Hot backup, point in time logging
  • Scalability
    • Table partitioning support
    • Tablespace support
  • Multi-version
  • Availability
    • Replication
  • Portability
    • Coded in ANSI C
    • Supports Windows, Linux, OSX, Solaris
  • Security

Postgres has matured with several supporting tools like:

  1. psql - command-line type client
  2. pgAdmin - multiplatform GUI type client
  3. phpPgAdmin - php-based webadmin tool.
  4. PostGIS - GIS capabilities for PostgreSQL.


Contents

Installation

Usage

Architecture

Here are some details on PostgreSQL Architecture


Performance

Getting more from the same database infrastructure. See Data System Performance

Training & Tutorials


Support

See PostgreSQL Support

Users

See where are the largest PostgreSQL Installations

Errors

Comparisons

Licensing

PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.


blog comments powered by Disqus