Persistent Errors When Restoring GitLab CE Backup

GitLab CI/CD
1

Hi everyone,

I’ve been encountering the following errors whenever I restore an application backup (.tar) in GitLab CE:

image
image1008×274 10.4 KB

Restoring PostgreSQL database gitlabhq_production
ERROR: must be owner of extension pg_trgm
ERROR: must be owner of extension btree_gist
ERROR: must be owner of extension btree_gist
ERROR: must be owner of extension pg_trgm

These errors have been showing up for the past 1–2 years during every backup restoration. However, I haven’t noticed any immediate issues after the restore, and the system seems to function normally.

I came across a similar discussion here, but it didn’t fully address my concern.

Could someone confirm if these errors could cause any long-term issues, or if they can be safely ignored? Also, is there a recommended way to fix them?

Thanks in advance for your help!

2

Those extensions are not problematic, everyone has it. They don’t cause problems for upgrade. I also searched for it once, not as a Gitlab error, but rather relating to PostgreSQL which tells you more about ensuring the correct permissions in the database for those particular extensions. But as they are not being used, there really isn’t any point.