How to connect an AWS PostgreSQL database with Database Toolbox?

Hi everyone, I want to connect to my database located in AWS. I have a username and password, the host (something like "193.178.11.1"). If I try the line

datasource = "dev"; username = "myusername"; password = "xyz123%"; 
url = "193.178.11.1"; driver = ""; 
conn = database(datasource, username, password, driver, url)

and then type

conn.Message

I get the following message:

'No suitable driver found for 192.168.10.1dev'

Can anyone help please?

Answer 1

[Shrestha Kumar]

Hi,

It seems that you haven't installed the driver for the postgresql database. You can find all the drivers for different databases here - https://in.mathworks.com/help/database/ug/configuring-driver-and-data-source.html.

After installing the driver you can access the database with command -

conn = database('dbname','username','pwd', ... 'Vendor','PostgreSQL', ... 'Server','sname');