PostgreSQL is a powerful, open source relational database management system and the foundation of the Postgres Plus product suite. It has been in development for more than 20 years and has a strong reputation for excellent architecture and world-class reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX, and Windows. It is fully ACID-compliant and supports foreign keys, joins, views, triggers, stored procedures (in multiple languages), and most SQL92 and SQL99 data types. It also supports storage of binary large objects, including pictures, sounds, and video. PostgreSQL includes native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, and others, and it is exceptionally well-documented.

An enterprise-class database, PostgreSQL boasts sophisticated features, such as Multi-Version Concurrency Control (MVCC), point-in-time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write-ahead logging for fault tolerance. It supports international character sets, multi-byte character encodings, and Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable, both in the quantity of data it can manage and in the number of concurrent users it can accommodate. For more information about PostgreSQL visit www.postgresql.org.

Documentation for PostgreSQL is available at: http://www.enterprisedb.com/products-services-training/products/document...

PostgreSQL use is governed by the PostgreSQL License.

It is the foundation for Postgres Studio and bundled with Postgres Plus. The application may be used on Linux, FreeBSD, OpenSUSE, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform.

pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.

pgAdmin is developed by Dave Page, an EnterpriseDB employee and PostgreSQL core team member, along with a community of PostgreSQL experts around the world. It is available in more than a dozen languages and is Free Software released under the Artistic License.

pgAdmin is packaged and installed as part of the Postgres One-click installer and is the foundation for Postgres Enterprise Manager included with Postgres Plus Advanced Server.

The pgAdmin project is located at: http://www.pgadmin.org/.

Documentation for pgAdmin is available at: www.enterprisedb.com/products-services-training/products/documentation

pgAdmin use is governed by the PostgreSQL License.

PostGIS adds support for geographic objects to the PostgreSQL object-relational database and is included in the Postgres Plus product suite. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.

PostGIS has been developed by Refractions Research as a project in open source spatial database technology. PostGIS is released under the GNU General Public License. Refractions Research continues to develop PostGIS, and have added user interface tools, basic topology support, data validation, coordinate transformation, programming APIs and much more. Their list of future projects includes full topology support, raster support, networks and routing, three-dimensional surfaces, curves and splines, and other features.

PostGIS is packaged as part of StackBuilder and StackBuilder Plus included with the PostgreSQL One-click installer and Plus and Postgres Plus Advanced Server.

The PostGIS project can be found at: http://postgis.refractions.net.

Documentation for PostGIS is available at: http://postgis.refractions.net/documentation/

PostGIS use is governed by the GPL.

The driver provides a reasonably complete implementation of the JDBC 3 specification in addition to some PostgreSQL specific extensions.

pgJDBC is packaged as part of StackBuilder in the PostgreSQL One-click installer. Advanced Server uses an enhanced version of this driver.

The pgJDBC project can be found at http://jdbc.postgresql.org/.

Postgres Plus Documentation:

• Extensive documentation is available at: http://jdbc.postgresql.org/documentation/docs.html
• The pgJDBC Public API documentation http://jdbc.postgresql.org/documentation/publicapi/index.html

Postgres Plus Advanced Server Documentation:

• Documentation for the Advanced Server Postgres JDBC version of the driver is available at: http://www.enterprisedb.com/learning/documentation .

pgJDBC use is governed by the BSD License.

psqlODBC is packaged as part of StackBuilder included with the PostgreSQL One-click installer. Advanced Server uses an enhanced version of this driver.

The psqlODBC project can be found at http://psqlodbc.projects.postgresql.org/.

Postgres Plus Documentation:

• Configuration documentation is available at: http://psqlodbc.projects.postgresql.org/config.html
• psqlDBCHow To Examples are located at: http://psqlodbc.projects.postgresql.org/

Postgres Plus Advanced Server Documentation:

• Documentation for the Advanced Server version of this driver is under development.

psqlODBC use is governed by the LGPL.

Npgsql allows a .NET client application (Console, WinForms, ASP.NET, Web Services...) to send and receive data with a PostgreSQL server. It is actively developed based on the guidelines specified in the .NET documentation. It is implemented in 100% C# code and works with PostgreSQL 7.x and 8.x.

Npgsql is packaged as part of StackBuilder included in the PostgreSQL One-click installer. Advanced Server uses an enhanced version of this driver.

The Npgsql project can be found at http://pgfoundry.org/projects/npgsql/.

Postgres Plus Documentation:

• Extensive user documentation with usage examples is available at: http://npgsql.projects.postgresql.org/docs/manual/UserManual.html
• The Npgsql API documentation is located at: http://npgsql.projects.postgresql.org/docs/api/

