Reliability and Availability |
|---|
| Features |
Benefits |
| Multi-Version Concurrency Control (MVCC) |
Supports heavy transaction loads in large multi-user environments and allows PostgreSQL to make a complete database backup while the database is live.
|
|
| Point-in-time Recovery |
Prevents irrevocable data loss by maintaining views of database tables and their data exactly as they were. |
|
| ACID compliant transactions (Atomicity, Consistency, Isolation, Durability) |
Guarantees that all of PostgreSQL database transactions are completed -- reliably and correctly.
|
|
| Transaction-safe Data Definition Language (DDL) |
Ensures that runtime database design tweaking does not interrupt production operation and is recoverable in the event of error. |
|
| Solaris Containers support |
Enables the independent management of system resources and access control to multiple PostgreSQL database environments within a single instance of the Solaris OS.
|
|
| Solaris Cluster support and the PostgreSQL HA Agent |
Ensure that PostgreSQL for Solaris and critical data remain available even in the event of disaster. |
|
| Solaris Service Manager integration |
Allows the Solaris Service Manager to use the PostgreSQL manifest to control its database service and isolate and recover from a PostgreSQL fault.
|
|
| Solaris Predictive Self Healing |
Automatically diagnoses, isolates, and provides recovery from a PostgreSQL fault in a live system. |
Security |
|---|
| Multiple Authentication Methods |
Support for Kerberos, PAM, IDENT, SSL or UNIX sockets for secure use authentication which is made even more secure by using Host-Based-Authentication.
|
|
| Support for ANSI ROLES and Permissions Model |
Specifies exact permissions for every table, view, function, trigger and schema in the PostgreSQL database.
|
|
| Cryptographic Capabilities |
Support for cryptographic and hash functions and data types, including SHA, Blowfish, 3DES, and PGP.
|
|
| Solaris Containers |
Virtually eliminate unauthorized access by running PostgreSQL for Solaris its own private, isolated environment.
|
|
| Solaris User and Process Rights Management |
Grant PostgreSQL users and applications only the minimum capabilities required to perform their duties.
|
|
| Solaris Trusted Extensions |
Control access to PostgreSQL data based on its sensitivity level.
|
Performance and Scalability |
|---|
| Solaris Dynamic Tracing (DTrace) Support |
PostgreSQL is the first database to incorporate customized DTrace probes within its core to troubleshoot performance bottlenecks, tune and optimize PostgreSQL in while in production for often dramatic performance improvements.
|
|
| Multi-Core Scaling |
PostgreSQL scales to 28 cores and is able to make full use of SunFire T2000s, SunFire AMD or Sun Intel multi-core machines for maximum performance from commodity-to-midrange servers.
|
|
| Solaris Symmetric Multiprocessing |
PostgreSQL can take advantage of the Solaris platform's Symmetric Multiprocessing to deliver near-linear scalability and performance in SMP environments.
|
Standards Support |
|---|
| SQL and Other Standards Support |
PostgreSQL supports most of the ANSI SQL92 specification and much of the advanced functionality introduced in SQL99 and SQL03. PostgreSQL supports all join and subquery types, and is capable of executing complex, 50-line queries. Stored procedures, schema, triggers, domains, and interval data are also supported.
|
|
| JDBC and ODBC Support |
PostgreSQL is certified for JDBC 3.0 and ODBC 3.0 standards.
|
Driver and Language Support |
|---|
| Driver and Language Support |
PostgreSQL for Solaris includes C and standards-compliant JDBC drivers. Drivers for ODBC, PHP, Perl, C++, Python, Ruby, .NET, and other languages are available from the PostgreSQL community.
|
