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

Works only on postgres db? #25

Open
adi-kmt opened this issue Jun 10, 2024 · 2 comments
Open

Works only on postgres db? #25

adi-kmt opened this issue Jun 10, 2024 · 2 comments

Comments

@adi-kmt
Copy link

adi-kmt commented Jun 10, 2024

I tried making it work on another db inside the same container but I can't seem to select the extension 😕

@jasonmp85
Copy link
Contributor

Can you give details about how you're starting the container, and how you're configuring the extension? This should be possible to accomplish, but I'll need a few more details.

@amR0ssi
Copy link

amR0ssi commented Dec 10, 2024

Same issue. I've got multiple Timescale databases and would like to try out pg_timeseries project.

Started the docker container as in instructions and managed to install the extensions into postgres database
image

Then creating a new database "test" and trying to install the extension there:
image

According to pg_cron docs one should schedule jobs in another database by

SELECT cron.schedule_in_database('weekly-vacuum', '0 4 * * 0', 'VACUUM', 'some_other_database');

Presently installing in other database than where pg_cron is installed is not possible?
image

Thanks for an interesting project!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants