_Check_postgres_ is a script for monitoring various attributes of your
database._ Nagios_ is a powerful monitoring system that enables
organizations to identify and resolve IT infrastructure problems before
affect critical business processes.
Is this email not displaying correctly?
View it in your browser.
Check_postgres & Nagios
is a script for monitoring various attributes of your database. Includes
checks for locks, table and index bloat, number of connections, database
size, idle transactions, and many others. It is designed to work with
Nagios, MRTG, or in standalone scripts. Includes support for new actions:
disabled_triggers: checks on the number of disabled triggers in the
Triggers can be disabled with an ALTER TABLE command, but for most cases
should be a very temporary event.
prepared_txns: checks on the maximum age of any prepared transactions. The
of these is very rare, and is only associated with two-part commit, so for
installations seeing a prepared transaction indicates a problem that should
fixed. Unclosed prepared transactions, like an open regular transaction,
prevent vacuum from doing its job completely.
new_version_cp: checks if the version of check_postgres you are running is
latest one available. Versions consist of three numbers: major, minor, and
revision. If a minor revision is available, a warning is given. If a major
minor upgrade is available, a critical is given.
new_version_pg: checks is a newer version of Postgres is available. This
checks the revision, so that if you are running 8.1.11, it will warn you
newer version in the 8.1 series is available, and not bug you about 8.3.
For more information visit:
_is a powerful monitoring system that enables organizations to identify
resolve IT infrastructure problems before they affect critical business
Designed with scalability and flexibility in mind, Nagios gives you the
peace of mind that comes from knowing your organization's business
won't be affected by unknown outages.
Nagios is a powerful tool that provides you with instant awareness of your
organization's mission-critical IT infrastructure. Nagios allows you to
detect and repair problems and mitigate future issues before they affect
end-users and customers.
By using Nagios, you can:
* Plan for infrastructure upgrades before outdated systems cause
* Respond to issues at the first sign of a problem
* Automatically fix problems when they are detected
* Coordinate technical team responses
* Ensure your organization's SLAs are being met
* Ensure IT infrastructure outages have a minimal effect on your
organization's bottom line
* Monitor your entire infrastructure and business processes
For more information visit:
_Ora2Pg Migration Tool_
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL
compatible schema. It connects your
Oracle database, scan it automatically and extracts its structure or
then generates SQL scripts that you can
load into your PostgreSQL database.
Ora2Pg can be used from reverse engineering Oracle database to huge
enterprise database migration or simply to replicate
some Oracle data into a PostgreSQL database. It is really easy to use and
doesn't need any Oracle database knowledge than
providing the parameters needed to connect to the Oracle database.
For more info go to:
_Hot Standby _
This was last month's previous topic for the Denver Postgresql User's
Group. It was hosted at the Consistent State head office and the
presentation was given by our own Brian Fehrle. We meet on the second
Wednesday of every month to discuss new Postgresql related topics.
For even more info. on Hot Standby check out the full presentation
The Denver PostgreSQL User's Group is dedicated to raising awareness in
community about PostgreSQL. We meet on the second Wednesday of every
at the consistent state home office. We have speakers and presentations
various database related topics as well as group discussions.
For more information and directions please visit our user's group website
www.diapug.org and sign up for our mailing list today!
_Benchmarking Tools Bonnie++ _
is a free file system benchmarking tool for Unix-like operating
systems, developed by Russell Coker. Bonnie++ is a benchmark suite that is
aimed at performing a number of simple tests of hard drive and file system
performance. The Bonnie++ benchmark is a great yardstick to see if you
getting the performance from your hardware that you think you should. You
can search around for Bonnie++ results that other people have produced and
published using similar hardware. If you are making changes to how your
or file system is created, Bonnie++ is invaluable for testing whether the
changes you think should improve performance actually have a noticeable
* Bonnie++ allows you to benchmark how your file systems perform various
* Bonnie++ benchmarks the below factors:
+ Data read and write speed
+ Number of seeks that can be performed per second.
+ Number of file metadata operations that can be performed per
For more information visit:
Ogr2ogr converts simple features data between file formats. This program
can be used to convert simple features data between file formats
various operations during the process such as spatial or attribute
selections, reducing the set of attributes, setting the output coordinate
system or even reprojecting the features during translation.
For more information look here:
_High Availability & Load Balancing_
Database servers can work together to allow a second server to take over
quickly if the primary server fails (high availability), or to allow
computers to serve the same data (load balancing).
For even more info. on High Availability check out the full presentation
High Availability Methods
PostGIS adds support for geographic objects to the PostgreSQL
object-relational database. In effect, PostGIS "spatially enables" the
PostgreSQL server, allowing it to be used as a backend spatial database
geographic information systems (GIS), much like ESRI's SDE or Oracle's
Spatial extension. PostGIS follows the OpenGIS "Simple Features
Specification for SQL" and has been certified as compliant with the "Types
and Functions" profile. PostGIS has been developed by Refractions
Research as a project in open source spatial database technology.
PostGIS is released under the GNU General Public License. PostGIS
continues to develop and has added user interface tools, basic
support, data validation, coordinate transformation, programming APIs and
much more. For future projects it will include full topology support,
raster support, networks and routing, three dimensional surfaces, curves
and splines and other features.
For even more info. on PostGIS check out the full presentation below.
_PG DAY 2011_
PG Day is a one day conference held in The United States focused on
database professionals and developers of PostgreSQL, the worlds most
advanced open source database. Our conference will be on October 21, 2011
PG day is for everyone weather you are an entrepreneur, technologist, or
of the leaders in data management, PG Day has something to offer you. PG
will promote training and awareness of PostgreSQL as well as its’ use and
If this is your first PostgreSQL Conference, you may be asking yourself,
“What is PostgreSQL?”
PostgreSQL is an object-relational database management system (ORDBMS)
on POSTGRES, Version 4.2, developed at the University of California at
Berkeley Computer Science Department. POSTGRES pioneered many concepts
only became available in some commercial database systems much later.
PostgreSQL is an open-source descendant of this original Berkeley code. It
supports a large part of the SQL standard and offers many modern features:
* Complex queries
* Foreign keys
* Transactional integrity
* Multi version concurrency control
Also, PostgreSQL can be extended by the user in many ways, for example by
* Data types
* Aggregate functions
* Index methods
* Procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and
distributed by anyone free of charge for any purpose, be it private,
commercial, or academic.
You now have an opportunity to meet with the Postgres community to share
explore the advances and capabilities of Postgres. We know you’ll find
valuable information on the world’s most advanced open source database.
presentation lineup will allow you to build your skills, hear from your
peers and other end users about their implementations, and network with
community leaders to discuss future product directions.
For more information visit:
follow on Twitter | friend on Facebook | forward to a friend
_Copyright © 2011 Consistent State, All rights reserved._
You are receiving this email because you have signed up for the
denpug(at)postgresql(dot)org mailing list.
_Our mailing address is:_
5660 Greenwood Plaza Blvd Ste 138
Greenwood Village, CO 80111
Email Marketing Powered by MailChimp
unsubscribe from this list | update subscription preferences
Twitter Account not yet Authorized
denpug by date
|Next:||From: Brian Pottberg||Date: 2011-11-09 22:51:26|
|Subject: DENPUG Meeting Tonight!|
|Previous:||From: Brian Pottberg||Date: 2011-11-08 01:21:23|
|Subject: DENPUG Meeting This Wednesday!|