Use AWS RDS PostGres to store annotations

1

Hello,

We would like to use AWS managed RDS Postgres service to store the annotations. We have modified below config but we are not able to make the connection. Any idea if this configuration is supported.
{
"port": 80,
"host": "0.0.0.0",
"db": "postgresql",
"db_settings": {
"postgresql": {
"user": "RDS_DB_USER",
"password": "RDS_DB_PASSWORD",
"host": "RDS_DB_HOST",
"port": 5432,
"database": "RDS_DB_NAME"
}
},
"feed_overlap": false,
"show_stats": true
}

2

hi @vivek_iiitm1,

Thanks for your question and welcome to the Prodigy community :wave:

I haven't tested AWS managed RDS Postgres service (although I have used multiple other hosted Postgres services like our docs show with DigitalOcean) so I can't see any reason why it wouldn't work for AWS but not have any issues with others.

What are the error messages you're seeing? When do you see them?

Are you 100% sure you're pointing to the right prodigy.json file? Per the docs:

When you run Prodigy, it will first check if a global configuration file exists. It will also check the current working directory for a prodigy.json or .prodigy.json . This allows you to overwrite specific settings on a project-by-project basis.

For example, have you run logging to confirm you're using the right prodigy.json?

I've seen a lot of new users accidentally point to the wrong prodigy.json they intended for.

All of this also assumes your user, password, etc. are correct (which, of course, we can't confirm on our end).