{"id":9501,"date":"2016-12-08T20:20:04","date_gmt":"2016-12-08T19:20:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/"},"modified":"2023-06-08T16:14:49","modified_gmt":"2023-06-08T14:14:49","slug":"installing-postgresql-9-6-1-with-enterprisedb-installer","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/","title":{"rendered":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here<\/a>.
\nIn this blog we are going to install PostgreSQL using edb installer. The installation is done using a graphical tool. A user with root privileges must be used otherwise we will get an error. Indeed the default installation creates the systemd service which need root privileges. For example using the user postgres for installation
\n
\n[postgres@pgserver1 96]$ chmod +x postgresql-9.6.1-1-linux-x64.run
\n[postgres@pgserver1 96]$<\/code><\/p>\n


\n<\/code><\/p>\n

[postgres@pgserver1 96]$ .\/postgresql-9.6.1-1-linux-x64.run
\n<\/code>
\n\"install1\"<\/a>
\nAn alternative is to launch the installer with the option “–extract-only” which does not require root (but then we do not get the service)<\/p>\n

Now logged as root, let\u2019s start
\n
\n[root@pgserver1 96]# .\/postgresql-9.6.1-1-linux-x64.run
\n<\/code>
\n\"install2\"<\/a>
\nClick on Next
\n\"install3\"<\/a>
\nSpecify PGHOME
\n\"install4\"<\/a>
\nSpecify the PGDATA
\n\"install5\"<\/a>
\nSpecify the password for user postgres
\n\"install6\"<\/a>
\nThe default port is 5432
\n\"install7\"<\/a>
\nChoose your Locale
\n\"install8\"<\/a>
\nAnd launch installation process
\n\"install9\"<\/a>
\n\"install10\"<\/a>
\nOnce installation done we can verify that PostgreSQL is running
\n
\n[postgres@pgserver1 ~]$ ps -ef | grep postgres
\nroot 3135 976 0 09:53 ? 00:00:00 sshd: postgres [priv]
\npostgres 3140 3135 0 09:54 ? 00:00:00 sshd: postgres@pts\/0
\npostgres 3142 3140 0 09:54 pts\/0 00:00:00 -bash
\nroot 3657 976 0 09:55 ? 00:00:00 sshd: postgres [priv]
\npostgres 3661 3657 0 09:55 ? 00:00:00 sshd: postgres@pts\/2
\npostgres 3664 3661 0 09:55 pts\/2 00:00:00 -bash
\npostgres 6255 1 0 10:23 ? 00:00:00 \/u01\/app\/PostgreSQL\/9.6\/bin\/postgres -D \/u01\/app\/PostgreSQL\/9.6\/data
\npostgres 6256 6255 0 10:23 ? 00:00:00 postgres: logger process
\npostgres 6258 6255 0 10:23 ? 00:00:00 postgres: checkpointer process
\npostgres 6259 6255 0 10:23 ? 00:00:00 postgres: writer process
\npostgres 6260 6255 0 10:23 ? 00:00:00 postgres: wal writer process
\npostgres 6261 6255 0 10:23 ? 00:00:00 postgres: autovacuum launcher process
\npostgres 6262 6255 0 10:23 ? 00:00:00 postgres: stats collector process
\npostgres 6332 3664 0 10:26 pts\/2 00:00:00 ps -ef
\npostgres 6333 3664 0 10:26 pts\/2 00:00:00 grep --color=auto postgres
\n[postgres@pgserver1 ~]$
\n<\/code>
\nA file pg_env.sh<\/span> is created during installation and can be used to setup all variables we need for the connection
\n
\n[postgres@pgserver1 9.6]$ pwd
\n\/u01\/app\/PostgreSQL\/9.6
\n[postgres@pgserver1 9.6]$ cp pg_env.sh \/home\/postgres\/
\n[postgres@pgserver1 9.6]$ cd
\n[postgres@pgserver1 ~]$
\n<\/code>
\n
\n[postgres@pgserver1 ~]$ chmod +x pg_env.sh
\n[postgres@pgserver1 ~]$ . .\/pg_env.sh
\n[postgres@pgserver1 ~]$ env | grep PG
\nPGPORT=5432
\nPGUSER=postgres
\nPGDATABASE=postgres
\nPGLOCALEDIR=\/u01\/app\/PostgreSQL\/9.6\/share\/locale
\nPGDATA=\/u01\/app\/PostgreSQL\/9.6\/data
\n[postgres@pgserver1 ~]$
\n<\/code>
\nAnd now we can connect
\n
\n[postgres@pgserver1 ~]$ psql
\nPassword:
\npsql.bin (9.6.1)
\nType \"help\" for help.<\/code><\/p>\n


\n<\/code><\/p>\n

postgres=#
\n<\/code><\/p>\n

We can see that installation of PostgreSQL edb 9.6 is very easy.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here. In this blog we are going to install PostgreSQL using edb installer. The installation is done using a graphical tool. A […]<\/p>\n","protected":false},"author":27,"featured_media":9512,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[292,1002],"type_dbi":[],"class_list":["post-9501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-entreprisedb","tag-postgresql-9-6"],"acf":[],"yoast_head":"\nInstalling PostgreSQL 9.6.1 with EnterpriseDB Installer - dbi Blog<\/title>\n<meta name=\"description\" content=\"postgreSQL 9.6, entreprisedb\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer\" \/>\n<meta property=\"og:description\" content=\"postgreSQL 9.6, entreprisedb\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-08T19:20:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:14:49+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"426\" \/>\n\t<meta property=\"og:image:height\" content=\"185\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer\",\"datePublished\":\"2016-12-08T19:20:04+00:00\",\"dateModified\":\"2023-06-08T14:14:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\"},\"wordCount\":196,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png\",\"keywords\":[\"EntrepriseDB\",\"PostgreSQL 9.6\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\",\"name\":\"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png\",\"datePublished\":\"2016-12-08T19:20:04+00:00\",\"dateModified\":\"2023-06-08T14:14:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"postgreSQL 9.6, entreprisedb\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png\",\"width\":426,\"height\":185},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer - dbi Blog","description":"postgreSQL 9.6, entreprisedb","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:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/","og_locale":"en_US","og_type":"article","og_title":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer","og_description":"postgreSQL 9.6, entreprisedb","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/","og_site_name":"dbi Blog","article_published_time":"2016-12-08T19:20:04+00:00","article_modified_time":"2023-06-08T14:14:49+00:00","og_image":[{"width":426,"height":185,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer","datePublished":"2016-12-08T19:20:04+00:00","dateModified":"2023-06-08T14:14:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/"},"wordCount":196,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png","keywords":["EntrepriseDB","PostgreSQL 9.6"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/","name":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png","datePublished":"2016-12-08T19:20:04+00:00","dateModified":"2023-06-08T14:14:49+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"postgreSQL 9.6, entreprisedb","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/install1-1.png","width":426,"height":185},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-postgresql-9-6-1-with-enterprisedb-installer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing PostgreSQL 9.6.1 with EnterpriseDB Installer"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9501"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9501\/revisions"}],"predecessor-version":[{"id":25686,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9501\/revisions\/25686"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9512"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9501"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}