PostgreSQL 12 Upgrade

Windows Installation

PostgreSQL fresh Install on Windows

1. Go to nexus download InSights_Windows Windows Postgres Package
2. Go to server2/postgresql-12.5-1-windows package
3. Run command "Postgresql-12-DB-SetUp.bat" from server2 file, this will create "data" folder inside postgresql-12.5-1-windows.
4. It will also replace pg_hba.conf and postgresql.conf inside data ,If any server specific changes please do the needed
5. Run command "Postgresql-12-DB-StartUp.bat" to start PostgreSQL database
6. Register PostgreSQL service using following command (make sure that user has Administrator privilege )

...

1. Go to PgAdmin4 folder to and run postgresql-12.5-1-windows\pgsql\pgAdmin 4\bin\ pgAdmin4.exe to start pgAdmin4 utility.

PostgreSQL Upgrade on windows

1. Make sure that existing postgres 9.5 working
2. Take backup of existing database using following command from \postgresql-12.5-1-windows\pgsql\bin\ folder

pg_dump.exe --file "C:\\Insights\\postgresBackUP
\\insights.sql" --host "localhost" --port "5432" --username "postgres" --no-password --verbose --format=c --blobs "insight"
pg_dump.exe --file "C:\\Insights\\postgresBackUP
\\grafana.sql" --host "localhost" --port "5432" --username "postgres" --no-password --verbose --format=c --blobs "grafana"

...

RHEL7/Centos Installation

PostgreSQL fresh Install on RHEL7/Centos

1. Download installation script from RHEL Link .
2. Change permission of script to 777 or 775
3. Execute script ./ insights_postgres12.sh
4. Check status of service using

...

sudo /usr/pgadmin4/bin/setup-web.sh

PostgreSQL Upgrade on RHEL7

1. Make sure that existing postgres 9.5 working
2. Take backup of existing database using following command

...

/usr/pgsql-12/bin/pg_restore --host "localhost" --port "5432" --username "grafana" --no-password --dbname "insight" --verbose "/home/postgresBackup/insights.sql"
/usr/pgsql-12/bin/pg_restore --host "localhost" --port "5432" --username "grafana" --no-password --dbname "grafana" --verbose "/home/postgresBackup/grafana.sql"

Ubuntu Installation

PostgreSQL fresh Install on Ubuntu

1. Download installation script from Ubuntu Script .
2. Change permission of script to 777 or 775
3. Execute script ./insights_postgre12_Ubuntu.sh
4. Check status of service using

...

sudo /usr/pgadmin4/bin/setup-web.sh

PostgreSQL Upgrade on Ubuntu

1. Make sure that existing postgres 9.5 working
2. Take backup of existing database using following command

...