> For the complete documentation index, see [llms.txt](https://aws-postgresql-docs.beliciarodriguez.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://aws-postgresql-docs.beliciarodriguez.com/ubuntu-configuring-instance/overview.md).

# Overview

Now that our Ubuntu instance is running on AWS EC2, we will now SSH into our instance and configure PostgreSQL (Version 12.4).

In this chapter, I will give instructions and rationale on how to do the following:

1. Install PostgreSQL
2. Create roles for PostgreSQL
3. Allow for remote connections

Be sure to SSH into your instance before following the instructions.

### References

*Guides*

(1) TecMint, *How to Install PostgreSQL and pgAdmin4 in Ubuntu 20.04*, <https://www.tecmint.com/install-postgresql-and-pgadmin-in-ubuntu/>

(2) DigitalOcean, *How To Install and Use PostgreSQL on Ubuntu 20.04*, <https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04>

(3) Better Programming (Medium), *How to Provision a Cheap PostgreSQL Database in AWS EC2*, <https://medium.com/better-programming/how-to-provision-a-cheap-postgresql-database-in-aws-ec2-9984ff3ddaea>

(4) The Geek Stuff, *How to Allow Remote Connection to PostgreSQL Database using psql*, <https://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/>

*Documentations*

(5) PostgreSQL 12 Documentation, *Chapter 20. Client Authentication*, <https://www.postgresql.org/docs/13/client-authentication.html>

(6) PostgreSQL 12 Documentation, *20.1. The pg\_hba.conf File*, <https://www.postgresql.org/docs/12/auth-pg-hba-conf.html>

(7) PostgreSQL 12 Documentation, *20.5. Password Authentication*, <https://www.postgresql.org/docs/12/auth-password.html>

(8) PostgreSQL 12 Documentation, *19.3 Connections and Authentications*, <https://www.postgresql.org/docs/12/runtime-config-connection.html>

*Forums*

(9) StackExchange, *Difference between sudo user and root user*, <https://unix.stackexchange.com/questions/291454/difference-between-sudo-user-and-root-user>

(10) StackOverflow, *How do I exit the vim editor?*, <https://stackoverflow.com/questions/11828270/how-do-i-exit-the-vim-editor>

(11) AskUbuntu, *How to install updates via command line?*, <https://askubuntu.com/questions/196768/how-to-install-updates-via-command-line>

(12) AskUbuntu, *Is there a command to list all users? Also to add, delete, modify users, in the terminal?*, <https://askubuntu.com/questions/410244/is-there-a-command-to-list-all-users-also-to-add-delete-modify-users-in-the>

(13) Unix StackExchange, *What is the difference between su username and su - username?*, <https://unix.stackexchange.com/questions/384700/what-is-the-difference-between-su-username-and-sudo-su-username>

(14) AskUbuntu, *'sudo su -' vs 'sudo -i' vs 'sudo /bin/bash' - when does it matter which is used, or does it matter at all?,* <https://askubuntu.com/questions/376199/sudo-su-vs-sudo-i-vs-sudo-bin-bash-when-does-it-matter-which-is-used>

(15) Stack Overflow, *How to configure PostgresSQL postgresql.conf listen\_addresses for multiple ip addresses* <https://stackoverflow.com/questions/9764126/how-to-configure-postgresql-postgresql-conf-listen-addresses-for-multiple-ip-add>

(16) AskUbuntu, *What does -y mean in apt get -y install command,*  <https://askubuntu.com/questions/672892/what-does-y-mean-in-apt-get-y-install-command>