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

Get latest datamodel dump and install tdh data model #44

Open
sjib opened this issue Aug 10, 2024 · 4 comments
Open

Get latest datamodel dump and install tdh data model #44

sjib opened this issue Aug 10, 2024 · 4 comments
Labels
documentation Improvements or additions to documentation

Comments

@sjib
Copy link
Contributor

sjib commented Aug 10, 2024

You can check out the latest datamodel dump from this page:
https://github.com/teksi/district_heating/actions/workflows/datamodel-create-dumps.yml

20240810_checkout_database_dump_tdh

Select the latest version from the Artifacts:
20240810_checkout_database_dump_tdh_2

Download datamodel-dumps.zip

20240810_tdh_restore_backup

Use the tdh_dev_structure_and_demo_data.backup out of this zip file to restore with pgAdmin

note:
If your restore fails with: pg_restore: error: could not execute query: FEHLER: Rolle »tdh_viewer« existiert nicht
create the roles first:
https://github.com/teksi/district_heating/blob/main/datamodel/12_0_roles.sql (for database cluster) -> download as raw
https://github.com/teksi/district_heating/blob/main/datamodel/12_1_roles.sql (for database) -> download as raw

20240810_download_12_1_roles sql

20240810_query_tools_create_roles

@sjib
Copy link
Contributor Author

sjib commented Aug 10, 2024

You should now have also vw_pipe_point_feed and vw_pipe_point_normal with triggers:

20240810_vw_pipe_point_feed

@sjib
Copy link
Contributor Author

sjib commented Aug 10, 2024

@jpdupuy Can you test if this solves #22

@sjib sjib changed the title Get latest datamodel dump Get latest datamodel dump and install tdh data model Aug 10, 2024
@sjib sjib added the documentation Improvements or additions to documentation label Aug 10, 2024
@sjib
Copy link
Contributor Author

sjib commented Aug 10, 2024

@ponceta Is this the process that you mentioned yesterday? Anything missing?

@ponceta
Copy link
Member

ponceta commented Aug 15, 2024

@sjib yes it is right thank you!

We can also create early release versions if we find that we already have something to play with!

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

No branches or pull requests

2 participants