Looks like the database user on self-hosted installs lack the permissions to set this. A better way to set this is being tracked upstream, let’s wait for a fix there for a bit before trying to handle it
https://github.com/pgvector/pgvector/issues/235#issue-1860464316