Using an external database[Docker]

Getting Started
1

Hello, I hope to be able to configure an external postgre database for datalore, which can facilitate me to monitor the running status of various services and reduce overhead.

2

dose the external database sits on the same host or not ?
Datalore has many predefined sql tables i guess and they might not just running a simple instance of postgresql according to the container.

What you can do is, you can expost the postgres to your host, then you can do all that monitoring or etc tasks

3

I was able to configure an external database for Datalore using the following environment variables:

DB_USER: <username>
DB_PASSWORD: <password>
DB_URL: "jdbc:postgresql://host:5432/db_name"

I had some difficulty with additional settings, e.g. ?sslMode=require and similar, however without the query string on the URL it seems to work.

1 Like
4

It should be enough to set DB-specific environment variables as @glinklater wrote.

I had some difficulty with additional settings, e.g. ?sslMode=require and similar, however without the query string on the URL it seems to work.

These arguments are case-sensitive, you need to specify sslmode in lower register.

Thank you!

1 Like