upgrade pdo_pgsql to support SNI

[guoxiangke]

upgrade pdo_pgsql to support SNI

[braumye]

If you're using Laravel, you can use this package https://github.com/braumye/laravel-vercel-postgres that add the endpoint to the options of the dsn and it worked for me.

Neon document: https://neon.tech/docs/connect/connection-errors#b-use-libpq-keyvalue-syntax-in-the-database-field

[f3l1x]

Hi, I will prepare PHP update with postgres14. I hope it will solve your troubles.

[zone-connect]

Hello, The official work-around that seems to work is to append the endpoint_ID with the password in the connection string like

DATABASE_URL=postgres://dbuser:<endpoint=<endpoint_id>>;<your_password>@ep-broad-snowflake-sdexc.il-central-1.aws.neon.tech/neondb?pgbouncer=true&connect_timeout=10

So basically, add this --> endpoint=<endpoint_id>; (including the comma)

Alternatively, if you are using database connection parameters, you can use the following

...
DB_PASSWORD='<endpoint=<endpoint_id>>;<your_password>' 

In our case, the endpoint ID is --> ep-broad-snowflake-sdexc (as seen in the connection URL above)

Hope this helps.

[guoxiangke]

thanks.

[aungmyatmoethegreat]

I am also facing that issue too, we have to update that in vercel php.

[asispts]

Related: vercel/storage#120

[f3l1x]

Hi. Do you know which exactly libraries needs to be upgraded?

[aungmyatmoethegreat]

pgsql Liv I think so

[coolymoon]

Same here. Is there any way to upgrade the libpq?

The [email protected] - PHP 8.2.x (https://example-php-8-2.vercel.app/) shows the version of libpq is 10.21, which is unsupported now.

The latest version is 16 and according to neon.tech (Vercel's Postgres provider), SNI support was added to the libpq in version 14, which was released in September 2021.

[dbazhenov]

I ran into a similar problem today. I make connection via pg_connect and to solve the problem I added
options='endpoint=ep-shrill-disk-*****'

The connection worked successfully
$connect_data = "host=ep-shrill-disk-.eu-central-1.aws.neon.tech port=5432 dbname=php-neon user=daniil.bazhenov password= sslmode=require options='endpoint=ep-shrill-disk-*****'";

$db_connect = pg_connect($connect_data);

[deepakplay]

@dbazhenov
I was having the same issue in laravel vercel, How to do this "options='endpoint=ep-shrill-disk-*****'" in laravel,
i tried but not working

[JIeJaitt]

I encountered the same issue during deployment today and hope that Vercel can promptly upgrade pdo_pgsql to support SNI.

[aungmoe32]

I faced same error today. I think it is because of pgsql lib.

[DavidHGJ]

hi i have a same error, i trying to use laravel with postgres, but when i access database to get data i have this error: "could not find driver (Connection: pgsql, SQL: select * from "users" where "email" = [email protected] limit 1)". Does anyone know how to solve this?