Postgresql Promo Flyer

Post gr eSQL - English

Usage Examples

Further Information

Development system

PostgreSQL (2nd Edition), Korry Douglas, Sams Publishing, ISBN: 0672327562

A small system just for developing, running on any supported platform (Unix, Linux, Mac OS, Windows). This system does not need much system resources. The result can be exported and used in the production system. Small to mid-level database server A small to mid-level database server has just small hardware requirements. PostgreSQL is not running exclusive on this system but shares the resources with other services. A webserver (Blog, CMS) with a database backend is a good example.

PostgreSQL

Beginning Databases with PostgreSQL:From Novice to Professional, 2nd Edition, Neil Matthew, Apress, ISBN: 1590594789 Beginning PHP and PostgreSQL 8, W. Jason Gilmore, Apress, ISBN: 1590595475 PostgreSQL 8 for Windows, Richard Blum, McGraw-Hill Osborne Media, ISBN: 0071485627 PostgreSQL homepage: http://www.postgresql.org pgAdmin III: http://www.pgadmin.org PgFoundry: http://pgfoundry.org phpPgAdmin: http://phppgadmin.sourceforge.net

Large database server A large database server has extensive hardware requirements and is usually dedicated to a single application or project. PostgreSQL can use the full power of the hardware without the need to share resources.

PostGIS: http://postgis.refractions.net Slony: http://slony.info

PostgreSQL 8.3 PostgreSQL 8.3, released in early 2008, includes a record number of new and improved features which will greatly enhance PostgreSQL for application designers, database administrators, and users, with more than 280 patches by dozens of PostgreSQL contributors from 18 countries.

What is PostgreSQL?

Space for Advertising

Version 8.3 provides greater consistency of performance than previous versions, ensuring that every user can depend on the same high performance demonstrated in recent benchmarks for every transaction, whether in peak hours or not, seven days a week, 52 weeks per year. Major enhancements include: Heap Only Tuples (HOT) Spread checkpoints Automated self-tuning of the background writer Asynchronous commit option Synchronized Scans ANSI-standard SQL/XML support, incl. XML export Text search: Tsearch2 GSSAPI and SSPI authentication support New data types: UUIDs, ENUMs and arrays of composite types SNMP support © 2008 European PostgreSQL User Group (with help from the allBSD.de Project) – The images are copyright by the PostgreSQL project

PostgreSQL is an object-relational database management system (ORDBMS). It is freely available and usable without any licencing fee. PostgreSQL was originally developed at the University of California and uses the simple BSD licence. It is a very advanced database system in the open source area. PostgreSQL supports most parts of the SQL2003 standards and has a variety of its own extensions. Users can extend the system with self-defined data types, operators and functions. Apart from support for referential integrity and an advanced transaction management, PostgreSQL also offers definition of triggers and rules to control access to database objects.

Why Use PostgreSQL? Proprietary DBs are expensive with complex pricing structure - With no licencing costs PostgreSQL provides a viable alternative without sacrificing significant performance or features for a low-TCO, highly adaptable solution. Get features without the price tag: PostgreSQL provides ~80% of features and performance found in the leading proprietary databases. Scale as your business grows: PostgreSQL is highly scalable database known to scale up to 6TB of data ...with no extra licencing costs to move up to bigger servers. Avoid vendor lock in: our liberal BSD licence provides users freedom to do wide scale deployment. Get peace of mind: PostgreSQL delivers reliability & security so you never need to worry about losing your data or security breaches. Coupled with world class 24*7 support from several vendors & a highly active community delivers peace of mind unlike other open source databases.

Reliable 80% of commercial PostgreSQL users never need to phone for support because PostgreSQL is never down. Known for “unbreakable” reliability: “It is extremely common for companies to report that PostgreSQL has never crashed in several years of high activity operation. Not even once. It just works.” Highly standards compliant.

Secure by Default “By default, PostgreSQL is possibly the most securityaware database available ...” Database Hacker's Handbook: Defending Database Servers. PostgreSQL provides numerous authentication and logging options, and can utilize and extend OS-level security features like SELinux and Solaris Containers. The lowest bug count of any major database, according to reports issued by Coverity about PostgreSQL version 8.2.

Software for PostgreSQL Scalable

System software

SMP scalable to 32 cores, processing up to 25,000 transactions per second in some applications Easily handles data warehouses up to 6 terabytes Runs large, complex, 50-line decision support queries

Feature-rich Offers mature views, schema, triggers and other advanced SQL features. Stored procedures may be written in any of 12 different programming languages. Has unique database extensibility for domain-specific solutions like genetics, GIS and cryptography. Drivers available for all major programming languages.

Support Support is available from multiple vendors, including: Command Prompt, credativ, Cybertec, Dalibo, EnterpriseDB, Red Hat and Sun Microsystems. The PostgreSQL community is known for its rapid response to user questions and issues. The PostgreSQL Global Development Group is famous for its fast turnaround on bugs, making PostgreSQL among the most secure and stable database systems available: "We have normally had a fix within 24 hours. Frankly, the [PostgreSQL community mailing list] support has been amazing." Kevin Grittner, Wisconsin Court System, USA.

Technical Data Parameter

Value

Maximum size of database Unlimited Maximum size of table

32 Terabytes

Maximum size of row

400 Gigabytes

Maximum size of field

1 Gigabyte

Maximum number of rows Unlimited, the file system in DB is the limiting factor Maximum number of columns

250 to 1600, depending on the column type

Maximum size of indices in table

Unlimited

© 2008 European PostgreSQL User Group (with help from the allBSD.de Project) – The images are copyright by the PostgreSQL project

Slony (Replication) – Features: asynchronous mode, single master to multiple slaves, slaves can be cascaded, uses triggers, replication on table level, no exclusive locks necessary, can replicate schema changes, all tables require a primary keys, all nodes in the network need to be available at all times, cannot replicate large objects, no automatic failover. Administration pgAdmin: Graphical tool for administration that should fulfill nearly all wishes. It stands out with its ease-ofuse and clearly arranged display of the database structure. phpPgAdmin: A PHP-based web interface that can be used with the browser of any operating system. Client software for PostgreSQL ERP/CRM: Compiere, SQL-Ledger, TinyERP, Xtuples Connectivity: ODBC/JDBC-driver, Ruby-, Python, Perl- and Tcl-Bindings, C/C++-Libraries, Qt-Plugin, Npgsql.NET, PG Win32 Client (pgOleDB and psqlODBC), DBI-Link, Oralink, odbclink, Talend Stored Languages: pl/Ruby, pl/Python, pl/Perl, pl/Java, pl/PHP, pl/sh, pl/R, pl/scheme Groupware: OpenGroupware Office: OpenOffice, StarOffice CMS/Shop-Systems: LivingShop, XIST4C, Drupal, Alfresco, eZ Publish Image Software: gPictureBase, Gallery2 Blog Software: Serendipity, DotClear 2 Board Software: phpBB3 Wiki Software: Mediawiki Bugtracking/CRM: JIRA, Bugzilla Search: ht://miner, Tsearch2 Games: Poker Tracker, FlightGear Backup Software: Bacula Healthcare: GNUMed, OpenClinica Telephone: SIP Express Router