Page Comparison

...

1. Update postgresql.conf file

   • Location: Depending upon the OS and installation option, the location of this file varies. Do a google search to find the location of this file as per your OS and the installation option used.

   • Configuration to change: This file contains multiple options for PostreSQL database settings but we are only interested in listen_addresses property. This variable controls which IPs the server will answer on, not which IPs the server will permit connections to authenticate from.

     Image RemovedImage Added

   • Updated Value: Update the value of the listen_addresses property by replacing localhost with * and ensure that this line is not commented by removing the # symbol before this line. This is the most common mistake done by first-time users. The updated file should look like the image below.

     

   • Save and restart PostgreSQL This is necessary to apply the changes. The simplest way is to restart the PC or look for the restart command as per your OS and installation option.

2. Update pg_hba.conf file

   • Location: Depending upon the OS and installation option, the location of this file varies. Do a Google search to find the location of this file as per your OS and the installation option used.

   • Configuration to change: This file is used to control access at a finer-grained level for which IPs the server will accept logins from for specific databases and users. We are interested in entries corresponding to IPv4 and IPv6 hosts.

     Image RemovedImage Added

   • Updated Value: We need to specify the addresses of the hosts which must be allowed to accessthe database along with the method for user authentication. Add the following entries:

     Code Block
     host all all 0.0.0.0/0 md5 host all all ::/0 md5

     The updated file should look like the image below. Save and restart PostgreSQL to apply the changes.

     

...

server {
          listen 80;
          server_name jira.example.com;

          #Configuration for JIRA (running on port 8080)
          location / {
                        proxy_set_header X-Forwarded-Host $host;
                        proxy_set_header X-Forwarded-Server $host;
                        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                        proxy_pass http://127.0.0.1:8080; 
                }
}

...

...

asfasfd

Image Modified

Sample Jira cluster.properties file to be placed in each Jira local home

...

fhsdg

...

sdg

sdggsdgReverse proxy configuration for Jira Cluster

...

sdgsdg

Jira server configuration file

...

sdgsgSample Jira server configuration file with reverse proxy and context details

...

Reverse proxy configuration files

asfsa

Image Modified

wetwet

...

\uD83D\uDCCB Related articles

...