Это видео недоступно.
Сожалеем об этом.

How to Install PostgreSQL & pgAdmin 4 on Windows 10

Поделиться
HTML-код
  • Опубликовано: 14 авг 2024
  • The PostgreSQL installers created by EnterpriseDB are designed to make it quick and simple to install PostgreSQL on your computer. The installer provides:
     a distribution-independent PostgreSQL installation.
     the popular open-source PostgreSQL administration tool, pgAdmin.
     the StackBuilder package manager (used to download and install drivers, tools
    and applications to complement your PostgreSQL installation).
    The sections that follow provide information about using the PostgreSQL 9.6/ PostgreSQL 10 installer:
     How to satisfy hardware requirements and software prerequisites before installing
    PostgreSQL.
     Step-by-step instructions explaining the installation options available with the
    setup wizard.
     How to use Stack Builder to install modules that provide enhanced functionality
    for PostgreSQL 9.6/ PostgreSQL 10.
    ★★★Top Online Courses From ProgrammingKnowledge ★★★
    Python Programming Course ➡️ bit.ly/2vsuMaS ⚫️ bit.ly/2GOaeQB
    Java Programming Course ➡️ bit.ly/2GEfQMf ⚫️ bit.ly/2Vvjy4a
    Bash Shell Scripting Course ➡️ bit.ly/2DBVF0C ⚫️ bit.ly/2UM06vF
    Linux Command Line Tutorials ➡️ bit.ly/2IXuil0 ⚫️ bit.ly/2IXukt8
    C Programming Course ➡️ bit.ly/2GQCiD1 ⚫️ bit.ly/2ZGN6ej
    C++ Programming Course ➡️ bit.ly/2V4oEVJ ⚫️ bit.ly/2XMvqMs
    PHP Programming Course ➡️ bit.ly/2XP71WH ⚫️ bit.ly/2vs3od6
    Android Development Course ➡️ bit.ly/2UHih5H ⚫️ bit.ly/2IMhVci
    C# Programming Course ➡️ bit.ly/2Vr7HEl ⚫️ bit.ly/2W6RXTU
    JavaFx Programming Course ➡️ bit.ly/2XMvZWA ⚫️ bit.ly/2V2CoAi
    NodeJs Programming Course ➡️ bit.ly/2GPg7gA ⚫️ bit.ly/2GQYTQ2
    Jenkins Course For Developers and DevOps ➡️ bit.ly/2Wd4l4W ⚫️ bit.ly/2J1B1ug
    Scala Programming Tutorial Course ➡️ bit.ly/2PysyA4 ⚫️ bit.ly/2PCaVj2
    Bootstrap Responsive Web Design Tutorial ➡️ bit.ly/2DFQ2yC ⚫️ bit.ly/2VoJWwH
    MongoDB Tutorial Course ➡️ bit.ly/2LaCJfP ⚫️ bit.ly/2WaI7Ap
    QT C++ GUI Tutorial For Beginners ➡️ bit.ly/2vwqHSZ
    ★★★ Online Courses to learn ★★★
    Get 2 FREE Months of Unlimited Classes from skillshare - skillshare.eqc...
    Data Science - bit.ly/2lD9h5L | bit.ly/2lI8wIl
    Machine Learning - bit.ly/2WGGQpb | bit.ly/2GghLXX
    Artificial Intelligence - bit.ly/2lYqaYx | bit.ly/2NmaPya
    MERN Stack E-Degree Program - bit.ly/2kx2NFe | bit.ly/2lWj4no
    DevOps E-degree - bit.ly/2k1PwUQ | bit.ly/2k8Ypfy
    Data Analytics with R - bit.ly/2lBKqz8 | bit.ly/2lAjos3
    AWS Certification Training - bit.ly/2kmLtTu | bit.ly/2lAkQL1
    Projects in Java - bit.ly/2kzn25d | bit.ly/2lBMffs
    Machine Learning With TensorFlow - bit.ly/2m1z3AF | bit.ly/2lBMhnA
    Angular 8 - Complete Essential Guide - bit.ly/2lYvYRP
    Kotlin Android Development Masterclass - bit.ly/2GcblsI
    Learn iOS Programming Building Advance Projects - bit.ly/2kyX7ue
    ★★★ Follow ★★★
    My Website - www.codebind.com
    DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!

