In this article, we will be learning how to set up a remote Postgres database server to use for your projects. It is highly scalable and widely popular. Postgres is a powerful relational database management system, it can handle large workloads from a single machine to that of a data center. Setting up a remote Postgres database server on Ubuntu 18.04 Going off the screenshot, the host would be 54.172.123.217, the username would be bitnami and the private key file can be downloaded by clicking “Download default key”.Michael Okoh Follow I code, that's all. You can find all 3 of those on the “Connect” tab for your Lightsail instance in the AWS console.

You’ll also need the host, username, and private key file. The SSH port you want to connect on is 22. One is the port, and I’ll give that to you know. There are 4 pieces of info needed for the SSH connection. All you need to do is gather a few extra connection details when configuring the GUI connection. TablePlus, MySQL Workbench, and many others support database connections over SSH.

So your GUI will SSH into the Lightsail instance and then connect to the local database process. Instead, you’ll need to connect to the database over SSH.

There’s no external database IP you can directly connect to from your local machine. The database you’re trying to connect to is running as a local process on your Lightsail instance. This will also work for any database GUI that supports SSH connections. In this post, I’ll show you how to connect to the database from TablePlus and MySQL Workbench. How do I connect to the Lightsail database from the GUI I use on my Mac? I got the WordPress sites up and running, but I ran into an issue. I was looking for an easy way to spin up multiple WordPress websites for a plugin I’m working on and Lightsail was exactly the kind of tool I wanted. Earlier this summer I learned about AWS Lightsail.

Tableplus create local database