Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| postgresql_installation [2020/01/27 10:18] – andonovj | postgresql_installation [2021/12/10 17:47] (current) – [Install the Repositories] andonovj | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| =====Overview===== | =====Overview===== | ||
| PostegreSQL is open source database offered under the license of GPL and is supported by the community. The installation of postegresql is rather simple. | PostegreSQL is open source database offered under the license of GPL and is supported by the community. The installation of postegresql is rather simple. | ||
| - | ====Installation==== | + | |
| + | =====Installation===== | ||
| Installation is composed by 3 steps: | Installation is composed by 3 steps: | ||
| Line 11: | Line 12: | ||
| The configuration is done afterwards. | The configuration is done afterwards. | ||
| - | ===Install the Repositories=== | + | ====Install the Repositories==== |
| <sxh bash> | <sxh bash> | ||
| - | [root@postegresqlmaster ~]# yum install https:// | + | [root@postegresqlmaster ~]# yum install https:// |
| Loaded plugins: fastestmirror | Loaded plugins: fastestmirror | ||
| Setting up Install Process | Setting up Install Process | ||
| Line 61: | Line 62: | ||
| - | ===Install the packages=== | + | ====Install the packages==== |
| <sxh bash> | <sxh bash> | ||
| [root@postegresqlmaster ~]# yum install postgresql96 | [root@postegresqlmaster ~]# yum install postgresql96 | ||
| Line 168: | Line 169: | ||
| - | ====Configuration==== | + | =====Configuration===== |
| Configuration of the server is initially done as follows: | Configuration of the server is initially done as follows: | ||
| - | ===Server Configuration=== | + | ====Server Configuration==== |
| For Linux 6: | For Linux 6: | ||
| <sxh bash> | <sxh bash> | ||
| Line 195: | Line 196: | ||
| Initializing database ... OK | Initializing database ... OK | ||
| </ | </ | ||
| + | |||
| + | Example for 12: | ||
| + | |||
| + | < | ||
| + | yum install -y https:// | ||
| + | yum install -y postgresql12-server | ||
| + | yum install -y postgresql12-contrib | ||
| + | / | ||
| + | </ | ||
| + | |||
| + | |||
| ===Initial connection and Password management=== | ===Initial connection and Password management=== | ||
| In order to log in, you have to set the password initially as follows: | In order to log in, you have to set the password initially as follows: | ||
| Line 252: | Line 264: | ||
| Where the fields stands for: | Where the fields stands for: | ||
| - | | + | |
| - | | + | |
| - | | + | |
| - | | + | |
| - | | + | |
| - | | + | |