{"id":178,"date":"2017-11-28T11:03:20","date_gmt":"2017-11-28T11:03:20","guid":{"rendered":"https:\/\/blinksql.com\/?p=178"},"modified":"2017-11-28T11:03:20","modified_gmt":"2017-11-28T11:03:20","slug":"importnat-parameters-in-postgresql-conf-file","status":"publish","type":"post","link":"https:\/\/blinksql.com\/?p=178","title":{"rendered":"Importnat Parameters in postgresql.conf file"},"content":{"rendered":"

listen_addresses (string)
\n<\/strong>
\n-> Specifies the TCP\/IP address(es) on which the server is to listen for connections from client applications.
\n-> The special entry ‘*’ corresponds to all available IP interfaces.
\n-> The entry 0.0.0.0 allows listening for all IPv4 addresses and :: allows listening for all IPv6 addresses.
\n-> The default value is localhost<\/p>\n

\"connection-1\"<\/p>\n

port (integer):<\/strong>
\n-> The TCP port the server listens on; 5432 by default.
\n-> The same port number is used for all IP addresses the server listens on. This parameter can only be set at server start.<\/p>\n

\"connection-2\"<\/p>\n

max_connections (integer)<\/strong>
\n-> Determines the maximum number of concurrent connections to the database server.
\n-> The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb).<\/p>\n

\"Connection-3\"<\/p>\n

shared_buffers (integer)<\/strong>
\n-> Sets the amount of memory the database server uses for shared memory buffers. The default is typically 128 megabytes (128MB), but might be less if your kernel settings will not support it.
\n-> A dedicated database server with 1GB or more of RAM, a reasonable starting value for shared_buffers is 25% of the memory in your system.
\n\"Connection-4\"<\/p>\n

log_destination (string)
\n<\/strong>
\n-> PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog.
\n-> Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr only.<\/p>\n

log_directory (string):<\/strong>
\n-> When logging_collector is enabled, this parameter determines the directory in which log files will be created.
\n-> It can be specified as an absolute path, or relative to the cluster data directory.
\n-> This parameter can only be set in the postgresql.conf file or on the server command line. The default is pg_log.<\/p>\n

log_filename (string):<\/strong>
\n-> When logging_collector is enabled, this parameter sets the file names of the created log files.
\n-> The default is postgresql-%Y-%m-%d_%H%M%S.log.
\n-> To get the log file name with the day like this ‘postgresql-Wed.log’ then
\nlog_filename = ‘postgresql-%a.log’
\n<\/strong>
\n\"Error_log\"<\/p>\n

log_truncate_on_rotation (boolean)<\/strong>
\n-> When logging_collector is enabled, this parameter will cause PostgreSQL to truncate (overwrite), rather than append to, any existing log file of the same name
\nlog_truncate_on_rotation = on <\/strong>
\n\"error_log1\"<\/p>\n","protected":false},"excerpt":{"rendered":"

listen_addresses (string) -> Specifies the TCP\/IP address(es) on which the server is to listen for connections from client applications. -> The special entry ‘*’ corresponds to all available IP interfaces.…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":""},"categories":[1],"tags":[],"yoast_head":"\nImportnat Parameters in postgresql.conf file - Blink SQL<\/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:\/\/blinksql.com\/?p=178\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importnat Parameters in postgresql.conf file - Blink SQL\" \/>\n<meta property=\"og:description\" content=\"listen_addresses (string) -> Specifies the TCP\/IP address(es) on which the server is to listen for connections from client applications. -> The special entry ‘*’ corresponds to all available IP interfaces.…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blinksql.com\/?p=178\" \/>\n<meta property=\"og:site_name\" content=\"Blink SQL\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-28T11:03:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blinksql.com\/wp-content\/uploads\/2017\/11\/connection-1.png\" \/>\n<meta name=\"author\" content=\"Hannie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@harika_sanaka\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hannie\" \/>\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:\/\/blinksql.com\/?p=178#article\",\"isPartOf\":{\"@id\":\"https:\/\/blinksql.com\/?p=178\"},\"author\":{\"name\":\"Hannie\",\"@id\":\"https:\/\/blinksql.com\/#\/schema\/person\/f04b99304f59e14956e768e764d2afd4\"},\"headline\":\"Importnat Parameters in postgresql.conf file\",\"datePublished\":\"2017-11-28T11:03:20+00:00\",\"dateModified\":\"2017-11-28T11:03:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blinksql.com\/?p=178\"},\"wordCount\":401,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blinksql.com\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blinksql.com\/?p=178#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blinksql.com\/?p=178\",\"url\":\"https:\/\/blinksql.com\/?p=178\",\"name\":\"Importnat Parameters in postgresql.conf file - Blink SQL\",\"isPartOf\":{\"@id\":\"https:\/\/blinksql.com\/#website\"},\"datePublished\":\"2017-11-28T11:03:20+00:00\",\"dateModified\":\"2017-11-28T11:03:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blinksql.com\/?p=178#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blinksql.com\/?p=178\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blinksql.com\/?p=178#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blinksql.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importnat Parameters in postgresql.conf file\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blinksql.com\/#website\",\"url\":\"https:\/\/blinksql.com\/\",\"name\":\"Blink SQL\",\"description\":\" Thinking SQL\",\"publisher\":{\"@id\":\"https:\/\/blinksql.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blinksql.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blinksql.com\/#organization\",\"name\":\"Blink SQL\",\"url\":\"https:\/\/blinksql.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blinksql.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png\",\"contentUrl\":\"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png\",\"width\":280,\"height\":172,\"caption\":\"Blink SQL\"},\"image\":{\"@id\":\"https:\/\/blinksql.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/blinksql.com\/#\/schema\/person\/f04b99304f59e14956e768e764d2afd4\",\"name\":\"Hannie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blinksql.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&d=mm&r=g\",\"caption\":\"Hannie\"},\"sameAs\":[\"http:\/\/blinksql.com\",\"https:\/\/twitter.com\/harika_sanaka\"],\"url\":\"https:\/\/blinksql.com\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importnat Parameters in postgresql.conf file - Blink SQL","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:\/\/blinksql.com\/?p=178","og_locale":"en_US","og_type":"article","og_title":"Importnat Parameters in postgresql.conf file - Blink SQL","og_description":"listen_addresses (string) -> Specifies the TCP\/IP address(es) on which the server is to listen for connections from client applications. -> The special entry ‘*’ corresponds to all available IP interfaces.…","og_url":"https:\/\/blinksql.com\/?p=178","og_site_name":"Blink SQL","article_published_time":"2017-11-28T11:03:20+00:00","og_image":[{"url":"https:\/\/blinksql.com\/wp-content\/uploads\/2017\/11\/connection-1.png"}],"author":"Hannie","twitter_card":"summary_large_image","twitter_creator":"@harika_sanaka","twitter_misc":{"Written by":"Hannie","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blinksql.com\/?p=178#article","isPartOf":{"@id":"https:\/\/blinksql.com\/?p=178"},"author":{"name":"Hannie","@id":"https:\/\/blinksql.com\/#\/schema\/person\/f04b99304f59e14956e768e764d2afd4"},"headline":"Importnat Parameters in postgresql.conf file","datePublished":"2017-11-28T11:03:20+00:00","dateModified":"2017-11-28T11:03:20+00:00","mainEntityOfPage":{"@id":"https:\/\/blinksql.com\/?p=178"},"wordCount":401,"commentCount":0,"publisher":{"@id":"https:\/\/blinksql.com\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blinksql.com\/?p=178#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blinksql.com\/?p=178","url":"https:\/\/blinksql.com\/?p=178","name":"Importnat Parameters in postgresql.conf file - Blink SQL","isPartOf":{"@id":"https:\/\/blinksql.com\/#website"},"datePublished":"2017-11-28T11:03:20+00:00","dateModified":"2017-11-28T11:03:20+00:00","breadcrumb":{"@id":"https:\/\/blinksql.com\/?p=178#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blinksql.com\/?p=178"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blinksql.com\/?p=178#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blinksql.com\/"},{"@type":"ListItem","position":2,"name":"Importnat Parameters in postgresql.conf file"}]},{"@type":"WebSite","@id":"https:\/\/blinksql.com\/#website","url":"https:\/\/blinksql.com\/","name":"Blink SQL","description":" Thinking SQL","publisher":{"@id":"https:\/\/blinksql.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blinksql.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blinksql.com\/#organization","name":"Blink SQL","url":"https:\/\/blinksql.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blinksql.com\/#\/schema\/logo\/image\/","url":"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png","contentUrl":"https:\/\/blinksql.com\/wp-content\/uploads\/2022\/11\/cropped-BlinkSQL-removebg.png","width":280,"height":172,"caption":"Blink SQL"},"image":{"@id":"https:\/\/blinksql.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blinksql.com\/#\/schema\/person\/f04b99304f59e14956e768e764d2afd4","name":"Hannie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blinksql.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5876b3497d2c2eb98256b7c183220c1?s=96&d=mm&r=g","caption":"Hannie"},"sameAs":["http:\/\/blinksql.com","https:\/\/twitter.com\/harika_sanaka"],"url":"https:\/\/blinksql.com\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/posts\/178"}],"collection":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":0,"href":"https:\/\/blinksql.com\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blinksql.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}