|
Key
This line was removed.
This word was removed. This word was added.
This line was added.
|
Changes (2)
View page history| !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. [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] h3. Feedback * postgresql-feedback@sun.com |
| h1. Integrated with [http://wikis.sun.com/display/DBonSolaris/PostgreSQL] |