Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: IPC connection error when querying the DB #603

Open
justram opened this issue Oct 9, 2024 · 0 comments
Open

ERROR: IPC connection error when querying the DB #603

justram opened this issue Oct 9, 2024 · 0 comments

Comments

@justram
Copy link

justram commented Oct 9, 2024

Hello teams,

Issue

I encountered the same IPC connection issue with v0.4.0-alpha.2 as mentioned in #592
Screenshot 2024-10-09 at 11 45 38 AM

I followed the zip package installation guide to install pgvecto.rs.
The issue occurred while using both the flat and hnsw indexes with the relatively small glove_100_cosine dataset.
I also tested the same setup using the pgvector package (v0.7.4) and did not encounter any issues.

Environment Info

I installed PostgreSQL and related packages using conda, as I am unable to use Docker images on my server.

System Info

Ubuntu 22.04.3 LTS
Mem 1.0Ti

To reproduce my environment, you can use the following commands:

conda create -n pg python=3.10
conda activate pg
conda install -c -y conda-forge postgresql=16.4
conda install -c -y conda-forge psycopg 
wget https://github.com/tensorchord/pgvecto.rs/releases/download/v0.4.0-alpha.2/vectors-pg16_x86_64-unknown-linux-gnu_0.4.0-alpha.2.zip
unzip vectors-pg16_x86_64-unknown-linux-gnu_0.4.0-alpha.2.zip -d vectors
cp vectors/vectors.so $(pg_config --pkglibdir)/
cp vectors/vectors--* $(pg_config --sharedir)/extension/
cp vectors/vectors.control $(pg_config --sharedir)/extension/
initdb -D db_pgvecto_rs
pg_ctl -D db_pgvecto_rs -l logfile -o "-F -p 9527" start
psql -d postgres --port 9527 -c 'CREATE ROLE postgres WITH LOGIN SUPERUSER;'
psql -U postgres --port 9527 -c 'ALTER SYSTEM SET shared_preload_libraries = "vectors.so"'
psql -U postgres --port 9527 -c 'ALTER SYSTEM SET search_path TO "$user", public, vectors'
pg_ctl -D db_pgvecto_rs -l logfile -o "-F -p 9527" restart

Any suggestions would be appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant