Linux-RedHat Installation of PostgreSQL

Tags linux

 

Audience

Staff 

 

Overview

This guide provides step-by-step instructions for installing PostgreSQL on Red Hat Linux. PostgreSQL is a powerful, open-source relational database management system used for handling structured data. The installation process includes verifying system requirements, installing PostgreSQL using package managers, configuring the database, and ensuring secure access. Proper setup of PostgreSQL ensures efficient database management and compatibility with various applications running on a Red Hat environment.

 

Steps for Upgrading/Installing MySQL.

 

System requirements:
Windows Server 2012 R2 Hardware platform that can support Windows Server 2012 R2/Virtual Environment IIS 6 or above

Installing MySQL using IIS Manager:

  1. Logon to the server with administrator rights.
  2. Open IIS Manager
  3. On the left side Locate the server and click it.
  4. On the right side you will see an Icon "Get New Web Platform Components"
  5. When the Program opens you will see a search box on the top right side. Type in the box "MySQL" without the quotes. And press enter.
  6. Locate the version of MySQL you desire to install. For our purposes we are upgrading to the most recent version 8.0.0. Select MySQL 8.0.0 (x64). Click Add. This will install both x86 and x64 versions
  7. Once you have clicked Add you are ready to install. Click Install and the program will download all the required options.
  8. The installation process is complete and now we need to tell the website to use it.
  9. Using a browser of your choice Open the PIWIK site you have created.
  10. Login with administrator access to PIWIK.
  11. On the top right hand corner locate the spoke wheel to access the administrator functions.
  12. On the left bottom side you will see the option for a "System Check". Click that option.
  13. The very first line should identify your MySQL version.

 

Installing MySQL manually:

  1. The first step is to determine the correct MySQL version for your system. This requires checking compatibility for Matomo and Windows Server.

  2. Next go to the MySQL site to download the appropriate package.
  3. Download the MySQL package for IIS.
  4. Extract the package to a new directory on the server following this path: C:\MySQL or use the current directory structure and use the upgrade process.

 

NOTES From Upgrade process:

Beginning configuration step: Preparing authentication plugin change

Creating a temporary user account for connecting with new authentication plugin during the step that updates security settings that runs later on (to avoid updating the root user account at this early stage where intermediate configuration steps might fail)...
Created temporary mysqltempinternal user account to use for updating security settings in a later step.
Ended configuration step: Preparing authentication plugin change

Beginning configuration step: Stopping the server

Setting innodb_fast_shutdown to do a clean shutdown (a full purge and a change buffer merge before shutting down).
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe --defaults-extra-file="C:\Users\JOB112\AppData\Local\Temp\ce7e0d38-319b-4656-8673-ae492d121831.ini" --user=root --default-auth=caching_sha2_password --host=localhost --port=3306 -e"SET GLOBAL innodb_fast_shutdown = 0"...
Process for mysql, with ID 4540, was run successfully and exited with code 0.
Successfully set innodb_fast_shutdown to do a clean shutdown.
Executing mysqladmin shutdown to do a clean shutdown.
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin.exe --defaults-extra-file="C:\Users\JOB112\AppData\Local\Temp\ce7e0d38-319b-4656-8673-ae492d121831.ini" --user=root --default-auth=caching_sha2_password --host=localhost --port=3306 shutdown...
Process for mysqladmin, with ID 5788, was run successfully and exited with code 0.
Successfully performed a clean shutdown.
Stopping MySQL Server instance...
Found Windows service for the server instance. Stopping MySQL service...
MySQL service stopped successfully...
Ended configuration step: Stopping the server

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Starting the server

Attempting to start service MySQL80...
Successfully started service MySQL80.
Waiting until a connection to MySQL Server 8.0.26 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user mysqltempinternal with a password...
Successfully connected to MySQL Server 8.0.26.
Ended configuration step: Starting the server

Beginning configuration step: Applying security settings

Attempting to update security settings.
Deleting temporary user account mysqltempinternal...
Deleted temporary user account mysqltempinternal successfully...
Updated security settings.
Ended configuration step: Applying security settings

Beginning configuration step: Updating the Start menu link

Attempting to verify command-line client shortcut.
Verified command-line client shortcut.
Verified command-line client shortcut.
Ended configuration step: Updating the Start menu link

**********************************************************
mysqlcheck --analyze --all-databases -uroot -p

mysqlcheck --no-defaults --all-databases -uroot -p

mysqlcheck --tls-version -uroot -p

mysqlcheck --no-defaults --all-databases -uroot -p

 

Refrences: 

 

 

Feedback and Concerns:

If you have any feedback regarding this article, please reach out to hsitkb@pitt.edu.  You can also leave a comment below as well. 

Print Article