search

teksi / district_heating

Future TEKSI distance heating module
https://teksi.github.io/district_heating/
GNU General Public License v3.0
0 stars 0 forks source link

Get latest datamodel dump and install tdh data model #44

Open sjib opened 3 months ago

sjib commented 3 months ago

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 commented 3 months ago

You should now have also vw_pipe_point_feed and vw_pipe_point_normal with triggers:

20240810_vw_pipe_point_feed

sjib commented 3 months ago

@jpdupuy Can you test if this solves https://github.com/teksi/district_heating/issues/22

sjib commented 3 months ago

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

ponceta commented 3 months ago

@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!