November Newsletter

_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=