Skip to main content

Command Palette

Search for a command to run...

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

Updated
2 min read
  1. go to this link: https://www.postgresql.org/ dan klik Download

  2. and you will find this page and click on windows to install PostgreSQL on windows

  3. click on Download the installer

  4. and choose the highest, that is the latest version

  5. after downloading, you can open it.

  6. select the path to save this application

  7. select components for application type

  8. select path for save data application

  9. create a password for the default user, this is the default postgres user

  10. continuation of this page, the default port of the application

  11. and also select default for this page

  12. wait until it's finished

  13. after downloading, cancel that page

  14. open environment variables

  15. click environment variables

  16. and click path in user variable and also click edit

  17. check number 6 and write path on search in file explorer, don’t forget on this pc and open that file

  18. and after that open bin folder and copy path in that folder, example: E:\Aplikasi\PostgreSQL\bin

  19. back to environment variable and paste that path, and also do the same thing in system variable

  20. open Git Bash and write “psql —version“ for check, When you have connected, the PSQL version will appear

  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

  22. write “select NOW();” , for try writing a query, to see the current time, and write “\q” for quit from DB (database)

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.

A
ahmad9mo ago

its very beatiful

1
A

bagus sudah ada penutupnya dengan baik

A

kata kata yg penting di bold

A

tolong judul mewakili isi dari tulisan. misal tutorial download, instalasi dan penggunaan postgreSQL

A

setiap menulis, pilih buat artikel baru bukan blog

A

tolong sub domainnya diganti misal "halim-notes" atau yg lain

More from this blog

The Digital Alchemist's Log

21 posts