Consistent State Monthly Newsletter

Hot Standby is the term used to describe the ability to connect to the
server and run read-only queries while the server is in archive recovery or
standby mode.
Is this email not displaying correctly?
View it in your
browser<http://us2.campaign-archive2.com/?u=520025803bd284614b15006c8&id=dfbfd4151b&e=>.

Consistent State News *New services coming soon!
**"Free Mini Health Check Service"*
A 1-2 day engagement covering the basics of your database system
configuration, includes base recommendations.

* Recently Released Services:
**"Health Check Service"
*A 2 week engagement covering all the aspects of your database, includes
recommendations.
Consistent State Events *Upcoming Events:*
"Free Lunch Seminar"
A free lunch on us and a presentation to spread the word about postgresql,
an enterprise class database system.

"DIAPUG Monthly Meeting"
A monthly gathering for postgresql users held at the consistent state home
office on the 2ND Wednesday of every month. Join us for a presentation of
postgresql related topics and a discussion afterwords.

"PG EAST"
A once a year conference where PostgreSQL user's from around the globe
gather for presentations on various database topics.

*Future Events:*
"PG WEST"
A once a year conference where PostgreSQL user's from around the globe
gather for presentations on various database 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.

Hot Standby is the term used to describe the ability to connect to the
server and run read-only queries while the server is in archive recovery or
standby mode. This is useful both for replication purposes and for restoring
a backup to a desired state with great precision. The term Hot Standby also
refers to the ability of the server to move from recovery through to normal
operation while users continue running queries and/or keep their connections
open.

Hot Standby includes features such as: there are no additional installations
required in order to run hot standby. It shares features with the
pg_standby contrib and the standby is online in “Read Only” mode. Hot
Standby replicates everything and there is very little time required to
bring it out of standby mode. Hot standby streams the wal files and the
max_standby_archive_delay as well as the max_standby_streaming_delay can be
adjusted by the user. Snapshots may be taken at the start of each query or
at the start of each transaction, depending on the current transaction
isolation level.

Some things to keep in mind are that the Standby is only as up to date as of
the last WAL file recieved and that long queries run on the standby can
cause it to lag behind. When the hot_standby parameter is set to true on a
standby server, it will begin accepting connections once the recovery has
brought the system to a consistent state. All such connections are strictly
read-only; not even temporary tables may be written. As long as no attempt
is made to modify the database, connections during hot standby will act much
like any other database connection. If failover or switchover occurs, the
database will switch to normal processing mode. Sessions will remain
connected while the server changes mode. Once hot standby finishes, it will
be possible to initiate read-write transactions (even from a session begun
during hot standby).

For even more info. on Hot Standby check out the full presentation below.

- Hot Standby<http://gallery.mailchimp.com/520025803bd284614b15006c8/files/Hot_Standby.odp?utm_source=DIAPUG&utm_campaign=dfbfd4151b-Consistent_State_Monthly_Newsletter4_5_2011&utm_medium=email>

Conferences *PG EAST 2010
*Kevin presents SLONY

*PG WEST 2010
*Kevin presents Backup and Recovery Methods

* PG EAST 2011
*Kevin presents HA (High Availability) Methods

Kevin presents Backup and Recovery Methods
DIAPUG 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
www.diapug.org<http://www.diapug.org?utm_source=DIAPUG&utm_campaign=dfbfd4151b-Consistent_State_Monthly_Newsletter4_5_2011&utm_medium=email>and
sign up for our mailing list today!
Consistent State
We are a PostgreSQL Professional Services organization. We offer PostgreSQL
Consulting Services, as well as a variety of customized services. We’ve
been around since 1998 and our founder has over 20 years of experience in
the industry. We have a core group of Professional PostgreSQL DBA’s that can
perform any tasks needed per managing your PostgreSQL database servers.
Consistent State leverages our team’s decades of database & software
development experience to provide our clients with practical & affordable
database solutions.

Please visit our company website at
www.consistentstate.com<http://www.consistentstate.com?utm_source=DIAPUG&utm_campaign=dfbfd4151b-Consistent_State_Monthly_Newsletter4_5_2011&utm_medium=email>for
more information.

**
follow on Twitter
<http://Twitter+Account+not+yet+Authorized> | friend
on Facebook <#12f272409926281e_> | forward to a
friend<http://us2.forward-to-friend1.com/forward?u=520025803bd284614b15006c8&id=dfbfd4151b&e=>

Copyright © 2011 Consistent State, All rights reserved.
Our mailing address is:
5650 Greenwood Plaza Blvd
Unit 138
Greenwood Village, CO 80111

www.consistentstate.com
unsubscribe from this
list<http://consistentstate.us2.list-manage2.com/unsubscribe?u=520025803bd284614b15006c8&id=f61b490b7e&e=&c=dfbfd4151b>|
update
subscription preferences<http://consistentstate.us2.list-manage.com/profile?u=520025803bd284614b15006c8&id=f61b490b7e&e=>|
view
email in browser
<http://us2.campaign-archive2.com/?u=520025803bd284614b15006c8&id=dfbfd4151b&e=>