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: CA+PwVoTSXwOXdO_fXpGRned0h-HgiF44HaWn_=zP39Fmn1PHmQ@mail.gmail.com (view raw or flat)
Thread:
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
they
  affect critical business processes.
  Is this email not displaying correctly?
  [1]View it in your browser.
    Links:
      1.
http://us2.campaign-archive2.com/?u=520025803bd284614b15006c8&id=43cfca5b70&e=

Check_postgres & Nagios

  _Check_postgres_
  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
database.
Triggers can be disabled with an ALTER TABLE command, but for most cases
this
should be a very temporary event.

prepared_txns: checks on the maximum age of any prepared transactions. The
use
of these is very rare, and is only associated with two-part commit, so for
most
installations seeing a prepared transaction indicates a problem that should
be
fixed. Unclosed prepared transactions, like an open regular transaction,
will
prevent vacuum from doing its job completely.

new_version_cp: checks if the version of check_postgres you are running is
the
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
or
minor upgrade is available, a critical is given.

new_version_pg: checks is a newer version of Postgres is available. This
only
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:
http://bucardo.org/wiki/Check_postgres

  _Nagios
  _is a powerful monitoring system that enables organizations to identify
and
  resolve IT infrastructure problems before they affect critical business
  processes.

  Designed with scalability and flexibility in mind, Nagios gives you the
  peace of mind that comes from knowing your organization's business
processes
  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
failures
    * 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:
http://www.nagios.org/

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:
  http://ora2pg.darold.net/

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
below.[5]

  Hot Standby

DENPUG
    Links:
      5.
http://gallery.mailchimp.com/520025803bd284614b15006c8/files/Hot_Standby.odp

  The Denver PostgreSQL User's Group is dedicated to raising awareness in
the
  community about PostgreSQL.  We meet on the second Wednesday of every
month
  at the consistent state home office.  We have speakers and presentations
for
  various database related topics as well as group discussions.

  For more information and directions please visit our user's group website
  [6]www.diapug.org and sign up for our mailing list today!
    Links:
      6. http://www.diapug.org

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
are
  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
RAID
  or file system is created, Bonnie++ is invaluable for testing whether the
  changes you think should improve performance actually have a noticeable
and
  positive effect.
    * Bonnie++ allows you to benchmark how your file systems perform various
      tasks
    * 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
second
    Links:
      7. http://en.wikipedia.org/wiki/Benchmarking
      8. http://en.wikipedia.org/wiki/Unix-like
      9. http://en.wikipedia.org/wiki/Operating_system

  For more information visit:
  http://www.linux.com/archive/feature/139742

Previous Topics

  _Ogr2ogr_
  Ogr2ogr converts simple features data between file formats.  This program
  can be used to convert simple features data between file formats
performing
  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:
  http://www.gdal.org/ogr2ogr.html

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
several
  computers to serve the same data (load balancing).

  For even more info. on High Availability check out the full presentation
  below.
  [12]High Availability Methods
    Links:
      12.
http://gallery.mailchimp.com/520025803bd284614b15006c8/files/postgres_ha_methods.1.odp

Previous Topics

  _PostGIS_
  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
for
  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
topology
  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.
    Links:
      13. http://www.postgresql.org
      14. http://www.opengis.org
      15. http://www.opengis.org/docs/99-049.pdf
      16. http://www.refractions.net
      17. http://www.opensource.org/docs/osd
      18. http://www.opensource.org/licenses/gpl-2.0.php
      19. http://udig.refractions.net


  For even more info. on PostGIS check out the full presentation below.
    * [20]PostGIS
    Links:
      20.
http://gallery.mailchimp.com/520025803bd284614b15006c8/files/postGIS_Intro.odp



Previous Topics

  _PG DAY 2011_
  PG Day is a one day conference held in The United States focused on
training
  database professionals and developers of PostgreSQL, the worlds most
  advanced open source database. Our conference will be on October 21, 2011
in
  Denver, CO.

  PG day is for everyone weather you are an entrepreneur, technologist, or
one
  of the leaders in data management, PG Day has something to offer you. PG
Day
  will promote training and awareness of PostgreSQL as well as its’ use and
  development.

  If this is your first PostgreSQL Conference, you may be asking yourself,
  “What is PostgreSQL?”

  PostgreSQL is an object-relational database management system (ORDBMS)
based
  on POSTGRES, Version 4.2, developed at the University of California at
  Berkeley Computer Science Department. POSTGRES pioneered many concepts
that
  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
and
  explore the advances and capabilities of Postgres.  We know you’ll find
  valuable information on the world’s most advanced open source database.
Our
  presentation lineup will allow you to build your skills, hear from your
  peers and other end users about their implementations, and network with
the
  community leaders to discuss future product directions.

  For more information visit:
  [21]http://pgday.consistentstate.com
    Links:
      21. http://www.linux.com/archive/feature/139742

   [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
http://www.mailchimp.com/monkey-rewards/?aid=520025803bd284614b15006c8&afl=1
   [25]unsubscribe from this list | [26]update subscription preferences
    Links:
      22.
Twitter Account not yet Authorized


      23.
#


      24.
http://us2.forward-to-friend1.com/forward?u=520025803bd284614b15006c8&id=43cfca5b70&e=
      25.
http://consistentstate.us2.list-manage1.com/unsubscribe?u=520025803bd284614b15006c8&id=bc379475f4&e=&c=43cfca5b70
      26.
http://consistentstate.us2.list-manage.com/profile?u=520025803bd284614b15006c8&id=bc379475f4&e=

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-2014 The PostgreSQL Global Development Group