search

CubeStatistica / Professional-Training-for-Data-Science-C1

Online-Professional-Training-for-Data-Science-Using-R (OPTDSUR) Professional-Training-for-Data-Science-C1
0 stars 1 forks source link

Week 4: Installation of PostgreSQL #36

Open Zobia12 opened 2 years ago

Zobia12 commented 2 years ago

Little intro about PostgreSQL Many DBMS (Database Management Systems) were created to make the task easier for users to manage their databases like MySQL, PostgreSQL, MongoDB etc. Where the most advance version of database found is PostgreSQL now a days. It is object-based relational DBMS that requires execution of complex queries, data analysis and data warehousing.

STEPS FOR INSTALLING POSTGRESQL:

METHOD 1: INSTALLING USING WINDOWS:

  1. Go to link https://www.postgresql.org/.
    Image

  2. Here in image you can see the download option, Image

  3. You can download Interactive Installer by EDB Click on download the installer, highlighted by blue. Image

  4. Download According to your latest machine requirement. Image

  5. Open exe file. Once you Download PostgreSQL, open the downloaded exe and Click next on the install welcome screen. Image

  6. Update location. Change the Installation directory if required, else leave it to default Click Next Image

  7. Select components. You may choose the components you want to install in your system. You may uncheck Stack Builder Click Next Image

  8. Check data location. You may change the data location Click Next Image

  9. Enter password. Enter super user password. Make a note of it Click Next Image

  10. Check port option. Leave the port number default. Click Next Image

  11. Check summary. Check the pre-installation summary: Click Next Image

  12. Ready to install. Click the next button. Image

  13. Check stack builder prompt. Once install is complete you will see the Stack Builder prompt Uncheck that option. We will use Stack Builder in more advance tutorials Click Finish Image

  14. Launch PostgreSQL. To launch PostgreSQL go to Start Menu and search pgAdmin4 Image

  15. Check pgAdmin( its a graphical tool for managing and developing your databases). You will see pgAdmin homepage Image

  16. Find PostgreSQL 10. Click on Servers > PostgreSQL 10 in the left tree. Image

  17. Enter password. Enter super user password set during installation, Click OK. Image

  18. Check Dashboard. You will see the Dashboard Image

CONGRATULATIONS That’s it to PostgreSQL installation. Click on it.

Zobia12 commented 2 years ago