PostgreSQL Flyer - PgFoundry

hornbeastcalmΔιαχείριση Δεδομένων

27 Νοε 2012 (πριν από 4 χρόνια και 8 μήνες)

220 εμφανίσεις

Usage Examples
Development system
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 ex
-
clusive on this system but shares the resources with

other services. A webserver (Blog, CMS) with a data
-
base backend is a good example.
Large database server
A large database server has extensive hardware re
-
quirements and is usually dedicated to a single applic
-
ation or project. PostgreSQL can use the full power of

the hardware without the need to share resources.
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.
Version 8.3 provides greater consistency of performance

than previous versions, ensuring that every user can de
-
pend on the same high performance demonstrated in re
-
cent benchmarks for every transaction, whether in peak

hours or not, seven days a week, 52 weeks per year. Ma
-
jor 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 com
-
posite types
SNMP support
Further Information
PostgreSQL (2nd Edition),
Korry Douglas,

Sams Publishing, ISBN: 0672327562
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
PostGIS:

http://postgis.refractions.net
Slony:

http://slony.info
Space for Advertising

PostgreSQL



What is PostgreSQL?
PostgreSQL is an object-relational database management

system (ORDBMS). It is freely available and usable

without any licencing fee. PostgreSQL was originally de
-
veloped 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 referen
-
tial integrity and an advanced transaction management,

PostgreSQL also offers definition of triggers and rules to

control access to database objects.
© 2008 European PostgreSQL User Group (with help from the allBSD.de Project) – The images are copyright by the PostgreSQL project
Post greSQL - Engl ish
Why Use PostgreSQL?
Proprietary DBs are expensive with complex pricing

structure -
With no licencing costs PostgreSQL

provides a viable alternative without sacrificing signi
-
ficant 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 big
-
ger 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 opera
-
tion. Not even once. It just works.”
Highly standards compliant.
Secure by Default
“By default, PostgreSQL is possibly the most security-
aware 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, accord
-
ing to reports issued by Coverity about PostgreSQL

version 8.2.
Scalable
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 ad
-
vanced SQL features.
Stored procedures may be written in any of 12 differ
-
ent programming languages.
Has unique database extensibility for domain-specific

solutions like genetics, GIS and cryptography.
Drivers available for all major programming lan
-
guages.
Support
Support is available from multiple vendors, including:

Command Prompt, credativ, Cybertec, Dalibo, Enter
-
priseDB, Red Hat and Sun Microsystems.
The PostgreSQL community is known for its rapid

response to user questions and issues. The Postgr
-
eSQL 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, Wiscon
-
sin 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

in DB
Unlimited, the file system

is the limiting factor
Maximum number of

columns
250 to 1600, depending on

the column type
Maximum size of indices

in table
Unlimited
Software for PostgreSQL
System software
Slony (Replication)
– Features: asynchronous mode,

single master to multiple slaves, slaves can be cas
-
caded, uses triggers, replication on table level, no ex
-
clusive locks necessary, can replicate schema changes,

all tables require a primary keys, all nodes in the net
-
work need to be available at all times, cannot replicate

large objects, no automatic failover.
Administration
pgAdmin
: G
raphical tool for administration that should

fulfill nearly all wishes. It stands out with its ease-of-
use and clearly arranged display of the database struc
-
ture.
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 ps
-
qlODBC), 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, Al
-
fresco, 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
© 2008 European PostgreSQL User Group (with help from the allBSD.de Project) – The images are copyright by the PostgreSQL project