1

00:00:01,590 --> 00:00:07,860

So let's get Postgres installed on windows, so I'm on the site where I find the window installers,



2

00:00:07,860 --> 00:00:14,880

which the URL is right here, PostgreSQL, Duggie, download Windows and I will just click the download



3

00:00:14,880 --> 00:00:16,890

the installer link right here.



4

00:00:17,430 --> 00:00:21,810

And I'm on Windows and I want 64 bit windows, and you almost certainly do as well.



5

00:00:21,810 --> 00:00:26,220

It's unlikely you have a 32 bit system, but if you do just download this version right here, which



6

00:00:26,220 --> 00:00:29,060

is an older version but will still work for this course.



7

00:00:29,400 --> 00:00:36,520

So I'll download the 64 bit installer for Windows and it should start downloading.



8

00:00:36,520 --> 00:00:37,380

And there it goes.



9

00:00:52,550 --> 00:00:54,110

And I'll open the file.



10

00:00:59,860 --> 00:01:01,450

And yes, I'll allow this.



11

00:01:03,260 --> 00:01:05,630

And it should take me through a wizard to install everything.



12

00:01:29,260 --> 00:01:30,070

And here we go.



13

00:01:37,340 --> 00:01:38,720

So next.



14

00:01:40,790 --> 00:01:47,010

And I'll take the default installation director and I will allow postgrads to be installed.



15

00:01:47,270 --> 00:01:50,470

I'm not going to bother with PJI admin for because it does too much.



16

00:01:50,480 --> 00:01:57,200

I'm not going to bother with the stack builder, but I'll keep going and I'll take the default data



17

00:01:57,200 --> 00:01:57,800

directory.



18

00:01:58,640 --> 00:01:59,860

And now this part.



19

00:01:59,870 --> 00:02:05,300

Do not forget this password I'm going to put in my own, which will just be password.



20

00:02:07,520 --> 00:02:12,860

You need to remember this password and the user is Postgres so the user is postgrads and the password



21

00:02:12,860 --> 00:02:18,440

is password next and the port is the default port five, four, three, two.



22

00:02:20,570 --> 00:02:21,740

And I'll use the default.



23

00:02:21,740 --> 00:02:23,900

Lacau And next.



24

00:02:24,950 --> 00:02:28,340

And now it will install everything which can take a little while.



25

00:02:37,000 --> 00:02:42,610

All right, so it looks like it's installed now, let's just see what's in here.



26

00:02:44,080 --> 00:02:51,340

So I'm going to search for Postgres and we have Postgres system software.



27

00:02:51,370 --> 00:02:51,930

OK.



28

00:02:54,720 --> 00:02:59,040

The documentation, that's the installer, I don't want to start that again.



29

00:03:01,250 --> 00:03:04,610

No, so I'll just cancel it, let's just see what happens.



30

00:03:04,640 --> 00:03:06,050

So it may be running, I have no idea.



31

00:03:06,050 --> 00:03:10,580

I haven't read the documentation yet, but I'll go back to my Web browser and I will now go over to



32

00:03:10,590 --> 00:03:13,610

Deaver and let's download Deaver.



33

00:03:14,180 --> 00:03:16,360

And again, it's just Beavertail.



34

00:03:16,360 --> 00:03:18,490

I'm going to download the version for Windows.



35

00:03:18,830 --> 00:03:24,620

I want the community edition 64 bit installer, and this will be the client we're going to use to install



36

00:03:24,650 --> 00:03:26,360

or to connect to our database locally.



37

00:03:26,450 --> 00:03:30,020

And I'm not sure if it's running yet because I don't use windows that often, but we'll figure it out.



38

00:03:35,470 --> 00:03:38,860

So Deaver's downloaded Let's Open the Installer.



39

00:03:41,890 --> 00:03:43,450

And I will use English.



40

00:03:45,300 --> 00:03:53,100

And I will choose next, and I agree to the terms and conditions, I'll allow anyone to use it, since



41

00:03:53,100 --> 00:03:54,970

there's only one account that's not really an issue.



42

00:03:55,530 --> 00:03:56,190

Yes.



43

00:03:59,030 --> 00:04:02,150

And it should fire up the installer or install it here for a shortly.



44

00:04:07,510 --> 00:04:17,590

OK, apparently I have to do this twice next, I agree, and we want that's all we want next.



45

00:04:19,080 --> 00:04:21,630

And next and next.



46

00:04:27,950 --> 00:04:31,640

Not sure why we had to do that twice, but I'm sure they had some reason when they put their installer



47

00:04:31,640 --> 00:04:32,030

together.



48

00:04:39,060 --> 00:04:44,470

All right, let's create a desktop shortcut so I can find it, and there it is.



49

00:04:45,120 --> 00:04:47,740

So let's start it up and see if our database is actually running.



50

00:04:48,090 --> 00:04:49,830

If not, we'll have to figure out how to start it.



51

00:05:06,880 --> 00:05:08,500

Allow access.



52

00:05:15,580 --> 00:05:17,310

OK, let's see if we can connect.



53

00:05:17,380 --> 00:05:19,690

Do you want to create a sample database that can be used?



54

00:05:19,690 --> 00:05:21,860

As you know, I don't want to create a sample database.



55

00:05:22,780 --> 00:05:23,290

All right.



56

00:05:23,290 --> 00:05:24,280

Select my database.



57

00:05:24,280 --> 00:05:28,330

My database is going to be Postgres right here next.



58

00:05:31,970 --> 00:05:37,160

And download the necessary files, so it goes and gets the necessary drivers for those and let's see



59

00:05:37,160 --> 00:05:37,780

if this works.



60

00:05:37,790 --> 00:05:41,030

So localhost is the host, postgrads is the database.



61

00:05:41,030 --> 00:05:42,410

There should be one called postgrads.



62

00:05:42,410 --> 00:05:44,930

Five, four, three, two is the correct port.



63

00:05:45,350 --> 00:05:52,450

And here's where I put in my password, which I set to password and let's say finish and see what happens.



64

00:05:55,340 --> 00:06:01,820

It looks like we are connected, perfect, and that's how you connect to the database, so that takes



65

00:06:01,820 --> 00:06:03,720

care of the installation for Windows.



66

00:06:03,790 --> 00:06:04,760

Let's move on.