# Set up Lucia Auth for local Postgres DB vs Vercel Postgres

> Learn how to configure Lucia Auth with the postgresql adapter for a local Postgres database and Vercel Postgres, switching the postgres and pg drivers.

Author: Flavio Copes | Published: 2023-11-10 | Canonical: https://flaviocopes.com/set-up-lucia-auth-for-local-postgres-db-vs-vercel-postgres/

I switched a codebase from local Postgres database to Vercel Postgres, which comes with its own optimized package.

I used this to connect Lucia Auth:

```javascript
import { postgres as postgresAdapter } from '@lucia-auth/adapter-postgresql'
import postgres from 'postgres'

const POSTGRES_URL = //..lookup from env variables

const postgresDatabase = postgres(POSTGRES_URL)

const auth = lucia({
  adapter: postgresAdapter(
    postgresDatabase,
    dbConfig
  ),
	//...
})
```

With Vercel Postgres, I used:

```javascript
import { pg } from '@lucia-auth/adapter-postgresql'
import { db } from '@vercel/postgres'

const auth = lucia({
  adapter: pg(db, dbConfig),
	//...
})
```

The `db` now already know how to look up the environment variable `POSTGRES_URL`