Introduction to Ansible Transcripts
Chapter: Configuring Servers
Lecture: Testing the Database Connection

Login or purchase this course to watch this video and the rest of the course contents.
0:00 We installed Postgres, created a database instance
0:03 and a new user, now let's test the connection
0:05 and make sure that everything that we put in place works.
0:09 Take a look at your host file for the IP address
0:11 of the database server, and we're going to SSH
0:13 into that server.
0:21 Once we've connected, use the psql command
0:24 with the name of the database that we created
0:25 which in our case is chapter6.
0:27 We're able to connect and while we don't currently
0:30 have any tables in the database
0:32 we could create one if we wanted to.
0:41 So now that we know we have access to the database
0:43 in this specific instance installed
0:44 and we could go ahead and configure this database
0:47 with a custom configuration
0:48 which is what we're going to do in the next chapter
0:50 as we deploy an example application using Ansible.
0:54 You can quit Postgres with control-D
0:56 and drop the SSH connection with control-D as well.