Welcome back to Backspace Academy. 1
This lab will be similar to the one that you did in the first section where we introduce the database 2
services of AWS and we created a MySQL RDS instance and we connected into that MySQL 3
instance using the MySQL workbench. 4
What I'm going to do with this one is do a similar lab but with the Postgre database. 5
So starting off here in the RDS dashboard will go to instances and launch DB instance and we make 6
sure that we have the Free tier eligible only selected on the left hand side here. 7
And we're going to go to PostgreSQL and we'll select that. 8
Now I'm just going to leave the instant specifications as they are. 9
We've got a pretty small DB instance which is fine. 10
We don't need to worry about multi AZ deployment this is only going to be for testing purposes 11
or learning purposes. 12
Scroll down to the instance or identifier. I'm just going to call this instance testPostgreSQL 13
and or give the user name Administrator this time, not admin because admin is used by the PostgreSQL 14
database itself so you can't use admin but administrator you can use. Once you've put in your user name 15
and put in your password, just click on the next step. 16
Now I'm going to leave create security group as it is and what it will do it will create a security 17
group that will have inbound access on the database port 5432. 18
We will be creating 19
a security group in the last of these series of labs were doing a database migration we will have another 20
security group rule that will have access within the same security group and we will put our database 21
name there and we just scroll down now and we can change our backup retention period to zero so that 22
we don't do any automated backups. 23
We don't need them if we lose this database 24
it's no big deal for us. 25
And we click on launch DB instance and we will view our DB instance now. 26
So it's going to go from creating through to available and then we can move on to connecting to our 27
database. 28
After that happens. OK so our database is up and running there it's available. 29
So we can connect into it. 30
So the first thing we need to do is to download the pgAdmin. So go to pgadmin.org and download 31
that. 32
Now once you've downloaded and you've run the pgAdmin application, this is what it will look like. 33
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
testpostgresql. 35
We will put in our connection. That will be our hostname which is going to come from, 36
or our endpoint is going to come from, our RDS instance. 37
So I will just jump into the audience dashboard and I'll grab that 38
and paste that in. 39
And we just need to remove the 40
:5432 off the end of that because it's coming in here and that's all we need to do is 41
just to put in our user name 42
and the password. 43
And click Save. 44
Now that takes a little bit of time to set up. 45
But when it does we'll be connected in to our. 46
And there we go, straight into our testpostgresql instance, and if we expand that we can see 47
that we have some databases there and we have our sample db database that is inside there. 48
So there we have it! We have created a PostgreSQL RDS instance and we connected into that and had a look inside 49
it. 50
I'll see you in the next one.