Head over to our Digital Ocean marketplace listing and create your droplet. You are free to create one even at the most basic configuration. No restrictions for you here.
Set up the password for the DB Superuser postgres.
SSH into your instance using the user root and type in the following once you are in:
$ sudo -u postgres psql
This logs you into the psql terminal as the DB Superuser postgres.
Set your password with this command:
Enter your desired password afterward and re-enter it when prompted. Once done, you can now exit your SSH connection.
With any SQL client of your choice (Such as DBeaver), connect to your database with the following credentials:
- Host: insert droplet ip address
- Port: 5432
- User: postgres
- Password: insert your chosen password
- Database: postgres