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 simple smile

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.

Hey @Jeremiah simple smile Thanks a lot for the valuable info!