{"id":47382,"date":"2022-05-27T09:06:16","date_gmt":"2022-05-27T09:06:16","guid":{"rendered":"https:\/\/dbtut.com\/?p=47382"},"modified":"2022-05-27T09:17:58","modified_gmt":"2022-05-27T09:17:58","slug":"what-is-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/","title":{"rendered":"What Is PostgreSQL?"},"content":{"rendered":"

In today’s article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.<\/p>\n

PostgreSQL is a database management system that uses the relational model for databases and supports the SQL standard query language.<\/p>\n

PostgreSQL is also a good performing, secure and comprehensive DBMS. We can run it on almost any UNIX or Unix derivative (such as Linux, FreeBSD) operating systems. We can also run it on all Windows systems with NT cores. Of course it is free and open source.<\/p>\n

Why PostgreSQL?<\/h4>\n

PostgreSQL can run on almost any UNIX variant (with the latest stable 34). (True multi-platform support)<\/p>\n

It is designed for high volume transactions.<\/p>\n

It can easily run on multiple processors.<\/p>\n

Since it is not a commercial database, it gives importance to security rather than speed.<\/p>\n

PostgreSQL Architecture<\/h4>\n

\"\"<\/p>\n

Above you can see the schematic of a PostgreSQL application:<\/p>\n

Here you can see many clients connecting to the server in a network environment. For PostgreSQL, it must be a TCP\/IP network – local area network or internet.<\/p>\n

Each client connects to a master database server process (represented here as postmaster), which creates a new server process to specifically service access requests from that client.<\/p>\n

PostgreSQL’s client-server architecture helps divide the workforce. We can use a server machine organized to hold and access large amounts of data as a secure data store.<\/p>\n

Advanced graphical applications can be developed for clients. Alternatively, web-based applications can also handle your client-side operations.<\/p>\n

The server side of PostgreSQL consists of a UNIX “deamon” named postmaster and several UNIX processes called backends.<\/p>\n

The postmaster provides coordination between backends and communication between backends and clients. A separate backend job runs for each client.<\/p>\n

I hope it will be useful for you. See you in my other articles.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In today’s article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture. PostgreSQL is a database management system that uses the relational model for databases and supports the SQL standard query language. PostgreSQL is also a good performing, secure and comprehensive DBMS. We can run it on almost any …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":3068,"featured_media":47384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-47382","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nWhat Is PostgreSQL? - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Is PostgreSQL? - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-27T09:06:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-27T09:17:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"804\" \/>\n\t<meta property=\"og:image:height\" content=\"353\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Melek Durdu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melek Durdu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\"},\"author\":{\"name\":\"Melek Durdu\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b\"},\"headline\":\"What Is PostgreSQL?\",\"datePublished\":\"2022-05-27T09:06:16+00:00\",\"dateModified\":\"2022-05-27T09:17:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\"},\"wordCount\":298,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\",\"name\":\"What Is PostgreSQL? - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg\",\"datePublished\":\"2022-05-27T09:06:16+00:00\",\"dateModified\":\"2022-05-27T09:17:58+00:00\",\"description\":\"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg\",\"width\":804,\"height\":353},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Is PostgreSQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b\",\"name\":\"Melek Durdu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"caption\":\"Melek Durdu\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What Is PostgreSQL? - Database Tutorials","description":"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"What Is PostgreSQL? - Database Tutorials","og_description":"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.","og_url":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2022-05-27T09:06:16+00:00","article_modified_time":"2022-05-27T09:17:58+00:00","og_image":[{"width":804,"height":353,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg","type":"image\/jpeg"}],"author":"Melek Durdu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Melek Durdu","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/"},"author":{"name":"Melek Durdu","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b"},"headline":"What Is PostgreSQL?","datePublished":"2022-05-27T09:06:16+00:00","dateModified":"2022-05-27T09:17:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/"},"wordCount":298,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/","name":"What Is PostgreSQL? - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg","datePublished":"2022-05-27T09:06:16+00:00","dateModified":"2022-05-27T09:17:58+00:00","description":"In today's article, I will talk about What Is PostgreSQL?, why we should use PostgreSQL and its architecture.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/05\/Ekran-Alintisi-19.jpg","width":804,"height":353},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/05\/27\/what-is-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What Is PostgreSQL?"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b","name":"Melek Durdu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","caption":"Melek Durdu"},"url":"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/47382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/3068"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=47382"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/47382\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/47384"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=47382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=47382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=47382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}