# Download PostgreSQL for windows, PostgreSQL configuration, and login to the database

1. go to this link: [**https://www.postgresql.org/**](https://www.postgresql.org/) dan klik Download
    
2. ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754532393452/13650a03-f0f3-462e-a98a-4cd1267ca20c.png align="center")
    
    and you will find this page and click on **windows** to install PostgreSQL on windows
    
3. ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754532636081/53c9eb37-9d46-44b1-a3e9-ba3fffc1b10a.png align="center")
    
    click on **Download the installer**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754533519056/645ff939-bd6b-4952-927f-cb111cd204a0.png align="center")
    
4. and choose the highest, that is the latest version
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754533705757/23b0809d-f1c8-456e-a402-845ae26abf18.png align="center")
    
5. after downloading, you can open it.
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534092229/3ccad3f5-1a23-4059-98c0-25b7bdbf3cef.png align="center")
    
6. select the path to save this application
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534351992/0df278c7-24f2-4548-aba5-350a1064a511.png align="center")
    
7. select components for application type
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534405178/703719e6-d6b9-45b1-9307-7bdc55fb736c.png align="center")
    
8. select path for save data application
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534467256/ebd4f632-1a88-4f0a-96d7-b2aeffbf840d.png align="center")
    
9. create a **password** for the default user, this is the default **postgres** user
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534519913/5179ed7e-6eee-4bc8-83a2-18de8221ed57.png align="center")
    
10. continuation of this page, the **default port** of the application
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534548339/bf83b12e-24f0-4a06-9200-b9c660aa706e.png align="center")
    
11. and also select **default** for this page
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534801127/1b198e73-3cab-47fe-b71a-3ee270426692.png align="center")
    
12. wait until it's **finished**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754534858853/a3da9ec2-e0fb-4905-a62d-9bcc11fd8f33.png align="center")
    
13. after downloading, **cancel** that page
    
14. open **environment variables**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754546692726/826ba6ef-d6b7-41f5-b0ea-829cb33a71c2.png align="center")
    
15. click **environment variables**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754546755382/2c590522-e1a3-4517-83bb-0885c7203228.png align="center")
    
16. and click path in **user variable** and also click edit
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754546783519/b8778792-8515-4bc2-87ea-7691a45ad81f.png align="center")
    
17. check number 6 and write path on search in file explorer, don’t forget on this pc and open that file
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754547280020/6c84d874-4294-4a56-85a1-1612ad2a01d3.png align="center")
    
18. and after that open bin folder and copy path in that folder, example: **E:\\Aplikasi\\PostgreSQL\\bin**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754547389512/03806402-6dc7-4504-bcbf-dc3bc892508e.png align="center")
    
19. back to environment variable and paste that path, and also do the same thing in **system variable**
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754547754786/151d3d55-2cf9-4c72-b884-095c63d0e364.png align="center")
    
20. open **Git Bash** and write “psql —version“ for check, When you have connected, the PSQL version will appear
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754549667200/e038d3cd-52e6-428c-974c-6b761b6204c5.png align="center")
    
21. write “psql -U postgres”, this **user default**, that we made at the beginning, and after that insert a password as we made in number 9
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754549704419/fbb9b66f-875a-416f-9542-b86c2a104353.png align="center")
    
22. write “select NOW();” , for try writing a query, to see the current **time**, and write “\\q” for **quit** from DB (database)
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1754549736175/9a64ee99-6ab1-4b35-866d-2188b11ca44d.png align="center")
    

END!!!!!!!!

Hello, ini article pertama saya di blog ini, jika anda tertarik dengan kisah saya, ayo kemari saya akan bercerita lebih banyak di blog ini.