0
1
00:00:01,350 --> 00:00:03,510
Welcome back to Backspace Academy.
1

2
00:00:03,900 --> 00:00:10,300
This lab will be similar to the one that you did in the first section where we introduce the database
2

3
00:00:10,320 --> 00:00:17,330
services of AWS and we created a MySQL RDS instance and we connected into that MySQL 
3

4
00:00:17,340 --> 00:00:20,540
instance using the MySQL workbench.
4

5
00:00:20,940 --> 00:00:26,920
What I'm going to do with this one is do a similar lab but with the Postgre database.
5

6
00:00:27,090 --> 00:00:36,360
So starting off here in the RDS dashboard will go to instances and launch DB instance and we make
6

7
00:00:36,360 --> 00:00:40,780
sure that we have the Free tier eligible only selected on the left hand side here.
7

8
00:00:41,280 --> 00:00:46,230
And we're going to go to PostgreSQL and we'll select that.
8

9
00:00:46,260 --> 00:00:50,540
Now I'm just going to leave the instant specifications as they are.
9

10
00:00:50,700 --> 00:00:53,470
We've got a pretty small DB instance which is fine.
10

11
00:00:53,580 --> 00:00:59,670
We don't need to worry about multi AZ deployment this is only going to be for testing purposes
11

12
00:00:59,670 --> 00:01:01,430
or learning purposes.
12

13
00:01:01,780 --> 00:01:07,770
Scroll down to the instance or identifier. I'm just going to call this instance testPostgreSQL
13

14
00:01:08,070 --> 00:01:16,080
and or give the user name Administrator this time, not admin because admin is used by the PostgreSQL
14

15
00:01:16,560 --> 00:01:23,590
database itself so you can't use admin but administrator you can use. Once you've put in your user name
15

16
00:01:23,680 --> 00:01:30,450
and put in your password, just click on the next step.
16

17
00:01:30,470 --> 00:01:36,680
Now I'm going to leave create security group as it is and what it will do it will create a security
17

18
00:01:36,680 --> 00:01:42,840
group that will have inbound access on the database port 5432.
18

19
00:01:43,610 --> 00:01:44,560
We will be creating
19

20
00:01:44,570 --> 00:01:51,230
a security group in the last of these series of labs were doing a database migration we will have another
20

21
00:01:51,770 --> 00:01:58,280
security group rule that will have access within the same security group and we will put our database
21

22
00:01:58,280 --> 00:02:06,570
name there and we just scroll down now and we can change our backup retention period to zero so that
22

23
00:02:06,570 --> 00:02:07,980
we don't do any automated backups.
23

24
00:02:07,980 --> 00:02:09,800
We don't need them if we lose this database
24

25
00:02:09,830 --> 00:02:11,290
it's no big deal for us.
25

26
00:02:11,460 --> 00:02:17,420
And we click on launch DB instance and we will view our DB instance now.
26

27
00:02:17,530 --> 00:02:24,070
So it's going to go from creating through to available and then we can move on to connecting to our
27

28
00:02:24,070 --> 00:02:24,690
database.
28

29
00:02:24,730 --> 00:02:30,600
After that happens. OK so our database is up and running there it's available.
29

30
00:02:30,600 --> 00:02:32,660
So we can connect into it.
30

31
00:02:32,670 --> 00:02:40,350
So the first thing we need to do is to download the pgAdmin. So go to pgadmin.org and download
31

32
00:02:40,350 --> 00:02:42,220
that.
32

33
00:02:42,300 --> 00:02:48,350
Now once you've downloaded and you've run the pgAdmin application, this is what it will look like.
33

34
00:02:48,350 --> 00:02:57,470
We need to go in to the quick links and add a new server. We'll put our name of our server which is 
34

35
00:02:57,490 --> 00:02:58,210
testpostgresql.
35

36
00:02:58,300 --> 00:03:07,150
We will put in our connection. That will be our hostname which is going to come from,
36

37
00:03:07,180 --> 00:03:10,570
or our endpoint is going to come from, our RDS instance.
37

38
00:03:10,600 --> 00:03:13,420
So I will just jump into the audience dashboard and I'll grab that
38

39
00:03:21,190 --> 00:03:24,720
and paste that in.
39

40
00:03:25,060 --> 00:03:27,480
And we just need to remove the 
40

41
00:03:27,490 --> 00:03:32,440
:5432 off the end of that because it's coming in here and that's all we need to do is
41

42
00:03:32,440 --> 00:03:34,070
just to put in our user name
42

43
00:03:37,550 --> 00:03:39,370
and the password.
43

44
00:03:43,750 --> 00:03:44,530
And click Save.
44

45
00:03:47,480 --> 00:03:49,700
Now that takes a little bit of time to set up.
45

46
00:03:49,760 --> 00:03:51,890
But when it does we'll be connected in to our.
46

47
00:03:52,070 --> 00:03:59,310
And there we go, straight into our testpostgresql  instance, and if we expand that we can see
47

48
00:03:59,310 --> 00:04:05,700
that we have some databases there and we have our sample db database that is inside there.
48

49
00:04:06,170 --> 00:04:13,840
So there we have it! We have created a PostgreSQL RDS instance and we connected into that and had a look inside
49

50
00:04:13,850 --> 00:04:14,270
it.
50

51
00:04:14,340 --> 00:04:15,530
I'll see you in the next one.