https://prefect.io logo
Title
a

ale

03/08/2021, 12:52 PM
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:
j

Jeremiah

03/08/2021, 2:49 PM
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.
a

ale

03/08/2021, 2:49 PM
Hey @Jeremiah 😒imple_smile: Thanks a lot for the valuable info!