Postgres vector extension
From what I can tell it's already installed, but it errors when I run a migration with the vector type
Also trying to enable it manually with
results in
Solution:
Jump to solution
Or to explain it a bit better, since my previous message merges databases and schemas into one (sorry for the confusion).
We create 2 users,
postgres and db (this one is named as your service) and they both have public schema.
So when you login as postgres user, it will by default select postgres database, and you need to switch to db to install extenstions for that DB....11 Replies
you can use super user creadentials
they are available in the databases' env variables
just as the standard credentials
As Ales said, standard user doesn't have superuser permissions.
To create/enable extensions, you need to use the superuser credendials, see:
https://docs.zerops.io/postgresql/how-to/manage#how-to-install-and-manage-postgresql-plugins
Perfect, thanks guys
Weird, I created it as superuser, but then it is still saying that "vector" does not exist
Did you create it for the correct schema?
I mean, there is only 1,
public
shows it's installed for the superuser, but for the normal user it's notpostgres user has it's own postgres schema. So when you create a DB, there are 3 schemas:
postgres user and do not specify a schema, it will default to postgres I immediately created it for public the first time
Solution
Or to explain it a bit better, since my previous message merges databases and schemas into one (sorry for the confusion).
We create 2 users,
postgres and db (this one is named as your service) and they both have public schema.
So when you login as postgres user, it will by default select postgres database, and you need to switch to db to install extenstions for that DB.Ok, was confused, I think I fixed it now
Yeah sorry, I managed to confuse myself while explaining it :skillIssue:
Np 😛 happens to me all the time too