!http://www.sun.com/images/l0/l0_postgresql-solaris_nocta.jpg!
h1. Table of Contents
h2. History
* PostgreSQL History
* [PostgreSQL on Solaris History|DBonSolaris:PGSolHistory]
h2. FAQ
* [PostgreSQL on Solaris FAQ |http://www.sun.com/software/products/postgresql/faqs.jsp]
h2. Appliances
* [PostgreSQL 8.3 Appliance|DBonSolaris.PG83Appliance]
h2. [Introduction to PostgreSQL on Solaris|DBonSolaris.PGSolIntro]
* [Different versions available on Solaris|DBonSolaris.PGSolIntro#Versions]
* [Solaris Role Based Access Control - postgres|DBonSolaris.PGSolIntro#PGSolRBAC]
* [PostgreSQL and SMF|DBonSolaris.PGSolIntro#PGSolSMF]
* [Clients of PostgreSQL on Solaris|DBonSolaris.PGSolIntro#PGSolClients]
h2. [Planning Deployment of PostgreSQL on Solaris|DBonSolaris.PGSolPlanning]
* [Performance Planning for Deployment|DBonSolaris.PGSolPlanning#Performance]
** Disk layout considerations
** Response time Vs Throughput
* [Virtualization Planning for Deployment|DBonSolaris.PGSolPlanning#Virtualization]
** [Zones|DBonSolaris.PGSolVirtualization#Zones]
** [LDoms|DBonSolaris.PGSolVirtualization#LDoms]
** [Solaris xVM|DBonSolaris.PGSolVirtualization#xvm]
* [High Availability Planning for Deployment|DBonSolaris.PGSolPlanning#HA]
** [Warm Standby|DBonSolaris.PGSolHA#warm]
** [Sun Cluster HA for PostgreSQL|DBonSolaris.PGSolHA#suncluster]
* [Scalability Planning for Deployment|DBonSolaris.PGSolPlanning#Scalability]
** Replication
** Table Partition
* Upgrade Planning for Deployment
** Current Practice for Upgrade
* Other Considerations
** ZFS
h2. [Administering PostgreSQL on Solaris|DBonSolaris.PGSolAdmin]
* [Upgrading From Older Version Of PostgreSQL|DBonSolaris.PGSolAdmin#old2new]
* [Managing PostgreSQL Services on Solaris|DBonSolaris.PGSolAdmin#pgservices]
** [PostgreSQL and SMF integration|DBonSolaris.PGSolAdmin#pgandsmf]
** [Running/Configuring PostgreSQL using SMF Commands|DBonSolaris.PGSolAdmin#managesmf]
** [Running PostgreSQL in Solaris Containers|DBonSolaris.PGSolAdmin#pginzones]
* [Populating/Migrating Data to PostgreSQL on Solaris|DBonSolaris.PGSolMigrate]
** [Loading Data in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolLoad]
** [Creating/Migrating Stored Procedures/Functions in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolMigSP]
** [Creating Triggers in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolMigTrig]
* [Backup and Restore with PostgreSQL on Solaris|DBonSolaris.PGSolBackup]
** [pg_dump and pg_restore|DBonSolaris.PGSolBackup#PGSolDump]
** [ZFS Snapshot/Clone|DBonSolaris.PGSolBackup#PGSolSnapshot]
** [Hot Backup with ZFS Snapshot/Clone with PITR|DBonSolaris.PGSolBackup#PGSolPITR]
h2. High Availability, Replication, Warm Standby for PostgreSQL on Solaris
* [Sun Cluster and PostgreSQL |DBonSolaris:PGSolCluster]
* [slony and PostgreSQL |DBonSolaris:PGSolSlony]
* [pgBouncer and PostgreSQL |DBonSolaris:PGSolpgBouncer]
h2. [Demos and Examples of PostgreSQL on Solaris|DBonSolaris.PGSolExamples]
* [Example of very simple PostgreSQL Cluster setup|DBonSolaris.PGSolExamples#SimpleSetup]
* [Example of PostgreSQL Cluster setup in Solaris Zones|DBonSolaris.PGSolExamples#ClusterSetup]
* [Example of a Complex Well Performing with Replication/Warm Standby with HA Setup|DBonSolaris.PGSolExamples#PITRSetup]
h2. [Developing Applications with PostgreSQL on Solaris|DBonSolaris.PGSolDevelop]
* [Using PostgreSQL with Scripting Languages|DBonSolaris.PGSolDevelop]
** [PHP|DBonSolaris.PGSolDevelop#php]
** [Ruby|DBonSolaris.PGSolDevelop#ruby]
** [Python|DBonSolaris.PGSolDevelop#python]
** [Perl|DBonSolaris.PGSolDevelop#perl]
** [PL/pgSQL|DBonSolaris.PGSolDevelop#pgsql]
* [Using PostgreSQL with Java (JDBC driver)|DBonSolaris.PGSolDevelop#Java]
* [Using PostgreSQL with C/C+\+|DBonSolaris.PGSolDevelop#Native]
* [Using Netbeans as IDE with PostgreSQL|DBonSolaris.PGSolDevelop#Netbeans]
** Supported Versions
** DB Navigation
** Wizard Based Import/Export
* [Using Glassfish as Application Server with PostgreSQL|DBonSolaris.PGSolGlassfish]
** [Create PostgreSQL Resource Pool|DBonSolaris.PGSolGlassfish]
** [Create JDBC Resource|DBonSolaris.PGSolGlassfish]
*** [Using PostgreSQL JDBC Role - An Example BPEL Process|DBonSolaris.PGSolGlassfish]
h2. JDBC
* Bundled in Solaris 10 8/07 /usr/postgres/8.2/jdbc/postgresql.jar
* [PostgreSQL JDBC Driver|http://jdbc.postgresql.org]
* [Statement Caching Driver Wrapper for PostgreSQL JDBC|http://pgfoundry.org/projects/jdbccache]
h2. [Developing Appliances with PostgreSQL on Solaris|DBonSolaris.PGSolAppliances]
* [Creating appliances with PostgreSQL using OpenSolaris framework|DBonSolaris.PGSolAppliances]
* [End User Appliances with PostgreSQL database on OpenSolaris|DBonSolaris.PGSolAppliances]
h2. [Tuning PostgreSQL on Solaris|DBonSolaris.PGSolTuning]
* [PostgreSQL server Tuning (postgresql.conf)|DBonSolaris.PGSolTuning]
* [Filesystem Tuning|DBonSolaris.PGSolTuning#FileSystems]
** [ZFS|DBonSolaris.PGSolFileSystems#ZFS]
** [UFS|DBonSolaris.PGSolFileSystems#UFS]
** [QFS|DBonSolaris.PGSolFileSystems#QFS]
h2. [DTrace and PostgreSQL]
* [DTrace and PostgreSQL |DBonSolaris:PGSolDTrace]
* [PostgreSQL DTrace Users Guide |http://pgfoundry.org/docman/view.php/1000163/230/PostgreSQL-DTrace-Users-Guide.pdf]
h2. [Zones|DBonSolaris:PGSolZones]
* [Zones and PostgreSQL |DBonSolaris:PGSolZones]
* [PostgreSQL in Solaris 10 Zones |http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl2?a=view]
h2. [Sun Cluster & Open Cluster|DBonSolaris:PGSolCluster]
* [Sun Cluster and PostgreSQL |DBonSolaris:PGSolCluster]
* [Sun Cluster Data Services for PostgreSQL |http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl2?a=view]
h2. [Performance Monitoring PostgreSQL on Solaris|DBonSolaris.PGSolMonitor]
* [What to Monitor?|DBonSolaris.PGSolMonitor#What]
* [Using PostgreSQL System Tables and view|DBonSolaris.PGSolMonitor#pgstat]
* [Using Solaris tools|DBonSolaris.PGSolMonitor#solaris]
** Using prstat with pargs to figure out session problems
** Using iostat to figure out hot disks
* [Using DTrace Probes|DBonSolaris.PGSolDTrace]
** User-Level Statically Defined DTrace Probes in PostgreSQL
*** LWLock Probes
*** Transaction Probes
** Other Useful DTrace scripts for PostgreSQL
* [Using Sun Studio Performance Analyzer|DBonSolaris.PGSolAnalyzer]
* Problem Determination
h2. Performance Tuning and Recommend Layouts
* [Peformance Tunings for PostgreSQL on Solaris |DBonSolaris:PGSolTuning]
* [PostgreSQL Tuning from SolarisInternals|http://www.solarisinternals.com/wiki/index.php/Application_Specific_Tuning#PostgreSQL]
h2. Recommended Layouts/Best Practices
* [Recommended Layouts for PostgreSQL on Solaris |DBonSolaris:PGSolBestPractices]
h2. [Benchmarks and Workloads with PostgreSQL|DBonSolaris.PGSolBenchmarks]
* [EAStress|DBonSolaris.PGSolBenchmarks#EAStress]
* [TPC-E|DBonSolaris.PGSolBenchmarks#TPCE]
* [TPC-H|DBonSolaris.PGSolBenchmarks#TPCH]
* [SysBench|DBonSolaris.PGSolBenchmarks#SysBench]
h2. Published Benchmarks
* [SpecJAppServer2004 benchmarks using PostgreSQL on Solaris |DBonSolaris:PGSpecJ]
h2. [Bottlenecks Possible with PostgreSQL|DBonSolaris.PGSolBottlenecks]
* [ProcArray Structure |DBonSolaris.PGSolBottlenecks#PGSolProcArray]
* [CLOG Buffers |DBonSolaris.PGSolBottlenecks#PGSolCLog]
* [WALWriteLock |DBonSolaris.PGSolBottlenecks#PGSolWALWriteLock]
* [WALInsertLock |DBonSolaris.PGSolBottlenecks#PGSolWALInsertLock]
h2. [Other tasks with PostgreSQL on Solaris|DBonSolaris.PGSolMisc]
h2. References
* PostgreSQL.org Documentation
* docs.sun.com Documentation
h2. [Glossary|DBonSolaris.PGSolDocGlossary]
h2. [Index|DBonSolaris.PGSolDocIndex]
h2. Articles
* [PostgreSQL in OpenSolaris |http://www.sun.com/bigadmin/features/articles/postgresql_opensolaris.jsp] \- Zdenek Kotala, July 2007
h2. Blog Entries
* [PostgreSQL 8.3beta1 on Solaris|http://blogs.sun.com/jkshah/entry/postgresql_8_3beta_testing_on]
h2. Blogs on PostgreSQL
* Josh Berkus: [http://blogs.ittoolbox.com/database/soup]
* Jignesh Shah: [http://blogs.sun.com/jkshah]
* Tom Daly: [http://blogs.sun.com/tomdaly]
* Robert Lor: [http://blogs.sun.com/robertlor/]
* Glenn Fawcett: [http://blogs.sun.com/glennf/category/Postgres]
h2. PostgreSQL for Solaris
* [http://sun.com/postgresql]
* [PostgreSQL on Solaris|http://www.sun.com/software/products/postgresql/index.jsp]
* [Building your own PostgreSQL|BuildingPostgreSQL]
h2. PostgreSQL:
* [http://www.postgresql.org]
h2. OpenSolaris databases community
* [http://www.opensolaris.org/os/community/databases/]
h2. Ask Questions on OpenSolaris Database Forum
* [http://www.opensolaris.org/jive/forum.jspa?forumID=175]
h2. Feedback
* postgresql-feedback@sun.com
h1. Table of Contents
h2. History
* PostgreSQL History
* [PostgreSQL on Solaris History|DBonSolaris:PGSolHistory]
h2. FAQ
* [PostgreSQL on Solaris FAQ |http://www.sun.com/software/products/postgresql/faqs.jsp]
h2. Appliances
* [PostgreSQL 8.3 Appliance|DBonSolaris.PG83Appliance]
h2. [Introduction to PostgreSQL on Solaris|DBonSolaris.PGSolIntro]
* [Different versions available on Solaris|DBonSolaris.PGSolIntro#Versions]
* [Solaris Role Based Access Control - postgres|DBonSolaris.PGSolIntro#PGSolRBAC]
* [PostgreSQL and SMF|DBonSolaris.PGSolIntro#PGSolSMF]
* [Clients of PostgreSQL on Solaris|DBonSolaris.PGSolIntro#PGSolClients]
h2. [Planning Deployment of PostgreSQL on Solaris|DBonSolaris.PGSolPlanning]
* [Performance Planning for Deployment|DBonSolaris.PGSolPlanning#Performance]
** Disk layout considerations
** Response time Vs Throughput
* [Virtualization Planning for Deployment|DBonSolaris.PGSolPlanning#Virtualization]
** [Zones|DBonSolaris.PGSolVirtualization#Zones]
** [LDoms|DBonSolaris.PGSolVirtualization#LDoms]
** [Solaris xVM|DBonSolaris.PGSolVirtualization#xvm]
* [High Availability Planning for Deployment|DBonSolaris.PGSolPlanning#HA]
** [Warm Standby|DBonSolaris.PGSolHA#warm]
** [Sun Cluster HA for PostgreSQL|DBonSolaris.PGSolHA#suncluster]
* [Scalability Planning for Deployment|DBonSolaris.PGSolPlanning#Scalability]
** Replication
** Table Partition
* Upgrade Planning for Deployment
** Current Practice for Upgrade
* Other Considerations
** ZFS
h2. [Administering PostgreSQL on Solaris|DBonSolaris.PGSolAdmin]
* [Upgrading From Older Version Of PostgreSQL|DBonSolaris.PGSolAdmin#old2new]
* [Managing PostgreSQL Services on Solaris|DBonSolaris.PGSolAdmin#pgservices]
** [PostgreSQL and SMF integration|DBonSolaris.PGSolAdmin#pgandsmf]
** [Running/Configuring PostgreSQL using SMF Commands|DBonSolaris.PGSolAdmin#managesmf]
** [Running PostgreSQL in Solaris Containers|DBonSolaris.PGSolAdmin#pginzones]
* [Populating/Migrating Data to PostgreSQL on Solaris|DBonSolaris.PGSolMigrate]
** [Loading Data in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolLoad]
** [Creating/Migrating Stored Procedures/Functions in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolMigSP]
** [Creating Triggers in PostgreSQL on Solaris|DBonSolaris.PGSolMigrate#PGSolMigTrig]
* [Backup and Restore with PostgreSQL on Solaris|DBonSolaris.PGSolBackup]
** [pg_dump and pg_restore|DBonSolaris.PGSolBackup#PGSolDump]
** [ZFS Snapshot/Clone|DBonSolaris.PGSolBackup#PGSolSnapshot]
** [Hot Backup with ZFS Snapshot/Clone with PITR|DBonSolaris.PGSolBackup#PGSolPITR]
h2. High Availability, Replication, Warm Standby for PostgreSQL on Solaris
* [Sun Cluster and PostgreSQL |DBonSolaris:PGSolCluster]
* [slony and PostgreSQL |DBonSolaris:PGSolSlony]
* [pgBouncer and PostgreSQL |DBonSolaris:PGSolpgBouncer]
h2. [Demos and Examples of PostgreSQL on Solaris|DBonSolaris.PGSolExamples]
* [Example of very simple PostgreSQL Cluster setup|DBonSolaris.PGSolExamples#SimpleSetup]
* [Example of PostgreSQL Cluster setup in Solaris Zones|DBonSolaris.PGSolExamples#ClusterSetup]
* [Example of a Complex Well Performing with Replication/Warm Standby with HA Setup|DBonSolaris.PGSolExamples#PITRSetup]
h2. [Developing Applications with PostgreSQL on Solaris|DBonSolaris.PGSolDevelop]
* [Using PostgreSQL with Scripting Languages|DBonSolaris.PGSolDevelop]
** [PHP|DBonSolaris.PGSolDevelop#php]
** [Ruby|DBonSolaris.PGSolDevelop#ruby]
** [Python|DBonSolaris.PGSolDevelop#python]
** [Perl|DBonSolaris.PGSolDevelop#perl]
** [PL/pgSQL|DBonSolaris.PGSolDevelop#pgsql]
* [Using PostgreSQL with Java (JDBC driver)|DBonSolaris.PGSolDevelop#Java]
* [Using PostgreSQL with C/C+\+|DBonSolaris.PGSolDevelop#Native]
* [Using Netbeans as IDE with PostgreSQL|DBonSolaris.PGSolDevelop#Netbeans]
** Supported Versions
** DB Navigation
** Wizard Based Import/Export
* [Using Glassfish as Application Server with PostgreSQL|DBonSolaris.PGSolGlassfish]
** [Create PostgreSQL Resource Pool|DBonSolaris.PGSolGlassfish]
** [Create JDBC Resource|DBonSolaris.PGSolGlassfish]
*** [Using PostgreSQL JDBC Role - An Example BPEL Process|DBonSolaris.PGSolGlassfish]
h2. JDBC
* Bundled in Solaris 10 8/07 /usr/postgres/8.2/jdbc/postgresql.jar
* [PostgreSQL JDBC Driver|http://jdbc.postgresql.org]
* [Statement Caching Driver Wrapper for PostgreSQL JDBC|http://pgfoundry.org/projects/jdbccache]
h2. [Developing Appliances with PostgreSQL on Solaris|DBonSolaris.PGSolAppliances]
* [Creating appliances with PostgreSQL using OpenSolaris framework|DBonSolaris.PGSolAppliances]
* [End User Appliances with PostgreSQL database on OpenSolaris|DBonSolaris.PGSolAppliances]
h2. [Tuning PostgreSQL on Solaris|DBonSolaris.PGSolTuning]
* [PostgreSQL server Tuning (postgresql.conf)|DBonSolaris.PGSolTuning]
* [Filesystem Tuning|DBonSolaris.PGSolTuning#FileSystems]
** [ZFS|DBonSolaris.PGSolFileSystems#ZFS]
** [UFS|DBonSolaris.PGSolFileSystems#UFS]
** [QFS|DBonSolaris.PGSolFileSystems#QFS]
h2. [DTrace and PostgreSQL]
* [DTrace and PostgreSQL |DBonSolaris:PGSolDTrace]
* [PostgreSQL DTrace Users Guide |http://pgfoundry.org/docman/view.php/1000163/230/PostgreSQL-DTrace-Users-Guide.pdf]
h2. [Zones|DBonSolaris:PGSolZones]
* [Zones and PostgreSQL |DBonSolaris:PGSolZones]
* [PostgreSQL in Solaris 10 Zones |http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl2?a=view]
h2. [Sun Cluster & Open Cluster|DBonSolaris:PGSolCluster]
* [Sun Cluster and PostgreSQL |DBonSolaris:PGSolCluster]
* [Sun Cluster Data Services for PostgreSQL |http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl2?a=view]
h2. [Performance Monitoring PostgreSQL on Solaris|DBonSolaris.PGSolMonitor]
* [What to Monitor?|DBonSolaris.PGSolMonitor#What]
* [Using PostgreSQL System Tables and view|DBonSolaris.PGSolMonitor#pgstat]
* [Using Solaris tools|DBonSolaris.PGSolMonitor#solaris]
** Using prstat with pargs to figure out session problems
** Using iostat to figure out hot disks
* [Using DTrace Probes|DBonSolaris.PGSolDTrace]
** User-Level Statically Defined DTrace Probes in PostgreSQL
*** LWLock Probes
*** Transaction Probes
** Other Useful DTrace scripts for PostgreSQL
* [Using Sun Studio Performance Analyzer|DBonSolaris.PGSolAnalyzer]
* Problem Determination
h2. Performance Tuning and Recommend Layouts
* [Peformance Tunings for PostgreSQL on Solaris |DBonSolaris:PGSolTuning]
* [PostgreSQL Tuning from SolarisInternals|http://www.solarisinternals.com/wiki/index.php/Application_Specific_Tuning#PostgreSQL]
h2. Recommended Layouts/Best Practices
* [Recommended Layouts for PostgreSQL on Solaris |DBonSolaris:PGSolBestPractices]
h2. [Benchmarks and Workloads with PostgreSQL|DBonSolaris.PGSolBenchmarks]
* [EAStress|DBonSolaris.PGSolBenchmarks#EAStress]
* [TPC-E|DBonSolaris.PGSolBenchmarks#TPCE]
* [TPC-H|DBonSolaris.PGSolBenchmarks#TPCH]
* [SysBench|DBonSolaris.PGSolBenchmarks#SysBench]
h2. Published Benchmarks
* [SpecJAppServer2004 benchmarks using PostgreSQL on Solaris |DBonSolaris:PGSpecJ]
h2. [Bottlenecks Possible with PostgreSQL|DBonSolaris.PGSolBottlenecks]
* [ProcArray Structure |DBonSolaris.PGSolBottlenecks#PGSolProcArray]
* [CLOG Buffers |DBonSolaris.PGSolBottlenecks#PGSolCLog]
* [WALWriteLock |DBonSolaris.PGSolBottlenecks#PGSolWALWriteLock]
* [WALInsertLock |DBonSolaris.PGSolBottlenecks#PGSolWALInsertLock]
h2. [Other tasks with PostgreSQL on Solaris|DBonSolaris.PGSolMisc]
h2. References
* PostgreSQL.org Documentation
* docs.sun.com Documentation
h2. [Glossary|DBonSolaris.PGSolDocGlossary]
h2. [Index|DBonSolaris.PGSolDocIndex]
h2. Articles
* [PostgreSQL in OpenSolaris |http://www.sun.com/bigadmin/features/articles/postgresql_opensolaris.jsp] \- Zdenek Kotala, July 2007
h2. Blog Entries
* [PostgreSQL 8.3beta1 on Solaris|http://blogs.sun.com/jkshah/entry/postgresql_8_3beta_testing_on]
h2. Blogs on PostgreSQL
* Josh Berkus: [http://blogs.ittoolbox.com/database/soup]
* Jignesh Shah: [http://blogs.sun.com/jkshah]
* Tom Daly: [http://blogs.sun.com/tomdaly]
* Robert Lor: [http://blogs.sun.com/robertlor/]
* Glenn Fawcett: [http://blogs.sun.com/glennf/category/Postgres]
h2. PostgreSQL for Solaris
* [http://sun.com/postgresql]
* [PostgreSQL on Solaris|http://www.sun.com/software/products/postgresql/index.jsp]
* [Building your own PostgreSQL|BuildingPostgreSQL]
h2. PostgreSQL:
* [http://www.postgresql.org]
h2. OpenSolaris databases community
* [http://www.opensolaris.org/os/community/databases/]
h2. Ask Questions on OpenSolaris Database Forum
* [http://www.opensolaris.org/jive/forum.jspa?forumID=175]
h2. Feedback
* postgresql-feedback@sun.com