WEBVTT 00:07.940 --> 00:12.350 Now let us go ahead and download PostgreSQL on our systems. 00:12.590 --> 00:14.630 So I'm using a windows PC. 00:14.660 --> 00:17.960 So let's go ahead and learn how to download that step by step. 00:18.140 --> 00:20.690 Go ahead and hit on downloads or go over here. 00:20.690 --> 00:23.570 And one of them can go ahead here on downloads here. 00:23.600 --> 00:25.370 Or go ahead and check that out. 00:25.400 --> 00:29.630 So if you go ahead and hit on that you can see PostgreSQL downloads. 00:29.630 --> 00:32.240 And I'll have packages and installers. 00:32.240 --> 00:35.150 And here you have to select your operating system. 00:35.150 --> 00:37.190 If you're using Linux you go for this. 00:37.190 --> 00:41.600 For Mac OS you go for these windows, you go for these and so on. 00:41.660 --> 00:42.350 Alright. 00:42.350 --> 00:45.830 So every installation of all these are just similar. 00:45.860 --> 00:51.380 I'll go ahead and hit on windows and then I'll get over to Windows Installer. 00:51.380 --> 00:53.810 So Interactive Installer by EDB. 00:54.050 --> 00:56.000 What I need is installer. 00:56.030 --> 00:58.130 Go ahead and hit on installer. 00:58.550 --> 01:03.290 And there once you do that you go ahead and see download PostgreSQL. 01:03.290 --> 01:08.000 And then you can go ahead and then load PostgreSQL. 01:08.000 --> 01:12.040 So you can see PostgreSQL Versions 17.0. 01:12.070 --> 01:14.590 And when you go down, you can see so many of them. 01:15.070 --> 01:19.300 I'm using windows 64 bit system and it is supported. 01:19.330 --> 01:26.530 But for windows 32 it can say that these versions are not supported until you get down to 10.23. 01:26.740 --> 01:34.360 Then if you're using windows 64 bit system core head and download 17.0. 01:34.360 --> 01:37.030 So go ahead and hit on download. 01:37.030 --> 01:40.720 And then we go ahead and start immediately. 01:40.720 --> 01:44.650 And it says your download should begin in few seconds. 01:44.650 --> 01:46.180 And our download have started. 01:46.180 --> 01:47.890 And that is it. 01:47.890 --> 01:49.900 So let's go ahead and check it out. 01:51.250 --> 01:53.440 Over here I have my download. 01:53.440 --> 01:56.710 You can see PostgreSQL 17.0. 01:57.010 --> 02:01.450 Uh that is for 64 bit system our head and double click on that. 02:01.450 --> 02:04.210 Or you can see that that is getting started. 02:04.300 --> 02:08.410 And now very soon it should begin immediately to install. 02:08.680 --> 02:11.320 Welcome to the PostgreSQL setup wizard. 02:11.530 --> 02:13.900 Go ahead and hit on next. 02:13.930 --> 02:18.940 And uh I'm going to choose that spot because I don't have any parts. 02:18.970 --> 02:20.850 I have deleted every other Everyone wants to have. 02:20.850 --> 02:23.100 I'll go ahead and hit on next. 02:23.220 --> 02:28.290 And over here you can see the PostgreSQL server which is this very first one here. 02:28.290 --> 02:29.940 That is the database server. 02:30.000 --> 02:36.240 And then the Pgadmin is the graphical interface for managing and working with PostgreSQL database and 02:36.240 --> 02:36.900 servers. 02:36.930 --> 02:38.580 Then we have the stack builder. 02:38.580 --> 02:43.980 And the stack builder is used to download and install additional tools, drivers and applications to 02:44.010 --> 02:46.770 complement your PostgreSQL installation. 02:46.800 --> 02:48.330 Then we have the command line. 02:48.330 --> 02:56.700 And this is just command line tools and the client libraries and everything is listed for you. 02:56.730 --> 03:01.050 Then go ahead and hit on next because we're going to select everything is shut out. 03:01.050 --> 03:02.400 Everything is selected. 03:02.400 --> 03:07.650 And I had hit on next, then our estimate then the path and go ahead and hit on next. 03:07.650 --> 03:12.030 And now you are required to insert a password. 03:12.030 --> 03:15.570 And this password you have to always remember this password. 03:15.600 --> 03:16.170 All right. 03:16.170 --> 03:21.660 So ensure that you have this password set somewhere because you're going to use that for your database 03:21.660 --> 03:22.590 connection. 03:22.620 --> 03:26.400 I'll go ahead and put a simple password and which I will always remember. 03:26.400 --> 03:32.490 And uh for the purpose of this lecture Then go ahead and click on next. 03:32.490 --> 03:35.940 And I'm going to still maintain the pots to be five, four three, two. 03:35.970 --> 03:38.610 That is always the default for PostgreSQL. 03:38.790 --> 03:40.500 Go ahead and hit on next. 03:40.500 --> 03:44.370 And I'm going to still maintain the default AE. 03:44.400 --> 03:48.210 I'll go ahead and hit on next, and I'll hit on next. 03:48.210 --> 03:53.430 And the setup is now ready to begin installing PostgreSQL on your computer. 03:53.460 --> 03:54.780 Go ahead and hit on next. 03:54.780 --> 04:00.270 And now you can see that the installation is almost getting up. 04:00.270 --> 04:04.440 And very soon we have PostgreSQL installed on a computer. 04:04.440 --> 04:12.030 So let's sit back, wait for this and expect it to install successfully, and then we'll kick off immediately. 04:13.890 --> 04:14.370 All right. 04:14.370 --> 04:15.900 So it's almost getting there. 04:15.900 --> 04:17.910 And very soon it will get to the end. 04:17.940 --> 04:21.810 And we'll go ahead and conclude everything as soon as possible. 04:22.890 --> 04:23.460 All right. 04:23.490 --> 04:24.930 That has just completed. 04:24.930 --> 04:31.230 And uh, it says that Buddha may be used to download and install additional tools, drivers and applications 04:31.230 --> 04:33.360 to complement your PostgreSQL. 04:33.630 --> 04:35.010 Uh, don't just want to do this one. 04:35.010 --> 04:36.120 Now go ahead and save. 04:36.120 --> 04:37.020 This setup has finished. 04:37.020 --> 04:39.090 I'll just go ahead and hit on finished. 04:39.090 --> 04:39.110 Unfinished. 04:39.110 --> 04:41.150 And that is it for now. 04:41.330 --> 04:47.090 So let's go ahead and move over to over here and go to applications. 04:47.090 --> 04:48.800 And I'm using Windows 11. 04:48.800 --> 04:51.410 So you can always go to application or app. 04:51.410 --> 04:56.660 And then you scroll down and go down and check for PostgreSQL. 04:56.660 --> 05:00.950 And you can see how PostgreSQL 17 go ahead and hit on this. 05:00.980 --> 05:05.990 You open it up and you can see we have the Pgadmin right in here we have the application stack view, 05:06.200 --> 05:12.110 we have the installation notes, the pgadmin documentations and the PostgreSQL documentations. 05:12.110 --> 05:12.680 And cool. 05:12.680 --> 05:15.410 And we also have the SQL shell. 05:15.440 --> 05:16.430 Very important. 05:16.460 --> 05:18.320 Go ahead and hit and hit on this. 05:18.320 --> 05:20.270 And this is what we have. 05:20.300 --> 05:22.040 We're going to learn in the next video lecture. 05:22.040 --> 05:23.510 But go ahead and hit on enter. 05:23.510 --> 05:27.950 You can see server database ports 5432. 05:27.980 --> 05:33.140 And Helen says the name and password and the password and so on. 05:33.140 --> 05:36.710 When I was showing us on how to connect all these in the next video. 05:36.710 --> 05:39.800 So go ahead and check it out right now and close that. 05:39.800 --> 05:42.650 And I'm going to see you in the next video lecture.