PostgreSQL Installation 2026: Install PostgreSQL + pgAdmin 4 + CLI Setup

Hello, what's up, guys? Welcome, everyone, to day 2 of the PostgreSQL series Yeah, guys, today in this video Complete PostgreSQL SQL installation Those who watch it from start to end And believe me, this video is extremely important. Because installing PostgreSQL Honestly, even I feel the same way Whether there was a disaster or not There are so many steps in MATLAB. And in fact, from one website to another website From the second website to the third website Matlab was created by them, it's their legacy. I will now explain to you step by step in full detail. And at the same time We will also take a look at using Postgres SQL on the CLI. And its GUI Graphical User Interface and that's You must have definitely heard of PG Admin 4 We will check everything here as well. It's working perfectly for us. No, it means on our system PostgreSQL That is your RDBMS Joki software is for what You said that we had studied To manage or to access or to create your database Was it installed properly or not? So what is GUI here? What is CLI? We will see all this here. And okay, you can see it Today's agenda for us is these four points. Okay, one of mine I got pushed aside, but it's okay. Critical configurations When you keep something in mind It is necessary to do it. Then your EDB installer walkthrough Your environment variable and path are very important. And verification checks It has been clearly stated that this is very important. Okay, so The main thing that was told was Next button when you go to install Before that, some things I have already drawn your attention to it Don't keep postponing the water task indefinitely. First of all The superuser password The first thing you need to take care of is your super user password. As you You must have worked with MySQL. If you have done it, then also in the workbench You had a root and then its password. Your password is also here The time to set will come And make sure Karna Your password, please Obviously, you like to log in, but don't forget to log out Keep it saved somewhere occasionally I already told you about this earlier A point will come where you will have to add a super user password. I will keep you in mind. This is very important. The second the port number The port number by default will be given to you 5 4 3 2 In case it's already being used by you beforehand It's a different matter, but nothing can be done about it. And the local Keep this set to default Let's just change this then. What is written here This ensures your system can handle text and characters. And alphabetical sorting exactly the way Your Windows operating system expects Whatever it is, the password Port numbers are those that are local These three things are critical to him. I'll just say this much to you You've already found out so much, haven't you? Alright, we're ready. How to install From PostgreSQL Before this, guys, the channel till now If you haven't subscribed yet, please do so. Because aapka like share and subscribe It will highly motivate me to see such videos I can keep uploading it completely for free. And like target, just keep 500 likes So here you can see Simple Google on where PostgreSQL I'm writing it down and don't worry I will provide the main link below This is my note, and the PPT related to it as well As I share in the Kalki video I'll also share this with you. This is the very first one. And by the way, aap ek aur comment Tell me, do you know this? The text on the screen appears too small. How does it look? Because I recently got a 27-inch Monitor liya, before that I took the 24 one I was working, and this one I was doing 100% on it, scaling it Just tell me by commenting whether you all like Does it look clear and good? Do you want us to? Please zoom in a bit and read this. Please do comment and let me know for sure What is your PostgreSQL SQL? The world's most advanced Open source relational database Hume usse abhi phila lena dena nahi Because we know what these things are Either you can download it over here And here too, you will get the latest I showed it off after releasing, but we keep moving forward on it. After downloading You can also go up there to download Many options are available There are so many things here If you look closely here You are given options. Different operating systems By the way, I'm using Windows 11. And perhaps you, who are seeing this, might also be one of them You might be using a Mac. You use Mac or maybe you use Linux The other two, I guess I don't know, this will be very rare. Anyway, whatever it is If you are on a Mac, you will click here Otherwise, I'm using Windows. I click on the main Windows. Here you can see that I am Which version of Postgres is it? 18, 17, 16 But obviously I'll be going with 18 anyway But the thing is that I am somewhere I can't click. Now download the installer again Here you can see What you are seeing right now Download the installer I'll have to click on this now Certified by EDB Just watch, I'll show you EDB Installer Walkthrough You know, right? What did I just say? From one website to another It hasn't even started yet We haven't even downloaded it yet. What happens next after clicking download Wherever we went, we had to download it Download the installer On to the next website EnterpriseDB ahead Download PostgreSQL SQL So this is the current version 18.4 For your Mac, for your Linux For your Windows And I will say exactly the same We'll download only the latest one. And about yourself This one, not that one — the latest one. Whatever is appearing before you So here is something about you Once it's downloaded, nothing will happen to you. It will look like this. Now look here. Look here, this is what I did yesterday. Ala, before that, I've been from the last three men. I'm using it now, going to do it Lying down, then getting up, what is this place called? Better will remain, where better will not remain So I was recording this video even during the day yesterday. But for some reason, the audio did not come out in it So today I am reading what I need to return First, when you click on this, a pop-up will appear Simple, just click yes there. Alright, it will happen after that. if these cases are on your system Distribution is this Microsoft Visual C++ Doing it, one of you Okay, I mean, don't get upset; this is perfectly normal. It must be, it must be Once it becomes complete Now you can see that finally ours The installation for PostgreSQL You are appearing live here, and you I can see it very clearly welcome to postgres Setup Wizard Here, this next one here Button is simply now you need this next Just click the button. So, I see you're looking at the installation directory. What do you mean by this PostgreSQL SQL? I mean, what is PostgreSQL? will be installed on the directory, so here I can see it's in your C Program Files PostgreSQL SQL and then 18 So this is the most important Here, you will pay attention to the fact that you must Here, four things are visible. Alright, the one which is the stack builder We don't need SQL We need a server, PG admin Your GUI command-line tools basically CLI that runs when you hard code You will do it; we need it, and then simple Next, click here and then this is your Data directory where your data library is located is going to do, okay, and then Simply click next for you and This is the most important part. What I told you about the password You must not forget, admin 123 Leave it written down, next and this Is your port number default next on your Just leave it, don't do anything. Okay, the local one I mentioned earlier Keep it default and then simple Click next, guys Here you can see our super user That's your PostgreSQL by default, that's yours You reside in the database, which is ours It's the port I told you about, 5432 You can see it here, then you That's very good news. So guys, it took a little time, just grab it quick, you know? My system is somewhat good, so I felt it for 30 to 40 seconds. Now that our setup has been completed Just click the simple finish button, boom, guys This is it, now it's your turn. Now remove it. Here, we are now doing a task Let's open your power cell. Here, the command prompt, whatever your merge, you select and if you have Mac and Linux If you're using it, guys, the steps will remain almost the same. and if anyone has a Mac And I have installed it on Linux. Please tell me the steps you followed If you paste it in the comment section I would be very happy. But at the same time, other users will also greatly benefit from it. And I'll also pin it, that's fine All right. So it's installed here now The one that is command line interface psql If you appear in this manner Manlab this red that the term psql What is written here? This term here psql is not recognized Just understand this much: this is for you That's why I'm telling you because Look, you've already installed it. But Windows 11 doesn't know What is this thing that's moving? unless You set up the environment variable Not doing it So finally to set your environment variable and path So here you can see In this way What do we need to do with the environment variable? It's fine to set it. Too simple, you can see this easily Do you remember when I showed you I already told the installer, didn't I, that this one here Look, see Program Files and PostgreSQL Eighteen and after that we have One more folder that has been created recently That's your bean. Why is this? Important, let me tell you, look here Read this line carefully here. adding this folder to your Windows What does environment variables mean? It tells Windows where to find psql from anywhere on your computer means this one psql, the command-line interface for working with PostgreSQL From anywhere, any folder How can you tell that this Where is that computer then? It will work when you use this path Add this to the environment variable. All right, what is written? when you type a command in the terminal Windows checks the folder in the specified path I hope you have understood by now that we should add it now It is necessary so that Windows finds out that it Where is psql and execute it there From there, good on this spot He will execute him right there. Alright, then I I'll show it to you Here we go. You need to copy this. How will you add it to the environment variable? I've always been When I type inv, it automatically appears Look at Gohar In this way He left. Nobody Looking at it in this way If you look at Gohar environment variable Click here Now two things have come. If you set the path in the environment variable So you get two things. The number one is a user variable for admin and then system variable So when you add on the user variable So, regarding this current user He will get it from him. but the moment another user comes to you In starting, accounts are different, different ones. When another user comes, they won't be able to access it. I mean, his That won't work on the account. So if you want it to be I'll do it at the system level so that no one can So better go with it for use system and here this one There is an "Edit" button; click on it. You will first need to select the path. Looking from here, the god is here Look here, this is it,PLEMENTED Here New paste Here Once it happens like this, there's no going back now If you write it, you'll get this, so you might as well do it once Close it Windows Power Cell Here write psql, one second Press Ctrl psql When you do things like this Once it becomes like this We have received two practice questions. What I ask after a little while, but before that First, quickly Let's verify the check that is psql when you write I had done the admin's password. I don't have it. Anything is possible. The super user we were creating He must do this for his people. We have the syntax. I can see many difficulties here. psql hyphen space -u Username Username basically will be whatever username you have So, psql doesn't work for me. Typing psql will start your CLI. We have installed it. Those are his flags. Hyphen Yoo So, what will you write something like this? Pskov Is it not? Alright, I've already told you that, yes So This will be yours. Post-Grass The passcode I told you Do you remember? If you're gone, then you're gone, and then this is yours So if this is how you've been seeing it PostgreSQL to Hashtag Your PostgreSQL installation is complete. and now you can also do it directly via CLI You can use it So this is your command-line interface. Here, you can do one thing Just to check whether yes, everything is still correct or not Here in this way Hyphen, if you're doing it, check this out It's not working, and there's another problem as well. What I will tell you in today's video is that now The one who was the heat has changed. Just look for a second I'll tell you dbout it in tomorrow's video Look here What is meant here is that in this manner, Virajan is you. No, we cannot check it this way. From you, the post-gas hour can be a little bit of a pod. I mean, we've already installed Postgres. We've also taken a good look at the CLI. Now this is your Graphical User Interface Why did I call this a Graphical User Interface Because here, like fire If I need to create a database, I'll do it comfortably. I will like and click the rat. And my database will be created On one hand, you will have to hard-code it Here, the meaning will settle down comfortably. Tike ten Poskres Please enter the password I've got it, let's go, check this out How did it turn out like this I mean, if it has come to you I mean, your PG admin for the forum It has also come here. Now here you can see, your My App is appearing Not this is yours I had previously created the test bypass. Test for such tam pass I'll also let you know about the beads for tomorrow. Why is it like this here in this manner? has done it, meaning normally If we look at our MySQL part So the database was Workbench There were tables inside him, ours But here your database, followed by your Iskhema, inside which is your Public folder, then your tables. Understood. So in this way, end and if you notice this, it means yes, now whatever you have as PEG Admin 4 So in tomorrow's video, I'll tell you how you can create tables here. How can you create a database and tables using the CLI? I'll tell you everything, but today in this video, if you're seeing this far Meaning, your PostgreSQL is perfectly installed. with your CLI and GUI That's all, just one second, close it now then That's all for today's video. But Billie, this video was very important to me because This does not happen with many people either Many people are having problems installing this. Didn't you see a bus in the beginning? Where did we have to go from where to download it? Have you read that it's been reached? How was the video? Let me know in the comments section Mac and Linux viewers, please copy and paste Whatever steps you saw were shown to you And who has any doubt? There's an error coming up or something like that If you like the video, please like it Like Target is 500 likes Please do it forpot. If you haven't subscribed to the channel yet, please do so now. See you in the next video Subscribed Magiziyega