contributed to the communityThe No Compromise DatabasePostgreSQL for Solaris delivers the advancedcapabilities usually associated only withproprietary databases and all of the cost-ben-efits of open source. It combines the mostadvanced, stable, reliable, and trusted opensource database and operating system todeliver both business assurance and leadingprice price/performance. PostgreSQL for

Solaris is open source, integrated, andincluded—for free—with the Solaris OS.It has been performance-optimized andenhanced to take advantage of the advancedtechnologies available in the Solaris 10 OS,such as Solaris Service Manager, Solaris Con-

the risks and costs associated with down-time and lost data with capabilities that canmatch or even surpass proprietary databases.’

They include•Multi-Version Concurrency Control(MVCC)—Supports heavy transaction loadsin large multi-user environments andallows low-impact hot backup• Point-In-Time Recovery—Supports high-availability/failover configurations as wellas protection against administrator error•ACID compliant transactions—Guaranteesthat all of PostgreSQL database trans-actions are completed—reliably andcorrectly•Transaction-safe Data Definition Language(DDL)—Ensures that runtime databasedesign tweaking does not interrupt opera-tions and is recoverable in the event oferror•Solaris Containers—Enable the indepen-dent management of system resourcesand access control to multiple PostgreSQLdatabase environments within a singleinstance of the Solaris OS. For PostgreSQLusers, this feature can be used to limitresource usage, improve security andsystem utilization, among others.•Solaris Service Manager integration—Allows the Solaris Service Manager to

use the PostgreSQL manifest to control its

database service and restart it automati-cally if it’s terminated abnormally, abortedby software programming errors, or inter-

rupted by an underlying hardware problem.•Solaris Cluster support and the PostgreSQLHA Agent—Ensure that PostgreSQL forSolaris and critical data remain availableeven in the event of disaster.High Performance and Scalability UnderHeavy Loads“OmniTI selected PostgreSQL for Solaris toreplace a proprietary database on LinuxPostgreSQL for Solaris delivers great price/performance, advanced features, security,and unmatched reliability. It’s optimized to take advantage of Solaris OS proven

capabilities as an exceptional enterprise database platform, and like Solaris, itbenefits from years of use and development. PostgreSQL for Solaris is backed by Sun’s leadingglobal support organization and by one of the largest, most active open source communities

in existence.PostgreSQL for Solaris™The world’s most advanced open source

•DTrace Support—DTrace is a powerfuldiagnostic tool that can be used to observePostgreSQL even in production. By runningsome simple scripts, performance bottle-necks can be quickly identified. PostgreSQLis the first database with a set of DTraceprobes already in its core code, whichallows finer grained analysis of PostgreSQLperformance.•Multi-Core Scaling—PostgreSQL scaleslinearly to 28 cores and is able to make fulluse of SunFire T2000s, SunFire AMD or SunIntel multi-core machines for maximumperformance from commodity-to-midrangeservers.•Support for Large Complex Queries:

PostgreSQL can efficiently execute 50-linequeries with dozens of joins, subqueriesand computed expressions, making itthe best open source database for datawarehousing.•Compelling Benchmarks Using directlycomparable SpecJAppServer2004 results,PostgreSQL for Solaris has been shown

Database Hacker’s Handbook: DefendingDatabase Servers•Multiple Authentication Methods—Forsecure user authentication, PostgreSQLsupports Kerberos, IDENT, SSL or UNIX®sockets and secures them further by usinghost-based-authentication.• Support for ANSI ROLES and permissionsmodel—PostgreSQL specifies exact permis-sions for every table, view, function, triggerand schema in your database.•Cryptographic Capabilities—PostgreSQLsupports cryptographic and hash functionsand data types, including SHA, Blowfish,3DES, and PGP.Broad Standards and Driver SupportPostgreSQL is known for its high levels ofstandards-compliance and support for mostall programming languages and drivers.•SQL and Other Standards Support—PostgreSQL supports most of the ANSISQL92 specification and many pieces ofadvanced functionality introduced in SQL99and SQL03. PostgreSQL supports all joinand subquery types, as well as stored pro-cedures, schema, triggers, domains, andinterval data.•JDBC and ODBC Support—PostgreSQL is cer-tified for JDBC 3.0 and ODBC 3.0 standards.•Driver Support—PostgreSQL for Solarisincludes C and standards-compliant JDBCdrivers. Drivers for ODBC, PHP, Perl, C++,Python, Ruby, .NET, and other languagesare available from the PostgreSQLcommunity.Unparalleled SupportPostgreSQL for Solaris has two world-renowned support organizations backing it:Sun’s expert support team and the highlyactive and responsive PostgreSQL community.• Sun not only offers enterprise-class, 24x7,global support for PostgreSQL for Solaris,it also guarantees support for each releasefor six years. PostgreSQL for Solaris serviceplans are flexible and easily affordable.• The PostgreSQL community is known itsrapid response to user questions and issuesand the PostgreSQL Global DevelopmentGroup is famous for its fast turnaround onbugs.Compelling Cost BenefitsPostgreSQL for Solaris on Solaris offers excep-tional costs savings over other databases andother platforms.•No license fees Both PostgreSQL for Solarisand Solaris are absolutely free to use.•Cheaper than Linux PostgreSQL on Solarisis up to 25%—30% less expensive thancomparable Linux-based offerings.•Open source and extensible By virtue of itsopen source license and design, PostgreSQLfor Solaris is designed to be customized andextended.•Great price/performance