Using existing Postgres DB for Central

Hi Everyone,

My company wants to host the Odb-Central server on premise, and we want the ODK-Central to connect to our Postgress instance, is this possible? If yes then where I can get the schema to load into our db?

Jdang

1 Like

These are the resources I'd recommend...

ODK will autogenerate the shema on first start, no need to preload it.

1 Like

thanks, I will take a look.

Jdang

@yanokwa, I followed all steps in this section:


from this doc https://docs.getodk.org/central-install-digital-ocean/#using-a-custom-database-server.
However, when I start my docker compose file, I see this error:
even though I can connect to my external Db

What else do I need to do?

Thanks,

Jdang

This post help alot. Issues with connecting postgres (localhost) with latest odk central (v 2023.2) - #7 by Arunbala.
and here is the details about the solution:

2 Likes