search_path and NeonPostgres (LlangChain) - how to set it?
Hi there - I'm using NeonPostgres from LlangChain community, and I figured it should be able to set the search_path in the connection string (for multi-tenant), but it's just not working for me. Any ideas would be helpful -- I feel like I've done the obvious stuff.
Thanks!
2 Replies
stormy-gold•7mo ago
Did you get an error about unsupported startup parameters? ( https://neon.tech/docs/connect/connection-errors#unsupported-startup-parameter )
Neon
Connection errors - Neon Docs
This topic describes how to resolve connection errors you may encounter when using Neon. The errors covered include The endpoint ID is not specified Password authentication failed for user Couldn't co...
stormy-gold•7mo ago
I'm able to connect with the
options and search_path
but you can't use the pooled connection to do this, we might be able to fix that but right now pgBouncer doesn't support options passing
my conn string looks like this: postgresql://neondb_owner:npg_************@ep-lucky-wave-a6nf20c3.us-west-2.aws.neon.tech/neondb?sslmode=require&options=-c%20search_path%3Dschema_name and you can replace schema_name with yours