1
00:00:00,180 --> 00:00:08,010
So it is quite easy and I think natural if you want to use another DBMS, such as my school or another

2
00:00:08,010 --> 00:00:09,540
database in PostgreSQL.

3
00:00:09,540 --> 00:00:15,130
Well, so I'm going to change the current database to another one in PostgreSQL.

4
00:00:15,130 --> 00:00:15,420
Well.

5
00:00:16,300 --> 00:00:20,080
But before I do that, I need to create a database.

6
00:00:21,710 --> 00:00:26,710
So these are my workspaces, but I'm not going to need them now.

7
00:00:28,080 --> 00:00:31,200
So I'm going to disconnect from the MSF three database.

8
00:00:32,450 --> 00:00:35,030
Then exit from Métis Point.

9
00:00:36,010 --> 00:00:43,960
Now, I think it's good practice to stop PostgreSQL for a while, then started again, but this is just

10
00:00:44,200 --> 00:00:45,310
one of my old habits.

11
00:00:46,470 --> 00:00:48,090
That I pass on to you.

12
00:00:49,500 --> 00:00:54,900
OK, so now I'm going to get the full name of the PostgreSQL user by these commands.

13
00:00:55,890 --> 00:01:04,240
Name is most grass type as you post grass to get into PostgreSQL.

14
00:01:04,300 --> 00:01:06,180
Well, use Herschelle.

15
00:01:07,470 --> 00:01:13,020
Now, here, you're not going to need a password because the default installation, there is no password.

16
00:01:14,070 --> 00:01:17,670
Now, the logic is the same if there is a password, you will need to type it.

17
00:01:18,520 --> 00:01:24,790
All right, then, list databases with you well know.

18
00:01:25,690 --> 00:01:27,490
And here are the database's.

19
00:01:28,850 --> 00:01:40,260
So now I'm going to create a user first by using the Create User Command great user user for MSF, Pete,

20
00:01:40,760 --> 00:01:44,390
and we're going to enter my very strong password two times.

21
00:01:45,110 --> 00:01:48,800
And now let's create a database by Create DB.

22
00:01:49,230 --> 00:01:54,210
That's the command that is owned by the user for MSF that we just created.

23
00:01:54,770 --> 00:02:02,610
So create DB DB for MSF owner equals user for MSF.

24
00:02:03,440 --> 00:02:03,920
All right.

25
00:02:03,920 --> 00:02:06,050
So let's list the databases.

26
00:02:07,500 --> 00:02:15,300
And sure enough, here I have the database, so I am now finished with PostgreSQL and I'm going to exit.

27
00:02:16,310 --> 00:02:19,740
And I'll open MSF console in quiet mode again.

28
00:02:20,340 --> 00:02:25,040
Hey, it's finally open and let's just quickly check the DB status.

29
00:02:25,460 --> 00:02:30,040
So as you can see here, it connects to the default database.

30
00:02:30,560 --> 00:02:34,710
So now I'm going to disconnect from that database and that's successful.

31
00:02:35,270 --> 00:02:43,220
Now I'm going to connect to my new database, DB for MSF, DV Connect user for MSF.

32
00:02:44,120 --> 00:02:53,150
One, two, three, four, and localhost colon, five, four, three, two, slashed before as one,

33
00:02:53,150 --> 00:02:57,230
two, three, four is my strong password, as you can see.

34
00:02:58,240 --> 00:03:01,930
All right, so now let's check the status of the database.

35
00:03:02,290 --> 00:03:02,840
OK, good.

36
00:03:03,130 --> 00:03:05,710
So here you see that I have connected the new one.

37
00:03:06,610 --> 00:03:14,380
And you can now work within the workspaces, add the lead juice, it's all on you now.