Test for successful connection to server's database Clone the repository git clone https://github.com/haugmarkus/HealthInformaticsDatabaseConnectionTest.git Populate .env file with your credentials DB_USERNAME=username DB_PASSWORD=pw DB_PORT=65432 DB_SERVER=localhost DB_NAME=maitt Initiate ssh connection ssh -L 65432:localhost:5432 username@server_name Run the code in test.R Rscript test.R If succesful you should see: > test_dbi_connection() [1] "Connection successful with DBI" > test_database_connector_connection() Connecting using PostgreSQL driver [1] "Connection successful with DatabaseConnector"