Hi,

so which tables actually do need replication?


                              List of relations
       Schema       |                Name
--------------------+-------------------------------------
au                 | referral
audit              | audit_fields                        no
audit              | audit_trail                         no
audit              | audited_tables                      no
audit              | log_access_log                      no
audit              | log_active_substance                no
audit              | log_address                         no
audit              | log_allergy                         no
audit              | log_allergy_state                   no
audit              | log_beh_fall_typ                    no
audit              | log_behandlungsfall                 no
audit              | log_branded_drug                    no
audit              | log_clin_aux_note                   no
audit              | log_clin_diag                       no
audit              | log_clin_item_type                  no
audit              | log_clin_narrative                  no
audit              | log_consumable_substance            no
audit              | log_consumed_substance              no
audit              | log_data_source                     no
audit              | log_doc_desc                        no
audit              | log_doc_med                         no
audit              | log_encounter                       no
audit              | log_episode                         no
audit              | log_family_history                  no
audit              | log_fhx_relation_type               no
audit              | log_form_data                       no
audit              | log_form_instances                  no
audit              | log_gender_label                    no
audit              | log_health_issue                    no
audit              | log_hospital_stay                   no
audit              | log_hx_family_item                  no
audit              | log_identity                        no
audit              | log_identity_tag                    no
audit              | log_inbox_item_category             no
audit              | log_inbox_item_type                 no
audit              | log_incoming_data_unmatchable       no
audit              | log_incoming_data_unmatched         no
audit              | log_lab_request                     no
audit              | log_lab_test_gnr                    no
audit              | log_lnk_code2aoe                    no
audit              | log_lnk_code2episode                no
audit              | log_lnk_code2fhx                    no
audit              | log_lnk_code2h_issue                no
audit              | log_lnk_code2narrative              no
audit              | log_lnk_code2procedure              no
audit              | log_lnk_code2rfe                    no
audit              | log_lnk_constraint2vacc_course      no
audit              | log_lnk_identity2ext_id             no
audit              | log_lnk_identity2primary_doc        no
audit              | log_lnk_job2person                  no
audit              | log_lnk_org_unit2comm               no
audit              | log_lnk_org_unit2ext_id             no
audit              | log_lnk_pat2vaccination_course      no
audit              | log_lnk_person2relative             no
audit              | log_lnk_substance2brand             no
audit              | log_lnk_tst2norm                    no
audit              | log_lnk_type2item                   no
audit              | log_lnk_vaccination_course2schedule no
audit              | log_lnk_vaccine2inds                no
audit              | log_message_inbox                   no
audit              | log_occupation                      no
audit              | log_operation                       no
audit              | log_org                             no
audit              | log_org_unit                        no
audit              | log_paperwork_templates             no
audit              | log_prax_geb_paid                   no
audit              | log_procedure                       no
audit              | log_referral                        no
audit              | log_relation_types                  no
audit              | log_report_query                    no
audit              | log_staff                           no
audit              | log_staff_role                      no
audit              | log_state                           no
audit              | log_street                          no
audit              | log_substance_in_brand              no
audit              | log_substance_intake                no
audit              | log_tag_image                       no
audit              | log_test_org                        no
audit              | log_test_result                     no
audit              | log_test_type                       no
audit              | log_urb                             no
audit              | log_vacc_indication                 no
audit              | log_vacc_route                      no
audit              | log_vaccination                     no
audit              | log_vaccination_course              no
audit              | log_vaccination_course_constraint   no
audit              | log_vaccination_definition          no
audit              | log_vaccination_schedule            no
audit              | log_vaccine                         no
audit              | log_vaccine_batches                 no
audit              | log_waiting_list                    no
audit              | log_xlnk_identity                   no
bill               | bill_item
blobs              | doc_desc
blobs              | doc_med
blobs              | doc_obj
blobs              | doc_type
blobs              | lnk_doc2hospital_stay
blobs              | lnk_doc_med2episode
blobs              | reviewed_doc_objs
cfg                | cfg_data
cfg                | cfg_item
cfg                | cfg_numeric
cfg                | cfg_str_array
cfg                | cfg_string
cfg                | cfg_template
cfg                | cfg_type_enum
cfg                | config
cfg                | db_logon_banner
cfg                | report_query
clin               | _enum_allergy_type
clin               | active_substance
clin               | allergy
clin               | allergy_state
clin               | clin_aux_note
clin               | clin_diag
clin               | clin_item_type
clin               | clin_narrative
clin               | clin_root_item
clin               | encounter
clin               | encounter_type
clin               | episode
clin               | family_history
clin               | fhx_relation_type
clin               | form_data
clin               | form_instances
clin               | health_issue
clin               | hospital_stay
clin               | incoming_data_unmatchable
clin               | incoming_data_unmatched
clin               | keyword_expansion
clin               | lab_request
clin               | lnk_code2aoe
clin               | lnk_code2episode
clin               | lnk_code2fhx
clin               | lnk_code2h_issue
clin               | lnk_code2item_root
clin               | lnk_code2narrative
clin               | lnk_code2procedure
clin               | lnk_code2rfe
clin               | lnk_constraint2vacc_course
clin               | lnk_pat2vaccination_course
clin               | lnk_substance2episode
clin               | lnk_tst2norm
clin               | lnk_ttype2unified_type
clin               | lnk_type2item
clin               | lnk_vaccination_course2schedule
clin               | lnk_vaccine2inds
clin               | meta_test_type
clin               | procedure
clin               | review_root
clin               | reviewed_test_results
clin               | soap_cat_ranks
clin               | substance_intake
clin               | test_org
clin               | test_result
clin               | test_type
clin               | vacc_indication
clin               | vacc_route
clin               | vaccination
clin               | vaccination_course
clin               | vaccination_course_constraint
clin               | vaccination_definition
clin               | vaccination_schedule
clin               | vaccine
clin               | vaccine_batches
clin               | waiting_list
de_de              | beh_fall_typ
de_de              | behandlungsfall
de_de              | kvk
de_de              | lab_test_gnr
de_de              | payment_method
de_de              | prax_geb_paid
de_de              | zuzahlungsbefreiung
dem                | address
dem                | address_type
dem                | country
dem                | enum_comm_types
dem                | enum_ext_id_types
dem                | gender_label
dem                | identity
dem                | identity_tag
dem                | inbox_item_category
dem                | inbox_item_type
dem                | lnk_identity2comm
dem                | lnk_identity2ext_id
dem                | lnk_job2person
dem                | lnk_org_unit2comm
dem                | lnk_org_unit2ext_id
dem                | lnk_person2relative
dem                | lnk_person_org_address
dem                | marital_status
dem                | message_inbox
dem                | name_gender_map
dem                | names
dem                | occupation
dem                | org
dem                | org_category
dem                | org_unit
dem                | relation_types
dem                | staff
dem                | staff_role
dem                | state
dem                | street
dem                | urb
gm                 | access_log
gm                 | notifying_tables
gm                 | schema_revision
i18n               | curr_lang
i18n               | keys
i18n               | translations
information_schema | sql_features                        no
information_schema | sql_implementation_info             no
information_schema | sql_languages                       no
information_schema | sql_packages                        no
information_schema | sql_parts                           no
information_schema | sql_sizing                          no
information_schema | sql_sizing_profiles                 no
pg_catalog         | pg_aggregate                        no
pg_catalog         | pg_am                               no
pg_catalog         | pg_amop                             no
pg_catalog         | pg_amproc                           no
pg_catalog         | pg_attrdef                          no
pg_catalog         | pg_attribute                        no
pg_catalog         | pg_auth_members                     no
pg_catalog         | pg_authid                           no
pg_catalog         | pg_cast                             no
pg_catalog         | pg_class                            no
pg_catalog         | pg_collation                        no
pg_catalog         | pg_constraint                       no
pg_catalog         | pg_conversion                       no
pg_catalog         | pg_database                         no
pg_catalog         | pg_db_role_setting                  no
pg_catalog         | pg_default_acl                      no
pg_catalog         | pg_depend                           no
pg_catalog         | pg_description                      no
pg_catalog         | pg_enum                             no
pg_catalog         | pg_extension                        no
pg_catalog         | pg_foreign_data_wrapper             no
pg_catalog         | pg_foreign_server                   no
pg_catalog         | pg_foreign_table                    no
pg_catalog         | pg_index                            no
pg_catalog         | pg_inherits                         no
pg_catalog         | pg_language                         no
pg_catalog         | pg_largeobject                      no
pg_catalog         | pg_largeobject_metadata             no
pg_catalog         | pg_namespace                        no
pg_catalog         | pg_opclass                          no
pg_catalog         | pg_operator                         no
pg_catalog         | pg_opfamily                         no
pg_catalog         | pg_pltemplate                       no
pg_catalog         | pg_proc                             no
pg_catalog         | pg_rewrite                          no
pg_catalog         | pg_seclabel                         no
pg_catalog         | pg_shdepend                         no
pg_catalog         | pg_shdescription                    no
pg_catalog         | pg_statistic                        no
pg_catalog         | pg_tablespace                       no
pg_catalog         | pg_trigger                          no
pg_catalog         | pg_ts_config                        no
pg_catalog         | pg_ts_config_map                    no
pg_catalog         | pg_ts_dict                          no
pg_catalog         | pg_ts_parser                        no
pg_catalog         | pg_ts_template                      no
pg_catalog         | pg_type                             no
pg_catalog         | pg_user_mapping                     no
public             | basic_unit
public             | form_field_types
public             | form_fields
public             | form_job_queue
public             | form_job_targets
public             | form_print_defs
public             | gm_client_db_match
public             | housekeeping_todo
public             | test_norm
public             | unit
ref                | atc
ref                | atc_staging
ref                | branded_drug
ref                | code_thesaurus_root
ref                | coding_system_root
ref                | consumable_substance
ref                | data_source
ref                | document_type
ref                | form_types
ref                | icd10
ref                | icd9
ref                | icpc
ref                | icpc_chapter
ref                | icpc_component
ref                | icpc_thesaurus
ref                | lnk_substance2brand
ref                | loinc
ref                | loinc_staging
ref                | ops
ref                | other_code
ref                | papersizes
ref                | paperwork_templates
ref                | tag_image
staging            | lab_request                         no
staging            | test_result                         no
(301 rows)

???

Marc

_______________________________________________
Gnumed-devel mailing list
Gnumed-devel@gnu....
https://lists.gnu.org/mailman/listinfo/gnumed-devel