Why PostgreSQL - Command Prompt

cuttlefishblueData Management

Dec 16, 2012 (5 years and 21 days ago)

151 views

Why PostgreSQL
Command Prompt, Inc.
Why PostgreSQL and Command Prompt,
Inc.
The PostgreSQL Company
Since 1997
Command Prompt, Inc. is
The PostgreSQL Company
Overview

Command Prompt, Inc.

PostgreSQL License / Commercial Licenses

Support Options

PostgreSQL architecture

Backup and Recovery

Performance

Commercial Versions

Security

Supported languages

Management Tools and 3
rd
Party tools

Migration Tools

Closing
Command Prompt, Inc.

Operating since 1997, Incorporated in 2000

Profitable

Debt-Free

No outside investment

Only company dedicated to PostgreSQL environments

Participates and is respected by the community

Submits patches to core and manages a core project

90% of staff is of a technical nature

Sponsors community via external services

President is Editor-N-Chief of PostgreSQL

President is Co-Author of Pratical PostgreSQL from
O'Reilly Media
Commercial Versions
Mammoth PostgreSQL Replicator
100% pure PostgreSQL + Integrated Replication
Asynchronous replication
Synchronous replication available Fall '06
Starts at just 1000.00 for a master/slave installation
PostgreSQL Support

Around the Clock (24x7) support

http://www.commandprompt.com/support

Consulting Packages are also available
PostgreSQL Basics

Only popular Open Source ACID compliant database

Efficient process based, one process per connection

Operates on popular platforms: Linux, FreeBSD,
Solaris, MacOSX, Win32

Write Ahead Logging (WAL)

Multi-Version Concurrency Control (MVCC)

Point In Time Recovery (PITR)

Table Spaces

Triggers

Rules

Views

Custom Data Types, Domains, Constraints,
Aggregates

User Defined Functions/Procedures

Extensible API
Maintenance

Provides Online (HOT) Backup

Provides Point In Time Recovery

Replication available for fail-over backup

Autovacuum provides almost hands free maintenance

Table spaces allow for better segregation of data over
disk sets
Performance

Uses cursors for large dataset performance

Takes full advantage of 64 bit processors such as the
Opteron

Table spaces allow for larger tables to be places on
different disk sets

Predicate indexes allow for smaller indexes based on
specific parameters

Tree based indexes (ltree,rtree,gist) allow for specific
index requirements

Ability to write functions/procedures in C
PostgreSQL Security

Connection Security

By IP address

By Database Name

By User Name

Via SSL

Via Kerberos

Via Pluggable Authentication Modules (PAM)

Database Security

Via Access Control Lists (ACL)

User and Group level permissions

Use of View to permit select data for display

Via Rules

Permissions can be set on almost any database
object including functions, tables, and views.
Supported Languages

Server Side (procedural) Languages

Perl

Python

PHP

pgSQL

R

Ruby

Java

C

Plus others such as TCL

Client Side (user space) Languages

Includes all of the above procedural language

Also includes languages such as C#/.Net

Via ODBC/JDBC almost any language is supported.
Management Tools

Management Tools

pgAdmin3

http://www.pgadmin.org

EMS PostgreSQL Manager

http://www.sqlmanager.net

More Information

http://www.postgresql.org/download

3
rd
Party Tools

Any ODBC/JDBC compliant

Case Studio

Crystal Reports
http://www.postgresql.org/download/
Migration Issues

Easy to migrate to if existing database is Enterprise
Class:

Oracle

DB2

MSSQL

Tools exist for data migration and testing

DBI-Link

http://pgfoundry.org/projects/dbi-link/

Supports wide array of CSV capable formats for bulk
loading

pl/pgSQL

Similar to Oracle pl/pgSQL in styling and context for
ease of migration
In Closing
PostgreSQL can service most data needs. It is flexible and
extensible. Anything that can not be done can be developed
because of the Open Source Nature. There are no per CPU
fees, no excessive license costs and a plethora of installations
showing a long standing commitment by companies and the
community to deliver a quality product.
Command Prompt, Inc. because of its commitment to the

same goals can help you achieve any goal you may have
in mind for PostgreSQL.