New to Immich, getting this error... Help pls
Error: The pgvecto.rs extension is not available in this Postgres instance.
If using a container image, ensure the image has the extension installed.
at /app/immich/server/dist/services/database.service.js:73:23
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async /app/immich/server/dist/repositories/database.repository.js:211:23
api worker exited with code 1
47 Replies
:wave: Hey @Brandon,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs
docs
- Container Status: docker ps -a
docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJAChecklist
I have...
1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
2. :blue_square: read applicable release notes.
3. :blue_square: reviewed the FAQs for known issues.
4. :blue_square: reviewed Github for known issues.
5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: uploaded the relevant information (see below).
7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like
fdisk -l
and df -h
).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close
command, and re-open it later if needed.GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
Hey, I bet that you are using a normal Postgres instance instead of pgvecto.rs, right?
hey sorry for the delay
im not 100% sure, still learning. how can i check
Have you tried reading the info the bot provided you
hoestly i havent just yet, reading through some of it now. im sure this is a big time noob issue im just missing the correct information
i did read through the docker set up on the site but no where does it go into what my ticket is about
docker logs, container status ...
it also asks you to post compose and env files
i havent used compose before. i havent set it up, im just running containers separately. so i dont have that information to give
apologies im still learning about docker/containers, only been at this a few months so far
Why are you doing it the hard way 😛
that seems to be the way i live my life 😆
running a compose project as seperate containers is for advanced users that know what they're doing
gotcha, i followed an older youtube tutorial so that's probably why
when i go into my docker to go create a new compose it only shows me the setting for compose and not to create a new setup
Immich releases at a very rapid pace, usually any tutorial older than a couple of months is way out of date
"into my docker" what does that mean
Are you using docker desktop?
as is the case for most things docker related, poor choice on my part
boop.
what do you mean by desktop?
I don't understand what YOU mean by "going into my docker"
ahhh
im using unraid
welp there goes all my expertise
#unraid is that way :V
https://immich.app/docs/install/docker-compose
this is what im going to follow
In unraid, Just add a new stack, paste in the docker-compose.yaml and you're good.
stock compose is the best
im trying to but noob here dosnt know how to do that
when i go into my settings its showing me something else
i dont have the option to creat a new stack
yea, just follow those. they have screenshots and everything.
Did you install the mentioned plugin?
compose?
what bo0tzz said, and you shouldn't be in settings, you should be in the docker tab
Unraid
[Plugin] Docker Compose Manager
Compose Manager Beta Release! This plugin installs docker compose and compose switch. Use "docker compose" or "docker-compose" from the command line. See https://docs.docker.com/compose/cli-command/ for additional details. Install via Community Applications This plugin now adds a very basic contr...
i downloaded the plugin, i need a docker to go with?
again thanks yall for helping here
have you not enabled docker in unraid? if you don't see docker in the tabs on your unraid GUI, go to settings > docker > enable docker > yes
yes docker is going
if that is enabled, and you've installed the docker compose manager plugin above, you should see add new stack at the verrry bottom of the page when you click the docker tab
gotcha, i dont have that option
then i'd restart your server
just did
nvm compose it its own tab
weird, are you on unraid 7 then?
6.12.13
even weirder. that's what i'm on. no clue why it's different for you. anyway, installing via compose should get rid of those postgres errors and just work. just make sure to pay attention to your volume mappings for unraid.
Wroking on installing via compose now, will check back in when im done. Thanks yall ❤️
Couldn’t be that easy

Just remove that line
updated to ver 7 and it fixed it, got the compose running but i cant connect to it, wont load the ip
halp?!
This thread has been closed. To re-open, use the button below.