skip to content
Covid-19 virus
COVID-19 Resources

Reliable information about the coronavirus (COVID-19) is available from the World Health Organization (current situation, international travel). Numerous and frequently-updated resource results are available from this WorldCat.org search. OCLC’s WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus issues in their communities.

Image provided by: CDC/ Alissa Eckert, MS; Dan Higgins, MAM
PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL Preview this item
ClosePreview this item
Checking...

PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL

Author: Shaun M Thomas
Publisher: Birmingham [England] : Packt Publishing, 2014. ©2014
Series: Quick answers to common problems.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Shaun M Thomas
ISBN: 9781849516976 1849516979 1849516960 9781849516969
OCLC Number: 1005947351
Notes: Includes index.
Description: 1 online resource (398 pages) : illustrations, tables.
Contents: Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Hardware Planning; Introduction; Planning for redundancy; Having enough IOPS; Sizing storage; Investing in a RAID; Picking a processor; Making the most of memory; Exploring nimble networking; Managing motherboards; Selecting a chassis; Saddling up to a SAN; Tallying up; Protecting your eggs; Chapter 2: Handling and Avoiding Downtime; Introduction; Determining acceptable losses; Configuration --
getting it right the first time; Configuration --
managing scary settings Identifying important tablesDefusing cache poisoning; Exploring the magic of virtual IPs; Terminating rogue connections; Reducing contention with concurrent indexes; Managing system migrations; Managing software upgrades; Mitigating the impact of hardware failure; Applying bonus kernel tweaks; Chapter 3: Pooling Resources; Introduction; Determining connection costs and limits; Installing PgBouncer; Configuring PgBouncer safely; Connecting to PgBouncer; Listing PgBouncer server connections; Listing PgBouncer client connections; Evaluating PgBouncer pool health; Installing pgpool Configuring pgpool for master/slave modeTesting a write query on pgpool; Swapping active nodes with pgpool; Combining the power of PgBouncer and pgpool; Chapter 4: Troubleshooting; Introduction; Performing triage; Installing common statistics packages; Evaluating the current disk performance with iostat; Tracking I/O-heavy processes with iotop; Viewing past performance with sar; Correlating performance with dstat; Interpreting /proc/meminfo; Examining /proc/net/bonding/bond0; Checking the pg_stat_activity view; Checking the pg_stat_statements view; Debugging with strace Logging checkpoints properlyChapter 5: Monitoring; Introduction; Figuring out what to monitor; Installing and configuring Nagios; Configuring Nagios to monitor a database host; Enhancing Nagios with check_mk; Getting to know check_postgres; Installing and configuring collectd; Adding a custom PostgreSQL monitor to collectd; Installing and configuring Graphite; Adding collectd data to Graphite; Building a graph in Graphite; Customizing a Graphite graph; Creating a Graphite dashboard; Chapter 6: Replication; Introduction; Deciding what to copy; Securing the WAL stream; Setting up a hot standby Upgrading to asynchronous replicationBulletproofing with synchronous replication; Faking replication with pg_receivexlog; Setting up Slony; Copying a few tables with Slony; Setting up Bucardo; Copying a few tables with Bucardo; Setting up Londiste; Copying a few tables with Londiste; Chapter 7: Replication Management Tools; Introduction; Deciding when to use third-party tools; Installing and configuring Barman; Backing up a database with Barman; Restoring a database with Barman; Installing and configuring OmniPITR; Managing WAL files with OmniPITR; Installing and configuring repmgr
Series Title: Quick answers to common problems.
Responsibility: Shaun M. Thomas.

Abstract:

A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


\n\n

