{"id":270,"date":"2023-11-15T16:38:46","date_gmt":"2023-11-15T16:38:46","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?page_id=270"},"modified":"2023-11-23T22:25:56","modified_gmt":"2023-11-23T22:25:56","slug":"postgresql","status":"publish","type":"page","link":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"270\" class=\"elementor elementor-270\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-30c7c83 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"30c7c83\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2911a61\" data-id=\"2911a61\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8ad852b elementor-align-center elementor-widget elementor-widget-breadcrumbs\" data-id=\"8ad852b\" data-element_type=\"widget\" data-widget_type=\"breadcrumbs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-theme-elements.min.css\"><span id=\"breadcrumbs\"><span><span><a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/\">Home<\/a><\/span><\/span><\/span>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d8dba83 elementor-hidden-mobile elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8dba83\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5a48797\" data-id=\"5a48797\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f4c6ccc elementor-grid-1 elementor-posts--thumbnail-left elementor-grid-tablet-1 elementor-grid-mobile-1 elementor-widget elementor-widget-posts\" data-id=\"f4c6ccc\" data-element_type=\"widget\" data-settings=\"{&quot;classic_columns&quot;:&quot;1&quot;,&quot;pagination_type&quot;:&quot;numbers_and_prev_next&quot;,&quot;classic_columns_tablet&quot;:&quot;1&quot;,&quot;classic_columns_mobile&quot;:&quot;1&quot;,&quot;classic_row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:35,&quot;sizes&quot;:[]},&quot;classic_row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;classic_row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"posts.classic\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-posts.min.css\">\t\t<div class=\"elementor-posts-container elementor-posts elementor-posts--skin-classic elementor-grid\">\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-276 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" >\n\t\t\t\tPOSTGRESQL TUTORIALS 9.5.X\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Welcome to the PostgreSQLTutorial.com website! This&nbsp;PostgreSQL tutorial&nbsp;helps you understand PostgreSQL quickly. You will learn PostgreSQL fast through many practical examples. We will show you not only problems but also how to solve them creatively in PostgreSQL. If you are\u2026 You will find all you need to know to get started<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" aria-label=\"Read more about POSTGRESQL TUTORIALS 9.5.X\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-279 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" >\n\t\t\t\tPOSTGRESQL VERSION 9.0 CHEAT SHEET\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>PSQL Magic words:psql -U postgres Some interesting flags (to see all, use&nbsp;-h&nbsp;or&nbsp;&#8211;help&nbsp;depending on your psql version): please go through the below link https:\/\/gist.github.com\/Kartones\/dd3ff5ec5ea238d4c546#file-postgres-cheatsheet-md<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" aria-label=\"Read more about POSTGRESQL VERSION 9.0 CHEAT SHEET\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-281 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" >\n\t\t\t\tPG_CATCHECK-MASTE\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>PG_CATCHECK-MASTE &nbsp;1) Download pg_catcheck-master.zip from below link: https:\/\/github.com\/EnterpriseDB\/pg_catcheck unzip pg_catcheck-master.zip 2) Export below parameters: [root@localhostpg_catcheck-master]# export LD_LIBRARY_PATH=\/opt\/PostgresPlus\/9.3AS\/lib\/ [root@localhostpg_catcheck-master]# export PATH=\/opt\/PostgresPlus\/9.3AS\/bin\/:$PATH [root@localhostpg_catcheck-master]# export PG_CONFIG=\/opt\/PostgresPlus\/9.3AS\/bin\/pg_config 3) In order to avoid error \/usr\/bin\/ld: cannot find -lmemcached collect2: ld returned 1 exit status, copy below library. [root@localhostpg_catcheck-master]# cp \/opt\/PostgresPlus\/9.3AS\/lib\/libmemcached.so.10 \/opt\/PostgresPlus\/9.3AS\/lib\/libmemcached.so 4) Please install below<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" aria-label=\"Read more about PG_CATCHECK-MASTE\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-283 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" >\n\t\t\t\tERROR REPORTING AND LOGGING\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>ERROR REPORTING AND LOGGING 19.8.1. Where To Log log_destination (string) PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr only.<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" aria-label=\"Read more about ERROR REPORTING AND LOGGING\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-285 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" >\n\t\t\t\tPostgreSQL &#8211; Shared Memory and Other Memory usage\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Internals of PostgreSQLSrinivas MaddaliWhen we discuss internals of PostgreSQL we need to discuss about:a. Shared memory usage by the PostgreSQLb. Usage of the sub-systems by the PostgreSQL instancec. Other memory usage fori. Semaphoresii. Light-waited locksiii. Shared and exclusive locksiv. Checkpointingv. Auto vacuumvi. Save-point.vii. Commit Shared Memory purpose is to meet<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" aria-label=\"Read more about PostgreSQL &#8211; Shared Memory and Other Memory usage\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t<div class=\"e-load-more-anchor\" data-page=\"1\" data-max-page=\"2\" data-next-page=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\"><\/div>\n\t\t\t\t<nav class=\"elementor-pagination\" aria-label=\"Pagination\">\n\t\t\t<span class=\"page-numbers prev\">&laquo; Previous<\/span>\n<span aria-current=\"page\" class=\"page-numbers current\"><span class=\"elementor-screen-only\">Page<\/span>1<\/span>\n<a class=\"page-numbers\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\"><span class=\"elementor-screen-only\">Page<\/span>2<\/a>\n<a class=\"page-numbers next\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\">Next &raquo;<\/a>\t\t<\/nav>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e14453a elementor-hidden-desktop elementor-hidden-tablet elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e14453a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-19fad47\" data-id=\"19fad47\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3e56c38 elementor-grid-1 elementor-grid-tablet-1 elementor-grid-mobile-1 elementor-posts--thumbnail-top elementor-widget elementor-widget-posts\" data-id=\"3e56c38\" data-element_type=\"widget\" data-settings=\"{&quot;classic_columns&quot;:&quot;1&quot;,&quot;pagination_type&quot;:&quot;numbers_and_prev_next&quot;,&quot;classic_columns_tablet&quot;:&quot;1&quot;,&quot;classic_columns_mobile&quot;:&quot;1&quot;,&quot;classic_row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:35,&quot;sizes&quot;:[]},&quot;classic_row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;classic_row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"posts.classic\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-posts-container elementor-posts elementor-posts--skin-classic elementor-grid\">\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-276 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" >\n\t\t\t\tPOSTGRESQL TUTORIALS 9.5.X\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Welcome to the PostgreSQLTutorial.com website! This&nbsp;PostgreSQL tutorial&nbsp;helps you understand PostgreSQL quickly. You will learn PostgreSQL fast through many practical examples. We will show you not only problems but also how to solve them creatively in PostgreSQL. If you are\u2026 You will find all you need to know to get started<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-tutorials-9-5-x\/\" aria-label=\"Read more about POSTGRESQL TUTORIALS 9.5.X\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-279 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" >\n\t\t\t\tPOSTGRESQL VERSION 9.0 CHEAT SHEET\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>PSQL Magic words:psql -U postgres Some interesting flags (to see all, use&nbsp;-h&nbsp;or&nbsp;&#8211;help&nbsp;depending on your psql version): please go through the below link https:\/\/gist.github.com\/Kartones\/dd3ff5ec5ea238d4c546#file-postgres-cheatsheet-md<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-version-9-0-cheat-sheet\/\" aria-label=\"Read more about POSTGRESQL VERSION 9.0 CHEAT SHEET\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-281 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" >\n\t\t\t\tPG_CATCHECK-MASTE\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>PG_CATCHECK-MASTE &nbsp;1) Download pg_catcheck-master.zip from below link: https:\/\/github.com\/EnterpriseDB\/pg_catcheck unzip pg_catcheck-master.zip 2) Export below parameters: [root@localhostpg_catcheck-master]# export LD_LIBRARY_PATH=\/opt\/PostgresPlus\/9.3AS\/lib\/ [root@localhostpg_catcheck-master]# export PATH=\/opt\/PostgresPlus\/9.3AS\/bin\/:$PATH [root@localhostpg_catcheck-master]# export PG_CONFIG=\/opt\/PostgresPlus\/9.3AS\/bin\/pg_config 3) In order to avoid error \/usr\/bin\/ld: cannot find -lmemcached collect2: ld returned 1 exit status, copy below library. [root@localhostpg_catcheck-master]# cp \/opt\/PostgresPlus\/9.3AS\/lib\/libmemcached.so.10 \/opt\/PostgresPlus\/9.3AS\/lib\/libmemcached.so 4) Please install below<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/pg_catcheck-maste\/\" aria-label=\"Read more about PG_CATCHECK-MASTE\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-283 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" >\n\t\t\t\tERROR REPORTING AND LOGGING\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>ERROR REPORTING AND LOGGING 19.8.1. Where To Log log_destination (string) PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr only.<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/error-reporting-and-logging\/\" aria-label=\"Read more about ERROR REPORTING AND LOGGING\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-285 post type-post status-publish format-standard has-post-thumbnail hentry category-postgresql\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img decoding=\"async\" width=\"300\" height=\"137\" src=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png\" class=\"attachment-medium size-medium wp-image-277\" alt=\"\" srcset=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql-300x137.png 300w, https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/postgresql.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h3 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" >\n\t\t\t\tPostgreSQL &#8211; Shared Memory and Other Memory usage\t\t\t<\/a>\n\t\t<\/h3>\n\t\t\t\t<div class=\"elementor-post__excerpt\">\n\t\t\t<p>Internals of PostgreSQLSrinivas MaddaliWhen we discuss internals of PostgreSQL we need to discuss about:a. Shared memory usage by the PostgreSQLb. Usage of the sub-systems by the PostgreSQL instancec. Other memory usage fori. Semaphoresii. Light-waited locksiii. Shared and exclusive locksiv. Checkpointingv. Auto vacuumvi. Save-point.vii. Commit Shared Memory purpose is to meet<\/p>\n\t\t<\/div>\n\t\t\n\t\t<a class=\"elementor-post__read-more\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/15\/postgresql-shared-memory-and-other-memory-usage\/\" aria-label=\"Read more about PostgreSQL &#8211; Shared Memory and Other Memory usage\" tabindex=\"-1\" >\n\t\t\t\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t<div class=\"e-load-more-anchor\" data-page=\"1\" data-max-page=\"2\" data-next-page=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\"><\/div>\n\t\t\t\t<nav class=\"elementor-pagination\" aria-label=\"Pagination\">\n\t\t\t<span class=\"page-numbers prev\">&laquo; Previous<\/span>\n<span aria-current=\"page\" class=\"page-numbers current\"><span class=\"elementor-screen-only\">Page<\/span>1<\/span>\n<a class=\"page-numbers\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\"><span class=\"elementor-screen-only\">Page<\/span>2<\/a>\n<a class=\"page-numbers next\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/page\/2\/\">Next &raquo;<\/a>\t\t<\/nav>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-270","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL - Ordba<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL - Ordba\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T22:25:56+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/\",\"name\":\"PostgreSQL - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-15T16:38:46+00:00\",\"dateModified\":\"2023-11-23T22:25:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL - Ordba","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/","og_site_name":"Ordba","article_modified_time":"2023-11-23T22:25:56+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/","name":"PostgreSQL - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-15T16:38:46+00:00","dateModified":"2023-11-23T22:25:56+00:00","breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":13,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/revisions"}],"predecessor-version":[{"id":838,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/pages\/270\/revisions\/838"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}