Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ability to reload schema config/cache without a restart #630

Closed
saosebastiao opened this issue Apr 3, 2023 · 1 comment
Closed

Add ability to reload schema config/cache without a restart #630

saosebastiao opened this issue Apr 3, 2023 · 1 comment

Comments

@saosebastiao
Copy link

I would love to be able to reload the schema config without a full restart. The PostgREST project has two cool ways to do this:

https://postgrest.org/en/stable/schema_cache.html#schema-cache-reloading

  • listen for a SIGUSR1 signal
  • Using Postgres' LISTEN/NOTIFY with a dedicated channel

The second method in particular is interesting because it allows the DB admin to set up custom triggers that would send notifications to the custom channel any time a geospatial table changes.

@nyurik
Copy link
Member

nyurik commented Apr 3, 2023

This is a dup of #288 - could you add your notes there? I really like the LISTEN/NOTIFY idea

@nyurik nyurik closed this as completed Apr 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants