Been working with Auth0, and want to use an external database for user definitions
Is is possible, and how, to expose the postgres database from my project to be accessible on the internet (with appropriate security)? An alternative is to use an API, which may be a better way to go.
It is not possible to get access to the database that is provisioned along with an Apex Cloud App Manager. If you need direct access, you can set up your own Postgres database and whitelist the Apex Cloud outbound IP. If you go that route, just submit an Intercom question in Apex Designer and we will give you the IP.
If you are not comfortable with that, you can set up an app manager to run inside your VPC where it could access the Postgres server.
When you say ‘you can set up your own Postgres database and whiltelist…’ do you mean a standalone project with nothing else in it to get a Postgres database?
I appreciate the other option as well, running inside your own VPC…
In my case, I may pursue using an API to provide user info to Auth0 (as opposed to an external database providing that data).
Apologies for the delayed response.
As an example, you could create an RDS database in AWS, expose that database to the internet, and then put the outbound IP address of Apex Designer in the whitelist for your database. If you want to do this, just submit an Intercom request and we will give you that IP.