Thread
#prefect-server
    ale

    ale

    1 year ago
    Hey folks, I have a question regarding Prefect backend db. We’re using Bucardo to replicate/sync Prefect server backend database. Bucardo is complaining about the following tables not having a primary key defined:
    public.log
    hdb_catalog.hdb_schema_update_event
    hdb_catalog.hdb_custom_types
    utility.traversal
    We are thinking of skipping replication/sync of these tables, but I’m not sure if they contain important data that we should replicate. Any suggestion/advice is welcome 😒imple_smile:
    Jeremiah

    Jeremiah

    1 year ago
    Hi @ale -
    public.log
    contains logs from your workflows, so it may be something you want to replicate. The others are not important - two are Hasura metadata that can be recreated at any time and
    traversal
    is for reference only.
    log
    has no PK for legacy performance reasons.
    ale

    ale

    1 year ago
    Hey @Jeremiah 😒imple_smile: Thanks a lot for the valuable info!