[age-website] branch master updated: #311 Updated documentation (#85)

[ak...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

ako pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/age-website.git


The following commit(s) were added to refs/heads/master by this push:
     new 23b3514  #311 Updated documentation (#85)
23b3514 is described below

commit 23b35142204d8fe6343bcafa61976ff388c2d964
Author: Johan511 <69...@users.noreply.github.com>
AuthorDate: Wed Oct 5 11:42:12 2022 +0530

    #311 Updated documentation (#85)
    
    * updated documentation to include steps to follow when using multiple versions of postgres
    
    * updated documentation to add setup procedure for installing multiple versions for postgres
---
 docs/intro/setup.md | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)

diff --git a/docs/intro/setup.md b/docs/intro/setup.md
index 9daf32a..9afcfe2 100644
--- a/docs/intro/setup.md
+++ b/docs/intro/setup.md
@@ -35,6 +35,13 @@ sudo apt-get install build-essential libreadline-dev zlib1g-dev flex bison
 
 ## Installation
 
+Clone the github repo into any directory
+
+Run the pg_config utility and check the version of PostgreSQL, currently only PostgreSQL versions 11 & 12 are supported. If you have any other version of postgres, you will need to install PostgreSQL version 11 & 12. Follow Setting up multiple versions of PostgreSQL
+```console
+pg_config
+```
+
 The build process will attempt to use the first path in the PATH environment variable when installing AGE. If the pg_config path is located there, run the following command in the source code directory of Apache AGE to build and install the extension.
 
 ```console
@@ -47,6 +54,39 @@ If the path to your Postgres installation is not in the PATH variable, add the p
 make PG_CONFIG=/path/to/postgres/bin/pg_config install
 ```
 
+## Setting up multiple versions of PostgreSQL
+
+Install the intended version of PostgreSQL (11 or 12).
+
+Use the pg_config to check if it points to the intended version of PostgreSQL, if it does we will have to PGBINROOT. Open /usr/bin/pg_config in write mode (might require root previllages) and edit the PGBINROOT value
+
+```console
+sudo vi /usr/bin/pg_config
+```
+
+By default PGBINROOT is set to /usr/lib/postsgresql , the directory which contains all the postgres versions. Change this to /usr/lib/postgresql/[intended version of postgres]
+
+Check the PostgreSQL conf file of your PostgreSQL version to figure out which port its running on. 
+The conf file is generally located in /etc/postgresql/[intended version of postgres]/main
+
+```console
+vi /etc/postgresql/11/main/postgresql.conf
+```
+
+Check the PORT the particular version of PostgreSQL runs on by default.
+
+Restart PostgreSQL 
+
+```console
+sudo service postgresql restart
+```
+Change user to postgres connect to the PostgreSQL server
+
+```console
+sudo su - postgres
+psql --port PORT
+```
+
 ## Post Installation
 
 ### Per Installation Instructions