Комментарии • 351

  • @ProgrammingKnowledge
    @ProgrammingKnowledge  6 лет назад +10

    Find More Codes On My Website - www.codebind.com/

    • @RaviPrakash-hd1kj
      @RaviPrakash-hd1kj 4 года назад

      Sir,I am getting this error in psql shell
      psql: error: could not connect to server: could not connect to server: Connection refused (0x0000274D/10061)
      Is the server running on host "localhost" (::1) and accepting
      TCP/IP connections on port 5432?
      could not connect to server: Connection refused (0x0000274D/10061)
      Is the server running on host "localhost" (127.0.0.1) and accepting
      TCP/IP connections on port 5432?
      Please help sir.I am searching the solution from last 4-5 days but didn't get any correct one,none of them have solved my issue.I am also getting problem while installing.It's saying database cluster initialization failed!!!.Sir,it's a common problem,many of my friends are getting the same problem.It
      will be very helpful if you will make a separate video on this.

  • @stanleykubrick9379
    @stanleykubrick9379 5 лет назад +124

    I hope you know how hard it is to come across helpful PostgreSQL videos. There aren't many. This video sir, falls into that small category. This was absolutely fantastic. Thank you so much. I don't comment often but when do, I genuinely mean what I say. I can't than you enough.

  • @brindhasha4834
    @brindhasha4834 5 лет назад +7

    This worked like charm. I spent entire day on RUclips, stack overflow, psql community, God it worked.. thanks a lot. Probably now I can go to sleep peacefully..

  • @jacobokomo1880
    @jacobokomo1880 4 года назад

    Many tutorials online are not very clear...This Person...ProgrammerKnowledge is one of the BEST teachers online.You'll go far Sir

  • @Ishtriahn
    @Ishtriahn 4 года назад

    I literally stopped a programming tutorial because the tutor was using Postgres on Mac which apparently comes as an app and is easier to setup. I was lost and I didn't know how to set it up on Windows but this video helped me A LOT so thank you sir.

  • @manueldiera6781
    @manueldiera6781 5 лет назад +2

    Thank you very much for taking the time to make this video and cover the entire installation process in such a beginner friendly way. Much appreciated.
    Keep up the good work!

  • @kahlschlag17
    @kahlschlag17 7 лет назад

    Thanks so much. Awesomely explained. I am a complete newbie that is fed up with MS Access. I am trying to learn SQL and find it really difficult to find tutorials that aren't too intimidating. You have helped me on the first step of the journey of getting PostgreSQL on my computer so I can actually start. So thanks heaps again.

  • @flamingobird8513
    @flamingobird8513 5 лет назад +6

    For those who got, "Failed to load sql modules into cluster" error, I resolved the issue by creating a new folder called "postgresql" in C:\program files\ and then giving Full access permission(by right clicking the folder and click on properties and go to security tab and click on the "User" and giving full control access) to this folder and then run the .exe file(which u downloaded from PostgreSQL site).

  • @MushfiqFeed
    @MushfiqFeed Год назад

    After 5 years still I found this video help full & shortly. Thank a lot man

  • @habeebkehinde5028
    @habeebkehinde5028 2 года назад

    I used this video for my installation after uninstalling and reinstalling sql severally on my PC. Nice one. Keep it up.

  • @95platypus
    @95platypus 5 лет назад +1

    Thank you so much man. You actually took the time to go through a good setup. Super helpful! A lot of people leave you hanging on things like the environment variables, but you walked through it super well. Thanks!

  • @evilsaintbrendan
    @evilsaintbrendan 4 года назад

    Brilliant, lucid, succinct, and (relatively) short tutorial on installing PostgreSQL on Windows. Well done.

  • @iangitonga2811
    @iangitonga2811 6 лет назад +3

    I can't stress enough of how helpful this video is. Big up!!✔👍

  • @nickydaley345
    @nickydaley345 4 года назад

    3 years later and this video is still helpful, thanks!

  • @JustinMurray170fin
    @JustinMurray170fin 5 лет назад +1

    Thank you.
    I found your tutorial was extremely helpful, easy to follow, well presented (audio & visual sync was on point) & perfectly paced.
    Much appreciated.

  • @jianmudeng3087
    @jianmudeng3087 5 лет назад

    I found this video published in 2017. now the version of PostgresSQL is 11(beta) which is not supported in my PC. So I use the version 10. And chose locale "English, United State". That's work for me. Thanks this video.

  • @anandakumarsanthinathan4740
    @anandakumarsanthinathan4740 3 года назад

    Wonderful guidance there on getting started. It is the first step we all hesitate to take. This video helps us take that first step.

  • @maubunn
    @maubunn 5 лет назад +3

    Very helpful video! Using for my database class. Thank you very much!

  • @Relaxingtime4me
    @Relaxingtime4me 6 лет назад

    Very useful and clear presentation. I always struggle to install something, but this time I managed it like a boss due to your video, thank you so much!

  • @neharika6258
    @neharika6258 5 лет назад +3

    i didn't get the "postgresql 9.6" with the red cross (at 7.48)

  • @Desireanshu
    @Desireanshu 5 лет назад

    I want to say this channel is onestop end for all the great tutorials and software installation. Their is no other channel which describes as clear as this channel

  • @sanidhyagupta9582
    @sanidhyagupta9582 5 лет назад +11

    how to configure pgadmin as a native app, mine opens in browser

  • @MaledorPwned
    @MaledorPwned 6 лет назад +11

    pgAdmin4 opens in the browser (in my case Mozilla Firefox), is this normal?

    • @nahueeiglesias6088
      @nahueeiglesias6088 5 лет назад +1

      I think it is. I tried it a couple of days ago and it opened in the browser

    • @azucenavaleriano117
      @azucenavaleriano117 5 лет назад +1

      ofcourse

    • @ThePeterfrancon
      @ThePeterfrancon 5 лет назад +2

      That's because Firefox is your default browser

    • @brownrhythms
      @brownrhythms 5 лет назад +1

      @@ThePeterfrancon Mine is Opera, so it is likely tied to the version of Prostgres.

  • @kssrpraveen3899
    @kssrpraveen3899 6 лет назад +2

    I got the error Database Cluster Initialisation Failed error at the end of the install how to solve this error?

  • @joemakulila9758
    @joemakulila9758 4 года назад

    this was the best explanation i have found online

  • @anusha7409
    @anusha7409 4 года назад

    Absolutely simple & easy to understand for beginners. Thanks.

  • @AhmedurRahmanShovon
    @AhmedurRahmanShovon 6 лет назад +1

    Clear voice and clean presentation. Thanks!

  • @MrTRIGUN117
    @MrTRIGUN117 6 лет назад +3

    Thanks, i spend to 2 days before find your video and it help me!

    • @goncalvesvilanculos491
      @goncalvesvilanculos491 6 лет назад

      Myself i spend 1 day, so once i found this video i solved it in few minutes

  • @ManaBuilt
    @ManaBuilt 6 лет назад

    Thanks for this tutorial. So many instructions for PostgreSQL leave out the part where you need to set the Path variables. Appreciate the easy to follow video!

  • @JimBarryYo
    @JimBarryYo 4 года назад

    Awesome video tutorial. Thanks for this. Open source tech is often enough not the easiest to install, configure, and use. Videos like these help a lot. Subscribed.

  • @Gautamsverma
    @Gautamsverma 7 лет назад +8

    Hi , i am having problems installing the postgres SQL, I follow your steps then just before the completion it gives me an error: Failed to load sql modules into the database cluster. which is not happening in your case... i tried to search on internet . and came to know that it is something related to permissions .. i have been trying to install this for more then one hour now.. but not able to make it work. can you please address this issue.. i tried the solutions given in this link.. but still having the same error stackoverflow.com/questions/38656653/postgresql-reinstall-failed-to-load-sql-modules-into-the-database-cluster

    • @kssrpraveen3899
      @kssrpraveen3899 6 лет назад

      same problem arised!,you solved this error?

    • @fearlessfabler513
      @fearlessfabler513 5 лет назад

      Same problem here too

    • @gustinajaraite2063
      @gustinajaraite2063 5 лет назад

      Hey, have you solved your issue? I am having the same, would be glad if you could be able to share the answer!

  • @coscinaippogrifo
    @coscinaippogrifo 6 лет назад +1

    Note for users: to add the file path, for older versions of Windows, you click edit, then you type ' ; ' at the end of the string, then you copy the new file path (bin...etc).

    • @born_electric
      @born_electric 4 года назад

      i edited and copied the new one in path.....i dont know what was there inside of it earlier. Does this get me into some problem?

  • @kamrulislam9767
    @kamrulislam9767 4 года назад

    It is meaningful, clear and fantastic. Just Salute Sir. You have shown each and every step here. Tutorial should like that.

  • @ChangeYourLifeForever
    @ChangeYourLifeForever 4 года назад

    THE PART OF PUTTING GLOBAL VARIABLES ARE VERY VERY HELPFUL

  • @oLOo0o0oOLo
    @oLOo0o0oOLo 7 лет назад

    Thank you! I was having troubles connecting until I saw your video.

  • @user-zv4cx2nl9b
    @user-zv4cx2nl9b 6 лет назад

    The best tutorial about installing PostgreSQL, thanks

  • @fearlessfabler513
    @fearlessfabler513 5 лет назад +4

    What about the error after installing that says
    Unable to load sql module into database cluster..
    Wtf
    This error made me cry for 2 hours now. Still unable to fimd a solution. Wtf please help

    • @kevinxin1545
      @kevinxin1545 5 лет назад

      Same problem when installing on Windows PC. My Windows laptop worked just fine but desktop just wouldn't work. ROFL wtf is going on. I tried like 5 different suggested methods but none of them worked. I think it all comes down to the latest windows builds having write protection on C:\Program Files folder. Have you figured out a solution yet?

  • @arturmelosantiagoferreira157
    @arturmelosantiagoferreira157 4 года назад +1

    When I started the pgAdmin4 doesn' t have any postgreSQL server. What do I do? (ps: sorry if I wrote wrong, my english is bad)

  • @Vipers992
    @Vipers992 7 лет назад +3

    Keep up the good work, you are very intelligent man who should be a Professor, if you are already not.
    Thank you my friend, you are helping me with my graduation.

  • @coin5207
    @coin5207 2 года назад

    Amazing video. Simple and straight to the point!

  • @alexissanchezbro
    @alexissanchezbro 4 года назад +1

    You sir, are a saviour! Thank you for uploading this

  • @MrZ____
    @MrZ____ 5 лет назад +1

    psql: FATAL: password authentication failed for user "postgres" error how can do command promt

  • @Greimasgah
    @Greimasgah 6 лет назад

    Thank you for this video it made the download much easier for someone who is not familiar with pgadmin

  • @piriyaie
    @piriyaie 4 года назад

    Thank you for this video. This tutorial works also for PostgreSQL 12 which is great!

  • @mattp12
    @mattp12 5 лет назад

    Thank you for this. I can now finish my database class homework that my professor kindly said he wouldn’t grade until the end of the semester (opposed to when it was actually due)

  • @pratikshadeb9997
    @pratikshadeb9997 4 года назад

    Thankyou for explaining it so easily

  • @fiduciacia858
    @fiduciacia858 4 года назад

    Thank you for share this installation. Its useful for me after trying other site tutorials

  • @yefelekebay
    @yefelekebay 2 года назад

    Thank you so much it helped me from start to finish!

  • @southbayeric
    @southbayeric 4 года назад

    this is a great video with clear explanations. these instructions still work well with version 11. Thank you!

  • @masutabato
    @masutabato 5 лет назад

    Great tutorial very specific step by step instructions!

  • @modchannel9091
    @modchannel9091 3 года назад

    Thank you mah prend
    FROM PHILIPPINES 🇵🇭❤️

  • @cyberbenny_
    @cyberbenny_ 4 года назад

    jeez, superb work , being stuck for days!!!

  • @duantdvieju
    @duantdvieju 7 лет назад +13

    Stake builder? That a brilliant idea for a restaurant! Hahaha...
    Anyway, keep up the good work your videos are helpful, thanks!

    • @bbb-57
      @bbb-57 5 лет назад

      @@toby5067 yet, author is referring to steak building instead of stack throughout the whole video.... I too thought of a restaurant, he must have been hungry when recording :)

  • @grantbishop7524
    @grantbishop7524 3 года назад

    Terrific and clear helpful instructions: thanks so much!

  • @alrightymedia
    @alrightymedia 4 года назад

    Those who are having issue such while installation such as Cluster Initialization Failed, try uninstalling other DB if you have any, plus give username and password apart from admin, it worked for me atleast

  • @TheNeksa
    @TheNeksa 5 лет назад

    Thanks! Quick and easy instructions.

  • @shubhammittalSHM
    @shubhammittalSHM 5 лет назад

    Perfect video to install and configure PostgreSQL. Thank You :D

  • @ps_abhishek
    @ps_abhishek 4 года назад

    Thank you so much for this video. I watched a lot of videos, but this video helped me a lot .. Thanks again.

  • @rushin3090
    @rushin3090 6 лет назад +1

    It gives me warning during installation. And after installation done it gives connecting to database is failed.
    Please solve this problem.

  • @LearnTheSageWay
    @LearnTheSageWay 4 года назад

    awesome video mind bogling

  • @Opethefoodie
    @Opethefoodie 6 лет назад +1

    please around 13:32, i got this message "The term 'psql' is not recognized as the name of a cmdlet, function, script file, or
    operable program. Check the spelling of the name, or if a path was included, verify that the
    path is correct and try again."

    • @rafaeldefreitas5689
      @rafaeldefreitas5689 6 лет назад +1

      You most likely forgot to add the "Path variable" or added it wrong. Try to check this ;)

  • @albebelen8031
    @albebelen8031 7 лет назад +1

    Thank you so much for this video. It was really helpful! :)

  • @tijmenbevers8599
    @tijmenbevers8599 2 года назад +1

    Thank you so much? We love postgres. By god created

  • @inspiretube8897
    @inspiretube8897 4 года назад

    This video was really helpful.Thanks

  • @emillydasilva2070
    @emillydasilva2070 5 лет назад +2

    this is a really helpful tutorial, thank you so much!

  • @MicahJohns
    @MicahJohns 4 года назад

    What do you do if windows makes a superuser from your computer's user account? Instead of postrges it asks me to log in with my name that I log into my computer with, and no password works.

  • @raunakrhishabh6340
    @raunakrhishabh6340 6 лет назад

    Which installation should I choose between "post gre sql 10 on port 3452 and "remote server" installation ? As I'm working on Remotely Control an ESP8266 With Kaa IoT Platform project

  • @isadoramesquita238
    @isadoramesquita238 6 лет назад +1

    Congratulations! You rock it! I just loved the explication, helped me a lot! Thank u!

    • @smjawad786
      @smjawad786 5 лет назад

      Hye! can u guide me because i am still far away.

  • @oliviashettles5402
    @oliviashettles5402 6 лет назад +1

    This helped me so much! Thank you!

  • @seso227
    @seso227 4 года назад +1

    when i click on pgadmin4 it tells me "failed to open the system default web browser. is one installed" what do i do ???

    • @HemantKumar-qj9oc
      @HemantKumar-qj9oc 4 года назад

      Similar is happened with me brdr try to open the server in administrative mode

  • @florianuhlmann1653
    @florianuhlmann1653 4 года назад

    super good tutorial. i got everything running with problems in between. thanks;)

  • @gilbertjohn5466
    @gilbertjohn5466 5 лет назад +1

    Thank you

  • @AllthingsFoodieTX
    @AllthingsFoodieTX 3 года назад

    Very Good Video Brother keep up the Good work your video does exactly what it says it will do Thank you.

  • @himanshukumar-eq5kr
    @himanshukumar-eq5kr 7 лет назад

    Probably the toolchain path within the compiler options is not setup correctly?! (Do you have a compiler installed?)
    Goto "Settings->Compiler...->Global compiler settings->GNU GCC Compiler->Toolchain executables" and fix the compiler's setup.
    Skipping...
    Nothing to be done (all items are up-to-date).
    Target uses an invalid compiler; run aborted
    when i installed code block c compiler . this will error display what is the problem plz sort.

  • @williamwedmedyk3927
    @williamwedmedyk3927 5 лет назад

    yasss. thank you man. im always forgetting to set new environment variables. you saved the day!

  • @stefanic88
    @stefanic88 6 лет назад

    Very good instructions, thank you for your help!

  •  3 года назад

    didn't know that I have to add environment variables to the system so that I could write psql commands in the command line xD. that's why I got the error of psql performing as an unrecognized command. thanks!

  • @pratikkodilkar2817
    @pratikkodilkar2817 2 года назад

    Thank you so much! This was really helpful

  • @felixmariotto4639
    @felixmariotto4639 5 лет назад

    Thank you so much, the part about environment variable really helped

  • @shilpakamble7791
    @shilpakamble7791 2 года назад

    Thank you sir. It's really helpful.

  • @tirthvadaria5810
    @tirthvadaria5810 3 года назад

    Nice informative content bud... 🔥🔥

  • @bengardner3878
    @bengardner3878 6 лет назад

    How do I add paths in Terminal for Mac? Is it just export PATH="$PATH:/Library/PostgreSQl/9.6/bin"? Does it matter what the prompt/shell is in Terminal? It seems like it's working, but how does Terminal know where this is being set? PATH always writes to .bash_profile?

  • @Raydie
    @Raydie Год назад

    This was so helpful thank you sooooo much.

  • @ajsim
    @ajsim 6 лет назад

    Very goods job! Very useful and clear. I got it running well.

  • @vivekdhage8296
    @vivekdhage8296 3 года назад

    Worth it... thanks for correct information

  • @abhishek_332
    @abhishek_332 4 года назад

    Thank you for your support sir

  • @AngrejKumar
    @AngrejKumar 6 лет назад

    Thank you so much for such a great descriptive video.

  • @mainmanlobo_
    @mainmanlobo_ 5 лет назад

    Worked perfectly...nice work👍🏾

  • @maryalexandriamailler2255
    @maryalexandriamailler2255 5 лет назад +1

    I don't have any server + to click on?

  • @jaldianderlemeko5095
    @jaldianderlemeko5095 2 года назад

    After installing PostgreSQL as you mentioned...the way.. i open pgadmin 4 and then i opened querry tool but its not opening..
    And 2nd issue is i am not getting any response after entering (psql -U postgres postgres ) in Command prompt
    Pls help 🙏

  • @soumyak9798
    @soumyak9798 3 года назад

    Failed to open the system default web browser. Is one installed?. I'm getting this error and I cannot configure as stated in few solutions. How can I start pgadmin ?

  • @user-ks9jn3yq2u
    @user-ks9jn3yq2u 6 лет назад

    This is very helpful. Thank you for uploading.

  • @bushrasafdar4384
    @bushrasafdar4384 5 лет назад

    very thorough tutorial

  • @reksmeyok1957
    @reksmeyok1957 7 лет назад

    Thank you for instructive video. clear and detailed.

  • @c0dingtut0r
    @c0dingtut0r 2 года назад

    Thank you so much.
    It worked out for me!

  • @suraj123ification
    @suraj123ification 7 лет назад

    Greetings!
    Thank you for the video. Are there any GUIs for PostgreSQL which allow users to type queries within the main application itself (like in the case of SQL)? I am not a very experienced programmer, and am not used to coding in command line.
    Thanks in advance!

  • @ahmedgon1
    @ahmedgon1 5 лет назад

    That was a very useful tutorial, many thanks

  • @mekidesbekele1787
    @mekidesbekele1787 3 года назад

    Thank you so much! Awesome job!!

  • @mervenur8471
    @mervenur8471 3 года назад

    Thank you so so much! So helpful!

  • @kurtofusa
    @kurtofusa 5 лет назад

    You did a great job my friend. Thanks a lot .