In my case, the issue was that Postgres was looking for the vector type in the public schema instead of the shared_extensions schema. So this ended up working for me:

CREATE TABLE langchain_pg_embedding (
  collection_id uuid, 
  embedding shared_extensions.vector(1536),
  ...
)