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 and a new user, now let's test the connection
0:06 and make sure that everything that we put in place works. Take a look at your host file for the IP address
0:12 of the database server, and we're going to SSH into that server. Once we've connected, use the psql command
0:25 with the name of the database that we created which in our case is chapter6. We're able to connect and while we don't currently
0:31 have any tables in the database we could create one if we wanted to. So now that we know we have access to the database
0:44 in this specific instance installed and we could go ahead and configure this database with a custom configuration
0:49 which is what we're going to do in the next chapter as we deploy an example application using Ansible. You can quit Postgres with control-D
0:57 and drop the SSH connection with control-D as well.