{"id":4654,"date":"2025-06-05T06:34:01","date_gmt":"2025-06-05T06:34:01","guid":{"rendered":"https:\/\/jaldi.store\/?p=4654"},"modified":"2026-08-27T11:08:38","modified_gmt":"2026-08-27T11:08:38","slug":"postgresql-installation-guide-for-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/postgresql-installation-guide-for-adempiere-retail\/","title":{"rendered":"PostgreSQL Installation Guide for Adempiere Retail"},"content":{"rendered":"\n

VERSION 9.4.4 <\/strong><\/h2>\n\n\n\n

Introduction :<\/strong><\/h2>\n\n\n\n

Here we will discuss about PostgreSQL and methodology to setup the server and post-server configuration<\/p>\n\n\n\n

along with PostgreSQL configuration will understand the connection between Database and the terminologies <\/p>\n\n\n\n

User Access :<\/strong><\/h2>\n\n\n\n

Bellow users can have an option to access the installation steps<\/p>\n\n\n\n

    \n
  • IT – Admin<\/li>\n\n\n\n
  • system administrator<\/li>\n\n\n\n
  • Tenth Planet Technologies system administrator<\/li>\n<\/ul>\n\n\n\n

    Pre – Requisite<\/strong> :<\/h2>\n\n\n\n

    System Requirements (recommended) :<\/p>\n\n\n\n

    Pre<\/strong> installed Ubuntu version<\/strong><\/h3>\n\n\n\n

    8 GB of RAM <\/strong><\/h3>\n\n\n\n

    500 GB of HDD<\/strong><\/h3>\n\n\n\n

    1 GHz processor<\/strong><\/h3>\n\n\n\n

    Business Rule :<\/strong><\/h2>\n\n\n\n

    Step – 1 :<\/strong> Cautious about PostgreSQL version<\/p>\n\n\n\n

    Step – 2 :<\/strong> Cautious about PostgreSQL environment<\/p>\n\n\n\n

    Step – 3 :<\/strong> Need to provide Required information while setting PostgreSQL environment<\/p>\n\n\n\n

    Step – 4 : <\/strong>Ensure PostgreSQL client and server working fine<\/p>\n\n\n\n

    Installation steps :<\/strong><\/h2>\n\n\n\n

    Steps to be followed<\/strong><\/h3>\n\n\n\n

    Step – 1 : <\/strong>Download PostgreSQL server<\/p>\n\n\n\n

    Step – 2 : <\/strong>Extract PostgreSQL as Executable format<\/p>\n\n\n\n

    Step – 3 : <\/strong>Configure Required information<\/p>\n\n\n\n

    Step – 4 : <\/strong>pg_hba.conf configuration<\/p>\n\n\n\n

    Step – 5 : <\/strong>Modify PostgreSQL.conf file<\/p>\n\n\n\n

    Step – 6 : <\/strong>Verify PostgreSQL configuration<\/p>\n\n\n\n

    Step – 7 : <\/strong>PG-Admin installation<\/p>\n\n\n\n

    Step – 1 : Download PostgreSQL server <\/strong><\/h2>\n\n\n\n
    \"Tenthplanet<\/figure>\n\n\n\n

    Picture for “selecting packages for configuration “<\/strong><\/h3>\n\n\n\n
    \"Tenthplanet<\/figure>\n\n\n\n

    Need to copy the package Repository and configuration<\/strong><\/h3>\n\n\n\n
      \n
    • Create the file repository configuration:<\/strong><\/li>\n<\/ul>\n\n\n\n

      (<\/strong> sudo sh -c ‘echo “deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)<\/p>\n\n\n\n

      -pgdg main” >\/etc\/apt\/sources.list.d\/pgdg.list’ )<\/strong> — single line command<\/p>\n\n\n\n

        \n
      • Import the repository signing key:<\/strong><\/li>\n<\/ul>\n\n\n\n

        (<\/strong> wget –quiet -O – https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo apt-key add – )<\/strong><\/p>\n\n\n\n

          \n
        • Update the Packages list :<\/strong><\/li>\n<\/ul>\n\n\n\n

          (<\/strong> sudo apt-get update )<\/strong><\/p>\n\n\n\n

          picture for ” execute PostgreSQL – 9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Step – 2 : Extract PostgreSQL as Executable format<\/strong><\/h2>\n\n\n\n

          picture for ” execute PostgreSQL – 9.4.4-1<\/strong> “<\/h3>\n\n\n\n
          \"Tenthplanet<\/figure>\n\n\n\n

          Step – 3 : Configure Required information<\/strong><\/h2>\n\n\n\n

          picture for ” configure PostgreSQL – 9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL – 9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configure PostgreSQL -9.4.4-1 “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Step – 4 : pg_hba.conf configuration<\/strong><\/h2>\n\n\n\n

          picture for ” configure PostgreSQL – 9.4.4-1 “<\/strong><\/h3>\n\n\n\n

          Need to set the PostgreSQL environment with ROOT ACCESS USING NAUTILUS<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Need to OPEN \/opt\/PostgreSQL\/9.4\/data then double click open on pg_hba.conf<\/strong><\/h3>\n\n\n\n

          picture for ” moved PostgreSQL into OPT Directory “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” pg_hba.conf configuration “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” modify the IPV4 connection”<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” modified ipv4 connection for local host “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Step – 5 : Modify PostgreSQL.conf file<\/strong><\/h2>\n\n\n\n

          picture for ” Modify PostgreSQL.conf file “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” verified max connection in PostgreSQL.conf file “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” configured max connection in PostgreSQL.conf file ” <\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” verified shared buffer memory ( it should be above 100)<\/strong> “<\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” Restarted PostgreSQL after made a configuration “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          In Ubuntu 16.04 , when system gets booted PostgreSQL Doesn’t start automatically .<\/p>\n\n\n\n

          Need to set PostgreSQL , to Do start automatically when system gets booted !<\/p>\n\n\n\n

          Hence we added rc.local file for PostgreSQL automation<\/p>\n\n\n\n

          Picture for ” selected rc.local file “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” provided privileges to rc.local file “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for ” rc.local file moved into etc directory “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          step – 6 : Verify PostgreSQL configuration<\/strong><\/h2>\n\n\n\n

          picture for ” verified PostgreSQL version “<\/strong><\/h3>\n\n\n\n

          Need to open rc.local file go to – ” \/etc\/init.d\/PostgreSQL – version “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          NOTE : Need to Restart the system <\/strong><\/h2>\n\n\n\n

          Step – 7 : PG-Admin installation<\/strong><\/p>\n\n\n\n

          picture for ” install pg-admin 3″<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Picture for verified ” Pg-admin installation “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          picture for verified ” pg-admin 3 in desktop “<\/strong><\/h3>\n\n\n\n
          \"Tenthplanet-ADempiere-Installation<\/figure>\n\n\n\n

          Standard operating Procedure (SOP) :<\/strong><\/h2>\n\n\n\n
            \n
          • Need to Follow the installation Guide if anything has to do <\/li>\n\n\n\n
          • Follow the structure format of PostgreSQL Installation<\/li>\n\n\n\n
          • Have a Communication with TPT Administrator for clarification<\/li>\n\n\n\n
          • Should Prohibit others to modify ” PostgreSQL Installation “<\/li>\n\n\n\n
          • Keep confidential of system configurations<\/li>\n<\/ul>\n\n\n\n

            FAQ :<\/strong><\/h2>\n\n\n\n
              \n
            1. what if pg-admin not installed properly ?<\/li>\n<\/ol>\n\n\n\n

              verify the ” path location of pg-admin <\/strong>” – \/usr\/lib\/pg-admin.<\/p>\n","protected":false},"excerpt":{"rendered":"

              VERSION 9.4.4 Introduction : Here we will discuss about PostgreSQL and methodology to setup the server and post-server configuration along […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,83],"tags":[],"class_list":["post-4654","post","type-post","status-publish","format-standard","hentry","category-installation","category-adempiere-retail"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/4654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=4654"}],"version-history":[{"count":10,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/4654\/revisions"}],"predecessor-version":[{"id":26165,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/4654\/revisions\/26165"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=4654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=4654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=4654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}