How to install pgvector with an existing postgres docker image? about pgvector HOT 2 CLOSED

Hey @niwaa, you'll need to configure docker-compose to use the ankane/pgvector image or another image that has pgvector installed.

Since it looks like you're running Postgres 12, you can build a custom image from the Dockerfile, replacing all instances of 15 with 12 and configure docker-compose to use that image.

from pgvector.

@ankane To follow up on this, I added the ankane/pgvector image to docker-compose, but I'm getting this:
2023-07-10 10:00:35 Error: Database is uninitialized and superuser password is not specified. 2023-07-10 10:00:35 You must specify POSTGRES_PASSWORD to a non-empty value for the 2023-07-10 10:00:35 superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run". 2023-07-10 10:00:35 2023-07-10 10:00:35 You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all 2023-07-10 10:00:35 connections without a password. This is *not* recommended. 2023-07-10 10:00:35 2023-07-10 10:00:35 See PostgreSQL documentation about "trust": 2023-07-10 10:00:35 https://www.postgresql.org/docs/current/auth-trust.html

I already have the db initialized and the password set, so not sure why it's giving me this error?

from pgvector.