Postgres Plus Advanced Server Documentation:

• Documentation for the Advanced Server version of this driver is under development.

Npgsql use is governed by the BSD License.

ECPG is allows you to embed SQL in C programs. It is similar to support provided by other commercial databases. ECPG ships as part of the PostgreSQL distribution.

ECPG is packaged as part of StackBuilder included in the PostgreSQL One-click installer. Advanced Server uses an enhanced version of this driver.

The project can be found at http://pgfoundry.org.

Postgres Plus Documentation:

• documentation is available at: http://www.postgresql.org/docs/

Postgres Plus Advanced Server Documentation:

• Documentation for the Advanced Server version of this driver is under development.

Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will create a connection to the actual server, or it will reuse one of its existing connections. In order not to compromise transaction semantics for connection pooling, pgbouncer supports several types of pooling when rotating connections: Session pooling, Transaction pooling, and Statement pooling.

PgBouncer is packaged as part of StackBuilder and included in the PostgreSQL One-click installer and Postgres Plus Advanced Server.

The PgBouncer project can be found at:http://pgfoundry.org/projects/pgbouncer/.

Documentation:

• Documentation for PgBouncer is available at: http://pgbouncer.projects.postgresql.org/doc/
• User documentation for starting PgBouncer, command line switches, the Admin console, and process control commands is available at: http://pgbouncer.projects.postgresql.org/doc/usage.html
• A PostgreSQL feature map for the pooling modes is available at: https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer

PgBouncer use is governed by the BSD License.

pgAgent runs as a daemon on *nix systems, and a service on Windows systems. In the majority of cases it will run on the database server itself - it is for this reason that pgAgent is not automatically setup when pgAdmin is installed. In some cases however, it may be preferable to run pgAgent on multiple systems, against the same database - individual jobs may be targeted at a particular host, or left for execution by any host. Locking prevents execution of the same instance of a job by multiple hosts.

pgAgent is packaged as part of StackBuilder included with the PostgreSQL One-click installer and Postgres Plus Advanced Server.

pgAgent is part of the pgAdmin project and can be found at: http://www.pgadmin.org/ .

Documentation for pgAgent is available at: http://www.pgadmin.org/docs/1.4/pgagent.html

pgAgent use is governed by the PostgreSQL License.

Slony-I is a "master to multiple slaves" replication system supporting cascading (e.g. - a node can feed another node which feeds another node...) and failover for PostgresSQL. Slony replication is installed as part of Postgres Plus Advanced Server.

The big picture for the development of Slony-I is that it is a master-slave replication system that includes all features and capabilities needed to replicate large databases to a reasonably limited number of slave systems.

Slony-I is a system designed for use at data centers and backup sites, where the normal mode of operation is that all nodes are available.

The main Slony-I project can be found at: http://www.slony.info

Documentation:

• Comprehensive documentation is available at: http://www.slony.info/documentation/
• A fairly extensive admin guide comprising material in the CVS tree may be found at http://linuxdatabases.info/info/slony.html
• The original design document is available at: http://developer.postgresql.org/%7Ewieck/slony1/Slony-I-concept.pdf

Slony-I use is governed by the PostgreSQL License.

memcached is very fast and useful for high-traffic web sites that are dynamically generated and put a heavy load on the database. It is especially useful for loads that contain mostly read operations.

pgmemcache is packaged as part of StackBuilder included in the PostgreSQL One-click installer and you must acquire memcached from the link below. Postgres Plus Advanced Server uses Infinite Cache which is derived from memcached.

The memcached project can be found at: http://www.danga.com/memcached/

Documentation:

• pgmemcache documentation is available at: http://pgfoundry.org/projects/pgmemcache/ (download the archive and view the file: README.pgmemcache).
• memcached documentation is available at: http://code.google.com/p/memcached/wiki/Start

pgmemcache use is governed by the MIT License.

StackBuilder is distributed on multiple platforms and open to the Postgres community. Example StackBuilder modules include various database drivers, specialized tools and utilities, replication solutions, web application stacks, web development stacks, and more. Installation modules may be contributed and distributed freely through StackBuilder by interested 3rd parties. To learn more about distributing your module, please contact: Dave Page (dpage@postgresql.org).

StackBuilder is available as part of a professionally packaged community version of PostgreSQL distributed by EnterpriseDB.

The StackBuilder project can be found at:http://pgfoundry.org/ projects/stackbuilder/

StackBuilder use is governed by the BSD License.