In this post, I will write complete steps to install and configure Postgres RDS on Ubuntu 20 running on a VirtualBox over Windows 10 host.
Installing Postgres on Ubuntu 20
For easiness connect Ubuntu instance using Putty windows client. Now you can easily copy and paste commons on the putty console.
Steps to install Postgres
Update the local package index
~$ sudo apt update
Now install Postgres using the following command with some additional utilities and functionality. This will install the latest Postgres database.
~$ sudo apt install postgresql postgresql-contrib
Allow Remote connections to Postgres database
Configure listenning addess
~$ sudo nano /etc/postgresql/12/main/postgresql.conf
Now change, listen_addresses = ‘*’ or change ‘*” with IP.
By default remote connection is disabled. We need to open a remote connection using pg_hba.conf file
~$ sudo nano /etc/postgresql/12/main/pg_hba.conf
And change following
IPv4 local connections:
Add following line IPv4 local connections:
host all all 192.168.1.0/24 md5
This will allow connection from the windows host, or you can add the IP of your requirements.
Now open port for repot access
~$ sudo ufw allow 5432/tcp
After successful installation, you can install the Postgres server using the following command either with sudo or with Postgres user.
~$ sudo pg_ctlcluster 12 main start
Now you need to set a password for Postgres default user.
~$ sudo -u postgres psql
This will open PG client console now you can change password using sql.
ALTER USER postgres PASSWORD 'mypassword';
Now you can connect Postgres from other instances or windows host.
Open PGAdmin windows tool to check the connection of the database. Using this GUI management tool you can do almost everything.
Please refer to Postgres documentation for more details.