Any success with 3rd party PostgreSQL Distributions such as YugabyteDB?

[sweickge]

We are looking at turning our Netbox docker community installation (v4.3.4) into a high availability deployment, and moving our PostgreSQL database from being a docker-based container to a VM-based cluster. I was wondering if anyone has had any success using a distributed PostgreSQL distribution, such as YugabyteDB for their deployment?

Right now I'm trying to evaluate YugabyteDB and I've been able to deploy the database cluster. However, after going through the Netbox specific steps to create the netbox user and empty netbox database in the cluster, after I try to start Netbox, the deployment fails during the database migration steps with timeout errors in psycopg driver

⚙️ Applying database migrations
🧬 loaded config '/etc/netbox/config/configuration.py'
🧬 loaded config '/etc/netbox/config/custom_validators.py'
🧬 loaded config '/etc/netbox/config/extra.py'
🧬 loaded config '/etc/netbox/config/logging.py'
🧬 loaded config '/etc/netbox/config/plugins.py'
Operations to perform:
  Apply all migrations: account, auth, circuits, contenttypes, core, dcim, django_rq, extras, ipam, sessions, social_django, taggit, tenancy, users, virtualization, vpn, wireless
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0001_initial... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying auth.0009_alter_user_last_name_max_length... OK
  Applying auth.0010_alter_group_name_max_length... OK
  Applying auth.0011_update_proxy_permissions... OK
  Applying auth.0012_alter_user_first_name_max_length... OK
  Applying users.0001_squashed_0011... OK
  Applying users.0002_squashed_0004... OK
  Applying account.0001_initial... OK
  Applying extras.0001_squashed... OK
  Applying tenancy.0001_squashed_0012... OK
  Applying dcim.0001_squashed... OK
  Applying dcim.0002_squashed... OK
  Applying ipam.0001_squashed... OK
  Applying virtualization.0001_squashed_0022... OK
  Applying extras.0002_squashed_0059... OK
  Applying tenancy.0002_squashed_0011... OK
  Applying dcim.0003_squashed_0130... OK
  Applying ipam.0002_squashed_0046... OK
  Applying wireless.0001_squashed_0008... OK
  Applying ipam.0047_squashed_0053... OK
  Applying dcim.0131_squashed_0159... OK
  Applying circuits.0001_squashed... OK
  Applying circuits.0002_squashed_0029... OK
  Applying circuits.0003_squashed_0037... OK
  Applying dcim.0160_squashed_0166... OK
  Applying core.0001_squashed_0005... OK
  Applying circuits.0038_squashed_0042... OK
  Applying extras.0060_squashed_0086... OK
  Applying extras.0087_squashed_0098... OK
  Applying extras.0099_cachedvalue_ordering... OK
  Applying extras.0100_customfield_ui_attrs... OK
Traceback (most recent call last):
  File "/opt/netbox/venv/lib/python3.12/site-packages/django/db/backends/base/base.py", line 303, in _commit
    return self.connection.commit()
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.12/site-packages/psycopg/connection.py", line 262, in commit
    self.wait(self._commit_gen())
  File "/opt/netbox/venv/lib/python3.12/site-packages/psycopg/connection.py", line 414, in wait
    return waiting.wait(gen, self.pgconn.socket, interval=interval)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "psycopg_c/_psycopg/waiting.pyx", line 213, in psycopg_c._psycopg.wait_c
  File "/opt/netbox/venv/lib/python3.12/site-packages/psycopg/_connection_base.py", line 580, in _commit_gen
    yield from self._exec_command(b"COMMIT")
  File "/opt/netbox/venv/lib/python3.12/site-packages/psycopg/_connection_base.py", line 478, in _exec_command
    raise e.error_from_result(result, encoding=self.pgconn._encoding)
psycopg.errors.SerializationFailure: current transaction is expired or aborted (query layer retry isn't possible, READ COMMITTED transaction was aborted  and some data was already sent to the user)
DETAIL:  Heartbeat: Transaction 824affdc-dd30-4e77-a465-6c1939f20b9a expired or aborted by a conflict: YB001 [read committed]

I'm just using the standard django PostgreSQL driver. I have tried increasing the timeouts parameters, but that doesn't seem to fix the issue.