1 00:00:00,800 --> 00:00:05,060 For final small print projects, we will need pollsters as corral. 2 00:00:06,240 --> 00:00:07,260 Open your browser. 3 00:00:11,800 --> 00:00:15,190 Search for PostgreSQL skill download. 4 00:00:16,650 --> 00:00:19,500 Move over to the official post scores as Quill website. 5 00:00:21,970 --> 00:00:23,590 They're hit on windows. 6 00:00:26,820 --> 00:00:30,460 As you can see, you can't see the latest version here available. 7 00:00:31,020 --> 00:00:34,470 So you wants to download the installer by clicking on this link. 8 00:00:38,880 --> 00:00:45,990 There picked the latest version, in my case, it is version 14 hit download, depending on your internet 9 00:00:45,990 --> 00:00:46,510 connection. 10 00:00:46,530 --> 00:00:47,580 This might take a while. 11 00:00:48,060 --> 00:00:50,880 Therefore, I already downloaded it in advance. 12 00:00:52,580 --> 00:00:54,590 Let's go to my daughter's directory. 13 00:00:59,790 --> 00:01:01,710 Execute two pulse groups and solo. 14 00:01:09,410 --> 00:01:11,420 It will ask you for further permissions. 15 00:01:12,050 --> 00:01:12,440 Yes. 16 00:01:15,210 --> 00:01:18,150 Now we can stop the installation process was pulsed, Chris. 17 00:01:19,290 --> 00:01:21,000 Here, just sit next. 18 00:01:23,060 --> 00:01:25,100 Leave the default SDR right here. 19 00:01:25,420 --> 00:01:26,090 Hit next. 20 00:01:28,440 --> 00:01:33,750 Also here you want to install everything wood chips with the Pulse Gris installer hit next. 21 00:01:36,260 --> 00:01:37,790 Here hit next as well. 22 00:01:39,700 --> 00:01:41,410 Now you have to choose the passport. 23 00:01:42,370 --> 00:01:48,190 What you have to keep in mind is this is also the passport which you need for the next object, which 24 00:01:48,190 --> 00:01:50,350 we use in our smart brain project. 25 00:01:50,890 --> 00:01:54,310 In my case, I just use the passport test. 26 00:01:56,640 --> 00:01:57,390 He next. 27 00:01:59,570 --> 00:02:01,130 Leave the port as it is. 28 00:02:02,100 --> 00:02:02,790 It next. 29 00:02:04,830 --> 00:02:07,890 You can choose the default local for your thoughts on bass. 30 00:02:08,580 --> 00:02:10,979 I will recommend to all to choose here. 31 00:02:11,190 --> 00:02:13,410 Just the default local hit next. 32 00:02:15,180 --> 00:02:17,430 Now we can start with the installation process. 33 00:02:19,630 --> 00:02:20,770 Hit next once again. 34 00:02:22,760 --> 00:02:25,550 Let me fast forward for you so that you don't have to wait. 35 00:02:28,400 --> 00:02:31,640 All right, postgraduate school got installed successfully. 36 00:02:32,450 --> 00:02:34,380 Just stick to stick builder here. 37 00:02:34,430 --> 00:02:35,900 We don't need it right now. 38 00:02:36,020 --> 00:02:36,860 And hit finish. 39 00:02:39,250 --> 00:02:44,290 OK, so let's verify PostgreSQL installs successfully oatmeal terminal. 40 00:02:47,310 --> 00:02:51,450 In here, just type Pascual and answer. 41 00:02:52,880 --> 00:02:55,160 Oh, no, school not found. 42 00:02:55,970 --> 00:03:01,370 So let's double check if it is available in our environmental variables to do so. 43 00:03:01,520 --> 00:03:05,530 Hit the windows key and type environmental variables. 44 00:03:06,510 --> 00:03:09,090 Here we can edit them, just hit this. 45 00:03:10,690 --> 00:03:12,760 And click on environment variables. 46 00:03:14,840 --> 00:03:18,260 There you have a section which is called Path. 47 00:03:19,180 --> 00:03:20,260 Edit this one. 48 00:03:21,760 --> 00:03:25,910 Scroll all the way down, and there should be pulse scores as well. 49 00:03:26,290 --> 00:03:29,050 But it isn't in there, so how to fix it? 50 00:03:29,920 --> 00:03:32,110 All you have to do is go out here. 51 00:03:33,810 --> 00:03:35,400 Open your explorer. 52 00:03:39,490 --> 00:03:42,010 Posterous got installed on the sea. 53 00:03:43,680 --> 00:03:44,880 Program files. 54 00:03:46,750 --> 00:03:47,800 X86. 55 00:03:51,620 --> 00:03:53,870 And you search for PostgreSQL. 56 00:03:55,430 --> 00:03:58,040 It is not in program files, it's 86. 57 00:03:59,200 --> 00:04:01,240 It's got safety into program files. 58 00:04:03,440 --> 00:04:05,770 There we look for PostgreSQL. 59 00:04:06,310 --> 00:04:06,910 Here it is. 60 00:04:09,580 --> 00:04:10,990 Move to version 14. 61 00:04:15,120 --> 00:04:16,950 And there you have the bin directory. 62 00:04:17,459 --> 00:04:20,070 This is the one where the school lives in. 63 00:04:21,200 --> 00:04:27,500 Once you answered this directory, just click in the address bar and copy the entire path. 64 00:04:29,630 --> 00:04:34,520 Exit out of the Explorer and search for other environmental variables again. 65 00:04:40,290 --> 00:04:42,660 Then we move to environmental variables. 66 00:04:44,430 --> 00:04:46,170 And search for the path. 67 00:04:47,650 --> 00:04:48,490 Click Edit. 68 00:04:50,470 --> 00:04:58,990 And then now we can just add a new one by hitting a new and paste in what we have copied before it to 69 00:04:58,990 --> 00:04:59,410 answer. 70 00:05:01,070 --> 00:05:02,160 And now it can hit. 71 00:05:02,190 --> 00:05:02,760 OK. 72 00:05:03,410 --> 00:05:05,600 OK, here at OK here. 73 00:05:06,320 --> 00:05:10,280 So let's try again if we have really Waveland our terminal. 74 00:05:12,020 --> 00:05:17,900 So let's zoom in and now let's talk Pascual, its answer. 75 00:05:19,110 --> 00:05:21,390 And now hold on a sec. 76 00:05:21,480 --> 00:05:23,580 I don't have a password, I guess. 77 00:05:23,970 --> 00:05:27,960 Just try it test, because this is the one which I've chosen. 78 00:05:29,130 --> 00:05:29,720 I don't know. 79 00:05:29,750 --> 00:05:31,760 I can't look in. 80 00:05:32,150 --> 00:05:32,480 Hmm. 81 00:05:33,320 --> 00:05:33,710 Yes. 82 00:05:33,740 --> 00:05:40,820 You know, your Windows user doesn't get any password for using pulse groups to overcome this issue. 83 00:05:41,270 --> 00:05:43,340 You just have to use an additional flat. 84 00:05:44,000 --> 00:05:48,980 So in this case, it is que al menos uppercase. 85 00:05:48,980 --> 00:05:51,770 You don't type posterous. 86 00:05:53,590 --> 00:05:54,280 His answer. 87 00:05:56,000 --> 00:05:58,100 Now it will ask for the use of Posterous. 88 00:05:59,210 --> 00:06:02,360 I have two tests, so I type in tests to get. 89 00:06:05,270 --> 00:06:05,830 All right. 90 00:06:06,170 --> 00:06:11,290 I'm in Posterous right now, and I could query basis in my post, Chris. 91 00:06:12,380 --> 00:06:18,230 So you have seen the passport doesn't get shown neither stars or any of this kind of feedback. 92 00:06:18,620 --> 00:06:21,050 This is a common thing in the terminal area. 93 00:06:21,830 --> 00:06:24,410 You don't get feedback for security reasons. 94 00:06:24,770 --> 00:06:26,870 But it will pick what you ever enter. 95 00:06:28,270 --> 00:06:34,930 So this was enough for this lecture, in the next lecture, I will show you how to create a database 96 00:06:34,930 --> 00:06:35,830 and the command line. 97 00:06:36,160 --> 00:06:40,330 That's how to use it admin to navigate around your created databases. 98 00:06:40,720 --> 00:06:41,830 I see you in that one. 99 00:06:42,220 --> 00:06:42,710 Bye bye.