Postgres Adapter

Stores Payload data in a Postgres database, with migrations and read replica support

Official 45,915 1.1m/wk MIT v3.94.0

Installation

pnpm add @payloadcms/db-postgres

About

The Postgres adapter connects a Payload project to a PostgreSQL database. Collections, globals, versions, drafts and jobs are all read and written through Postgres, so the project runs on the database most teams already operate. Schema changes are handled through generated migration files that you review and run, which keeps production databases under version control. Read replicas can take read traffic off the primary, and the adapter can also work with a dedicated schema, custom extensions and a choice of ID types.

Package info

Package name
@payloadcms/db-postgres
Latest version
3.94.0
Unpacked size
58 kB
License
MIT
Weekly downloads
1.1m
Last publish
Nov 17, 2026

More from payloadcms

View profile

Stores Payload upload files in Cloudflare R2 buckets instead of local disk

Adds a parent field and breadcrumbs to collections so documents can nest inside each other

Sends Payload server errors and selected HTTP errors to Sentry with user context

Adds an SEO tab with meta title, description, image and search preview to collections

Stores collection uploads in Vercel Blob Storage instead of local disk

Lets one Payload admin panel manage content for many separate tenants

Similar adapters

More in Database

Database adapter that runs Payload on SurrealDB through its PostgreSQL-compatible SQL interface

Vercel Postgres database adapter that stores Payload collections and globals in Postgres

Stores Payload data in Cloudflare D1 SQLite databases from Workers

Stores Payload collections and globals in a MongoDB database

Official SQLite database adapter that stores Payload collections and globals in SQLite

Database adapter that maps Payload collections onto an existing Prisma schema