Primary Entity<\/h3>\n
<http:\/\/www.worldcat.org\/oclc\/1005947351<\/a>> # PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:MediaObject<\/a>, schema:Book<\/a>, schema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"1005947351<\/span>\" ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/id.loc.gov\/vocabulary\/countries\/enk<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/database_management<\/a>> ; # Database management<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/005.74\/e23\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#CreativeWork\/postgresql<\/a>> ; # PostgreSQL.<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/computers_databases_servers<\/a>> ; # COMPUTERS--Databases--Servers<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/computers_programming_languages_sql<\/a>> ; # COMPUTERS--Programming Languages--SQL<\/span>\n\u00A0\u00A0\u00A0\nschema:author<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Person\/thomas_shaun_m<\/a>> ; # Shaun M. Thomas<\/span>\n\u00A0\u00A0\u00A0\nschema:bookFormat<\/a> schema:EBook<\/a> ;\u00A0\u00A0\u00A0\nschema:copyrightYear<\/a> \"2014<\/span>\" ;\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2014<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you\'ve ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Hardware Planning; Introduction; Planning for redundancy; Having enough IOPS; Sizing storage; Investing in a RAID; Picking a processor; Making the most of memory; Exploring nimble networking; Managing motherboards; Selecting a chassis; Saddling up to a SAN; Tallying up; Protecting your eggs; Chapter 2: Handling and Avoiding Downtime; Introduction; Determining acceptable losses; Configuration -- getting it right the first time; Configuration -- managing scary settings<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/2219596433<\/a>> ;\u00A0\u00A0\u00A0\nschema:genre<\/a> \"Electronic books<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isPartOf<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Series\/quick_answers_to_common_problems<\/a>> ; # Quick answers to common problems.<\/span>\n\u00A0\u00A0\u00A0\nschema:name<\/a> \"PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"1005947351<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/nls.ldls.org.uk\/welcome.html?ark:\/81055\/vdc_100035561999.0x000001<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/login.gbcprx01.georgebrown.ca\/login?url=http:\/\/public.ebookcentral.proquest.com\/choice\/publicfullrecord.aspx?p=1744438<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.vlebooks.com\/vleweb\/product\/openreader?id=none&isbn=9781849516976<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/public.ebookcentral.proquest.com\/choice\/publicfullrecord.aspx?p=1744438<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/VH7QX3XE2P.search.serialssolutions.com\/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0001377037&T=marc&tab=BOOKS<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proquest.safaribooksonline.com\/9781849516969<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781849516976<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781849516969<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/1005947351<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/dewey.info\/class\/005.74\/e23\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#CreativeWork\/postgresql<\/a>> # PostgreSQL.<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"PostgreSQL.<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Person\/thomas_shaun_m<\/a>> # Shaun M. Thomas<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Thomas<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"Shaun M.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Shaun M. Thomas<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Series\/quick_answers_to_common_problems<\/a>> # Quick answers to common problems.<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nbgn:PublicationSeries<\/a> ;\u00A0\u00A0\u00A0\nschema:hasPart<\/a> <http:\/\/www.worldcat.org\/oclc\/1005947351<\/a>> ; # PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL<\/span>\n\u00A0\u00A0\u00A0\nschema:name<\/a> \"Quick answers to common problems.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Quick answers to common problems<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/computers_databases_servers<\/a>> # COMPUTERS--Databases--Servers<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"COMPUTERS--Databases--Servers<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/computers_programming_languages_sql<\/a>> # COMPUTERS--Programming Languages--SQL<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"COMPUTERS--Programming Languages--SQL<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/2219596433#Topic\/database_management<\/a>> # Database management<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Database management<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.loc.gov\/vocabulary\/countries\/enk<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\ndcterms:identifier<\/a> \"enk<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/VH7QX3XE2P.search.serialssolutions.com\/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0001377037&T=marc&tab=BOOKS<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"VIEW FULL TEXT<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781849516969<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1849516960<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781849516969<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781849516976<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1849516979<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781849516976<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/1005947351<\/a>>\u00A0\u00A0\u00A0\u00A0a \ngenont:InformationResource<\/a>, genont:ContentTypeGenericResource<\/a> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/www.worldcat.org\/oclc\/1005947351<\/a>> ; # PostgreSQL 9 high availability cookbook : over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL<\/span>\n\u00A0\u00A0\u00A0\nschema:dateModified<\/a> \"2019-07-18<\/span>\" ;\u00A0\u00A0\u00A0\nvoid:inDataset<\/a> <http:\/\/purl.oclc.org\/dataset\/WorldCat<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n