PostgreSQL 13 Cookbook /:
Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-bas...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Körperschaft: | |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Packt Publishing,
2021.
|
| Ausgabe: | 1st edition. |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-based approach Solve common and not-so-common challenges faced while working to achieve optimal database performance Book Description PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You'll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you'll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you'll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you'll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you'll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases. What you will learn Understand logical and physical backups in Postgres Demonstrate the different types of replication methods possible with PostgreSQL today Set up a high availability cluster that provides seamless automatic failover for applications Secure a PostgreSQL encryption through authentication, authorization, and auditing Analyze the live and historic activity of a PostgreSQL server Understand how to monitor critical services in Postgres 13 Manage maintenance activities and performance tuning of a PostgreSQL cluster Who this book is for This PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design effic ... |
| Beschreibung: | 1 online resource (344 pages) |
| ISBN: | 183864105X 9781838641054 |
Internformat
MARC
| LEADER | 00000cam a22000007a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-on1246197189 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||||||| | ||
| 008 | 050321s2021 xx o 000 0 eng | ||
| 040 | |a AU@ |b eng |c AU@ |d TAC |d OCLCQ |d TOH |d OCLCQ |d IEEEE |d YDX |d N$T |d UKAHL |d EBLCP |d NLW |d OCLCO |d OCLCF |d OCLCO |d OCLCL | ||
| 019 | |a 1240381036 |a 1241448083 |a 1256700310 |a 1302698120 |a 1355685967 | ||
| 020 | |z 9781838648138 | ||
| 020 | |z 9781838641054 | ||
| 020 | |a 183864105X |q (electronic bk.) | ||
| 020 | |a 9781838641054 | ||
| 020 | |z 1838648135 | ||
| 024 | 8 | |a 9781838648138 | |
| 035 | |a (OCoLC)1246197189 |z (OCoLC)1240381036 |z (OCoLC)1241448083 |z (OCoLC)1256700310 |z (OCoLC)1302698120 |z (OCoLC)1355685967 | ||
| 037 | |a 10163115 |b IEEE | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 7 | |a 005.7585 |2 23/eng/20230822 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Kumar, Vallarapu, |e author. | |
| 245 | 1 | 0 | |a PostgreSQL 13 Cookbook / |c Kumar, Vallarapu. |
| 250 | |a 1st edition. | ||
| 264 | 1 | |b Packt Publishing, |c 2021. | |
| 300 | |a 1 online resource (344 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 520 | |a Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-based approach Solve common and not-so-common challenges faced while working to achieve optimal database performance Book Description PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You'll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you'll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you'll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you'll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you'll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases. What you will learn Understand logical and physical backups in Postgres Demonstrate the different types of replication methods possible with PostgreSQL today Set up a high availability cluster that provides seamless automatic failover for applications Secure a PostgreSQL encryption through authentication, authorization, and auditing Analyze the live and historic activity of a PostgreSQL server Understand how to monitor critical services in Postgres 13 Manage maintenance activities and performance tuning of a PostgreSQL cluster Who this book is for This PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design effic ... | ||
| 542 | |f Copyright © 2021 Packt Publishing |g 2021 | ||
| 550 | |a Made available through: Safari, an O'Reilly Media Company. | ||
| 588 | |a Online resource; Title from title page (viewed February 26, 2021) | ||
| 505 | 0 | |a Intro -- Title Page -- Cover -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Chapter 1: Cluster Management Fundamentals -- Technical requirements -- Installing PostgreSQL 13 using RPMs on CentOS -- Getting ready -- How to do it... -- How it works... -- Initializing a PostgreSQL cluster using initdb -- Getting ready -- How to do it... -- How it works... -- Starting a PostgreSQL cluster using pg_ctl -- Getting ready -- How to do it... -- How it works... -- Clusters in PostgreSQL -- Databases in PostgreSQL -- There's more... | |
| 505 | 8 | |a Shutting down a PostgreSQL cluster using different shutdown modes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying a PostgreSQL data directory and its contents -- Getting ready -- How to do it... -- How it works... -- There's more... -- Moving pg_wal to another location -- Getting ready -- How to do it... -- How it works... -- Running the psql client and some psql shortcuts -- Getting ready -- How to do it... -- How it works... -- Running a SQL server using psql -- Getting a list of databases -- Finding the database's size -- Connecting to a database | |
| 505 | 8 | |a Getting the list of schemas in a database -- Getting the list of tables -- Describing a table -- There's more... -- SQLs behind the shortcuts -- Locating the Postgres configuration file -- Getting ready -- How to do it... -- How it works... -- There's more... -- include_dir -- include -- Modifying the location of a postgresql.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- Modifying the postgresql.auto.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enable archiving in PostgreSQL -- Getting ready | |
| 505 | 8 | |a How to do it... -- How it works... -- There's more... -- Chapter 2: Cluster Management Techniques -- Technical requirements -- Creating and dropping databases -- Getting ready -- How to do it... -- How it works -- There's more -- Locating a database and a table on the file system -- Getting ready -- How to do it... -- How it works... -- Creating a schema in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Checking table and index sizes in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating tablespaces | |
| 505 | 8 | |a Getting ready -- How to do it... -- How it works -- There's more... -- Moving tables to a different tablespace -- Getting ready -- How to do it... -- How it works -- Creating a user in PostgreSQL -- Getting ready -- How to do it... -- How it works -- There's more... -- Dropping a user in PostgreSQL -- Getting ready -- How to do it ... -- How it works ... -- Assigning and revoking a privilege to/from a user or a role -- Getting ready -- How to do it -- How it works -- Creating a group role for role-based segregation -- Getting ready -- How to do it -- How it works | |
| 650 | 0 | |a PostgreSQL | |
| 650 | 0 | |a SQL (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh86006628 | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Databases |x Design. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Servers. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a Data capture & analysis. |2 bicssc | |
| 650 | 7 | |a Data mining. |2 bicssc | |
| 650 | 7 | |a Computers |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Computers |x Database Management |x Data Mining. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Databases |x Design |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 710 | 2 | |a Safari, an O'Reilly Media Company. | |
| 758 | |i has work: |a PostgreSQL 13 Cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCYPGRMWJFVDYxdKYwwGVbq |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |z 1838648135 |z 9781838648138 |w (OCoLC)1153293326 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2762120 |3 Volltext |
| 936 | |a BATCHLOAD | ||
| 938 | |a YBP Library Services |b YANK |n 301961181 | ||
| 938 | |a EBSCOhost |b EBSC |n 2762120 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH37406755 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6507012 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-on1246197189 |
|---|---|
| _version_ | 1816882542203109376 |
| adam_text | |
| any_adam_object | |
| author | Kumar, Vallarapu |
| author_corporate | Safari, an O'Reilly Media Company |
| author_corporate_role | |
| author_facet | Kumar, Vallarapu Safari, an O'Reilly Media Company |
| author_role | aut |
| author_sort | Kumar, Vallarapu |
| author_variant | v k vk |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.S67 |
| callnumber-search | QA76.73.S67 |
| callnumber-sort | QA 276.73 S67 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Intro -- Title Page -- Cover -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Chapter 1: Cluster Management Fundamentals -- Technical requirements -- Installing PostgreSQL 13 using RPMs on CentOS -- Getting ready -- How to do it... -- How it works... -- Initializing a PostgreSQL cluster using initdb -- Getting ready -- How to do it... -- How it works... -- Starting a PostgreSQL cluster using pg_ctl -- Getting ready -- How to do it... -- How it works... -- Clusters in PostgreSQL -- Databases in PostgreSQL -- There's more... Shutting down a PostgreSQL cluster using different shutdown modes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying a PostgreSQL data directory and its contents -- Getting ready -- How to do it... -- How it works... -- There's more... -- Moving pg_wal to another location -- Getting ready -- How to do it... -- How it works... -- Running the psql client and some psql shortcuts -- Getting ready -- How to do it... -- How it works... -- Running a SQL server using psql -- Getting a list of databases -- Finding the database's size -- Connecting to a database Getting the list of schemas in a database -- Getting the list of tables -- Describing a table -- There's more... -- SQLs behind the shortcuts -- Locating the Postgres configuration file -- Getting ready -- How to do it... -- How it works... -- There's more... -- include_dir -- include -- Modifying the location of a postgresql.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- Modifying the postgresql.auto.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enable archiving in PostgreSQL -- Getting ready How to do it... -- How it works... -- There's more... -- Chapter 2: Cluster Management Techniques -- Technical requirements -- Creating and dropping databases -- Getting ready -- How to do it... -- How it works -- There's more -- Locating a database and a table on the file system -- Getting ready -- How to do it... -- How it works... -- Creating a schema in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Checking table and index sizes in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating tablespaces Getting ready -- How to do it... -- How it works -- There's more... -- Moving tables to a different tablespace -- Getting ready -- How to do it... -- How it works -- Creating a user in PostgreSQL -- Getting ready -- How to do it... -- How it works -- There's more... -- Dropping a user in PostgreSQL -- Getting ready -- How to do it ... -- How it works ... -- Assigning and revoking a privilege to/from a user or a role -- Getting ready -- How to do it -- How it works -- Creating a group role for role-based segregation -- Getting ready -- How to do it -- How it works |
| ctrlnum | (OCoLC)1246197189 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1st edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>08340cam a22007697a 4500</leader><controlfield tag="001">ZDB-4-EBA-on1246197189</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu||||||||</controlfield><controlfield tag="008">050321s2021 xx o 000 0 eng </controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">AU@</subfield><subfield code="b">eng</subfield><subfield code="c">AU@</subfield><subfield code="d">TAC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">TOH</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">IEEEE</subfield><subfield code="d">YDX</subfield><subfield code="d">N$T</subfield><subfield code="d">UKAHL</subfield><subfield code="d">EBLCP</subfield><subfield code="d">NLW</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1240381036</subfield><subfield code="a">1241448083</subfield><subfield code="a">1256700310</subfield><subfield code="a">1302698120</subfield><subfield code="a">1355685967</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781838648138</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781838641054</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">183864105X</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781838641054</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1838648135</subfield></datafield><datafield tag="024" ind1="8" ind2=" "><subfield code="a">9781838648138</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1246197189</subfield><subfield code="z">(OCoLC)1240381036</subfield><subfield code="z">(OCoLC)1241448083</subfield><subfield code="z">(OCoLC)1256700310</subfield><subfield code="z">(OCoLC)1302698120</subfield><subfield code="z">(OCoLC)1355685967</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">10163115</subfield><subfield code="b">IEEE</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.S67</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7585</subfield><subfield code="2">23/eng/20230822</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kumar, Vallarapu,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostgreSQL 13 Cookbook /</subfield><subfield code="c">Kumar, Vallarapu.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="b">Packt Publishing,</subfield><subfield code="c">2021.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (344 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-based approach Solve common and not-so-common challenges faced while working to achieve optimal database performance Book Description PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You'll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you'll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you'll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you'll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you'll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases. What you will learn Understand logical and physical backups in Postgres Demonstrate the different types of replication methods possible with PostgreSQL today Set up a high availability cluster that provides seamless automatic failover for applications Secure a PostgreSQL encryption through authentication, authorization, and auditing Analyze the live and historic activity of a PostgreSQL server Understand how to monitor critical services in Postgres 13 Manage maintenance activities and performance tuning of a PostgreSQL cluster Who this book is for This PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design effic ...</subfield></datafield><datafield tag="542" ind1=" " ind2=" "><subfield code="f">Copyright © 2021 Packt Publishing</subfield><subfield code="g">2021</subfield></datafield><datafield tag="550" ind1=" " ind2=" "><subfield code="a">Made available through: Safari, an O'Reilly Media Company.</subfield></datafield><datafield tag="588" ind1=" " ind2=" "><subfield code="a">Online resource; Title from title page (viewed February 26, 2021)</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Intro -- Title Page -- Cover -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Chapter 1: Cluster Management Fundamentals -- Technical requirements -- Installing PostgreSQL 13 using RPMs on CentOS -- Getting ready -- How to do it... -- How it works... -- Initializing a PostgreSQL cluster using initdb -- Getting ready -- How to do it... -- How it works... -- Starting a PostgreSQL cluster using pg_ctl -- Getting ready -- How to do it... -- How it works... -- Clusters in PostgreSQL -- Databases in PostgreSQL -- There's more...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Shutting down a PostgreSQL cluster using different shutdown modes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying a PostgreSQL data directory and its contents -- Getting ready -- How to do it... -- How it works... -- There's more... -- Moving pg_wal to another location -- Getting ready -- How to do it... -- How it works... -- Running the psql client and some psql shortcuts -- Getting ready -- How to do it... -- How it works... -- Running a SQL server using psql -- Getting a list of databases -- Finding the database's size -- Connecting to a database</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Getting the list of schemas in a database -- Getting the list of tables -- Describing a table -- There's more... -- SQLs behind the shortcuts -- Locating the Postgres configuration file -- Getting ready -- How to do it... -- How it works... -- There's more... -- include_dir -- include -- Modifying the location of a postgresql.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- Modifying the postgresql.auto.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enable archiving in PostgreSQL -- Getting ready</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">How to do it... -- How it works... -- There's more... -- Chapter 2: Cluster Management Techniques -- Technical requirements -- Creating and dropping databases -- Getting ready -- How to do it... -- How it works -- There's more -- Locating a database and a table on the file system -- Getting ready -- How to do it... -- How it works... -- Creating a schema in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Checking table and index sizes in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating tablespaces</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Getting ready -- How to do it... -- How it works -- There's more... -- Moving tables to a different tablespace -- Getting ready -- How to do it... -- How it works -- Creating a user in PostgreSQL -- Getting ready -- How to do it... -- How it works -- There's more... -- Dropping a user in PostgreSQL -- Getting ready -- How to do it ... -- How it works ... -- Assigning and revoking a privilege to/from a user or a role -- Getting ready -- How to do it -- How it works -- Creating a group role for role-based segregation -- Getting ready -- How to do it -- How it works</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">PostgreSQL</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86006628</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Databases</subfield><subfield code="x">Design.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Servers.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Databases.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data capture & analysis.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data mining.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Computers</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Computers</subfield><subfield code="x">Database Management</subfield><subfield code="x">Data Mining.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Databases</subfield><subfield code="x">Design</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Safari, an O'Reilly Media Company.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">PostgreSQL 13 Cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCYPGRMWJFVDYxdKYwwGVbq</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="z">1838648135</subfield><subfield code="z">9781838648138</subfield><subfield code="w">(OCoLC)1153293326</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2762120</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="936" ind1=" " ind2=" "><subfield code="a">BATCHLOAD</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">301961181</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">2762120</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH37406755</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL6507012</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-on1246197189 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:30:16Z |
| institution | BVB |
| isbn | 183864105X 9781838641054 |
| language | English |
| oclc_num | 1246197189 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (344 pages) |
| psigel | ZDB-4-EBA |
| publishDate | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Kumar, Vallarapu, author. PostgreSQL 13 Cookbook / Kumar, Vallarapu. 1st edition. Packt Publishing, 2021. 1 online resource (344 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-based approach Solve common and not-so-common challenges faced while working to achieve optimal database performance Book Description PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You'll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you'll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you'll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you'll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you'll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases. What you will learn Understand logical and physical backups in Postgres Demonstrate the different types of replication methods possible with PostgreSQL today Set up a high availability cluster that provides seamless automatic failover for applications Secure a PostgreSQL encryption through authentication, authorization, and auditing Analyze the live and historic activity of a PostgreSQL server Understand how to monitor critical services in Postgres 13 Manage maintenance activities and performance tuning of a PostgreSQL cluster Who this book is for This PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design effic ... Copyright © 2021 Packt Publishing 2021 Made available through: Safari, an O'Reilly Media Company. Online resource; Title from title page (viewed February 26, 2021) Intro -- Title Page -- Cover -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Chapter 1: Cluster Management Fundamentals -- Technical requirements -- Installing PostgreSQL 13 using RPMs on CentOS -- Getting ready -- How to do it... -- How it works... -- Initializing a PostgreSQL cluster using initdb -- Getting ready -- How to do it... -- How it works... -- Starting a PostgreSQL cluster using pg_ctl -- Getting ready -- How to do it... -- How it works... -- Clusters in PostgreSQL -- Databases in PostgreSQL -- There's more... Shutting down a PostgreSQL cluster using different shutdown modes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying a PostgreSQL data directory and its contents -- Getting ready -- How to do it... -- How it works... -- There's more... -- Moving pg_wal to another location -- Getting ready -- How to do it... -- How it works... -- Running the psql client and some psql shortcuts -- Getting ready -- How to do it... -- How it works... -- Running a SQL server using psql -- Getting a list of databases -- Finding the database's size -- Connecting to a database Getting the list of schemas in a database -- Getting the list of tables -- Describing a table -- There's more... -- SQLs behind the shortcuts -- Locating the Postgres configuration file -- Getting ready -- How to do it... -- How it works... -- There's more... -- include_dir -- include -- Modifying the location of a postgresql.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- Modifying the postgresql.auto.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enable archiving in PostgreSQL -- Getting ready How to do it... -- How it works... -- There's more... -- Chapter 2: Cluster Management Techniques -- Technical requirements -- Creating and dropping databases -- Getting ready -- How to do it... -- How it works -- There's more -- Locating a database and a table on the file system -- Getting ready -- How to do it... -- How it works... -- Creating a schema in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Checking table and index sizes in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating tablespaces Getting ready -- How to do it... -- How it works -- There's more... -- Moving tables to a different tablespace -- Getting ready -- How to do it... -- How it works -- Creating a user in PostgreSQL -- Getting ready -- How to do it... -- How it works -- There's more... -- Dropping a user in PostgreSQL -- Getting ready -- How to do it ... -- How it works ... -- Assigning and revoking a privilege to/from a user or a role -- Getting ready -- How to do it -- How it works -- Creating a group role for role-based segregation -- Getting ready -- How to do it -- How it works PostgreSQL SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Databases Design. SQL (Langage de programmation) Bases de données Gestion. Servers. bicssc Databases. bicssc Data capture & analysis. bicssc Data mining. bicssc Computers Data Processing. bisacsh Computers Database Management Data Mining. bisacsh Database management fast Databases Design fast SQL (Computer program language) fast Safari, an O'Reilly Media Company. has work: PostgreSQL 13 Cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCYPGRMWJFVDYxdKYwwGVbq https://id.oclc.org/worldcat/ontology/hasWork Print version: 1838648135 9781838648138 (OCoLC)1153293326 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2762120 Volltext |
| spellingShingle | Kumar, Vallarapu PostgreSQL 13 Cookbook / Intro -- Title Page -- Cover -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Chapter 1: Cluster Management Fundamentals -- Technical requirements -- Installing PostgreSQL 13 using RPMs on CentOS -- Getting ready -- How to do it... -- How it works... -- Initializing a PostgreSQL cluster using initdb -- Getting ready -- How to do it... -- How it works... -- Starting a PostgreSQL cluster using pg_ctl -- Getting ready -- How to do it... -- How it works... -- Clusters in PostgreSQL -- Databases in PostgreSQL -- There's more... Shutting down a PostgreSQL cluster using different shutdown modes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Identifying a PostgreSQL data directory and its contents -- Getting ready -- How to do it... -- How it works... -- There's more... -- Moving pg_wal to another location -- Getting ready -- How to do it... -- How it works... -- Running the psql client and some psql shortcuts -- Getting ready -- How to do it... -- How it works... -- Running a SQL server using psql -- Getting a list of databases -- Finding the database's size -- Connecting to a database Getting the list of schemas in a database -- Getting the list of tables -- Describing a table -- There's more... -- SQLs behind the shortcuts -- Locating the Postgres configuration file -- Getting ready -- How to do it... -- How it works... -- There's more... -- include_dir -- include -- Modifying the location of a postgresql.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- Modifying the postgresql.auto.conf file in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enable archiving in PostgreSQL -- Getting ready How to do it... -- How it works... -- There's more... -- Chapter 2: Cluster Management Techniques -- Technical requirements -- Creating and dropping databases -- Getting ready -- How to do it... -- How it works -- There's more -- Locating a database and a table on the file system -- Getting ready -- How to do it... -- How it works... -- Creating a schema in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Checking table and index sizes in PostgreSQL -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating tablespaces Getting ready -- How to do it... -- How it works -- There's more... -- Moving tables to a different tablespace -- Getting ready -- How to do it... -- How it works -- Creating a user in PostgreSQL -- Getting ready -- How to do it... -- How it works -- There's more... -- Dropping a user in PostgreSQL -- Getting ready -- How to do it ... -- How it works ... -- Assigning and revoking a privilege to/from a user or a role -- Getting ready -- How to do it -- How it works -- Creating a group role for role-based segregation -- Getting ready -- How to do it -- How it works PostgreSQL SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Databases Design. SQL (Langage de programmation) Bases de données Gestion. Servers. bicssc Databases. bicssc Data capture & analysis. bicssc Data mining. bicssc Computers Data Processing. bisacsh Computers Database Management Data Mining. bisacsh Database management fast Databases Design fast SQL (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh86006628 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | PostgreSQL 13 Cookbook / |
| title_auth | PostgreSQL 13 Cookbook / |
| title_exact_search | PostgreSQL 13 Cookbook / |
| title_full | PostgreSQL 13 Cookbook / Kumar, Vallarapu. |
| title_fullStr | PostgreSQL 13 Cookbook / Kumar, Vallarapu. |
| title_full_unstemmed | PostgreSQL 13 Cookbook / Kumar, Vallarapu. |
| title_short | PostgreSQL 13 Cookbook / |
| title_sort | postgresql 13 cookbook |
| topic | PostgreSQL SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Databases Design. SQL (Langage de programmation) Bases de données Gestion. Servers. bicssc Databases. bicssc Data capture & analysis. bicssc Data mining. bicssc Computers Data Processing. bisacsh Computers Database Management Data Mining. bisacsh Database management fast Databases Design fast SQL (Computer program language) fast |
| topic_facet | PostgreSQL SQL (Computer program language) Database management. Databases Design. SQL (Langage de programmation) Bases de données Gestion. Servers. Databases. Data capture & analysis. Data mining. Computers Data Processing. Computers Database Management Data Mining. Database management Databases Design |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2762120 |
| work_keys_str_mv | AT kumarvallarapu postgresql13cookbook AT safarianoreillymediacompany postgresql13cookbook |