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.