Skip site navigation (1) Skip section navigation (2)

November Newsletter

From: Brian Pottberg <brianp(at)consistentstate(dot)com>
To: denpug <denpug(at)postgresql(dot)org>
Subject: November Newsletter
Date: 2011-11-09 18:08:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: denpug
_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?
  [1]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
that a
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:

Previous Topics

  _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
data, it
  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:

Previous Topics

  _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

  Hot Standby


  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
  [6] and sign up for our mailing list today!

Previous Topics

  _Benchmarking Tools Bonnie++ _
  is a free [7]file system benchmarking tool for [8]Unix-like [9]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
  positive effect.
    * 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:

Previous Topics

  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:

Previous Topics

  _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
  [12]High Availability Methods

Previous Topics

  PostGIS adds support for geographic objects to the [13]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 [14]OpenGIS "[15]Simple Features
  Specification for SQL" and has been certified as compliant with the "Types
  and Functions" profile.  PostGIS has been developed by [16]Refractions
  Research as a project in [17]open source spatial database technology.
  PostGIS is released under the [18]GNU General Public License. PostGIS
  continues to develop and has added [19]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.
    * [20]PostGIS

Previous Topics

  _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
  Denver, CO.

  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
  * Triggers
  * Views
  * Transactional integrity
  * Multi version concurrency control

  Also, PostgreSQL can be extended by the user in many ways, for example by
  adding new

  * Data types
  * Functions
  * Operators
  * 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:

   [22]follow on Twitter | [23]friend on Facebook | [24]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:_
  Consistent State
5660 Greenwood Plaza Blvd Ste 138
Greenwood Village, CO 80111

 Email Marketing Powered by MailChimp
   [25]unsubscribe from this list | [26]update subscription preferences
Twitter Account not yet Authorized



denpug by date

Next:From: Brian PottbergDate: 2011-11-09 22:51:26
Subject: DENPUG Meeting Tonight!
Previous:From: Brian PottbergDate: 2011-11-08 01:21:23
Subject: DENPUG Meeting This Wednesday!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group