Help us shape the future of Go! Take the 2026 Go Developer Survey

Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgres

package

Go to main page

Versions in this module

v2

v2.15.2

Oct 27, 2026

v2.15.1

Oct 26, 2026

v2.15.0

Sep 2, 2026

v2.14.0

Sep 1, 2026

v2.13.0

Aug 31, 2026

v2.12.0

Aug 26, 2026

v2.11.0

Aug 18, 2026

Changes in this version

type Option

+ func WithAttemptsRetention(maxAge time.Duration, maxRows int) Option

type Store

+ func (s *Store) DequeueContext(dequeueCtx context.Context, req queue.DequeueRequest) (queue.DequeueResponse, error)

+ func (s *Store) LeaseRoutes(leaseIDs []string) (map[string]string, error)

v2.10.1

Aug 18, 2026

v2.10.0

Aug 18, 2026

Changes in this version

type Store

+ func (s *Store) EnqueueBatch(items []queue.Envelope) (int, error)

v2.9.0

Jul 1, 2026

v2.8.1

Jun 4, 2026

v2.8.0

May 8, 2026

Changes in this version

+ func TruncateForTest(t *testing.T, s *Store)

+ type Option func(*Store)

+ func WithDLQRetention(maxAge time.Duration, maxDepth int) Option

+ func WithDeliveredRetention(maxAge time.Duration) Option

+ func WithNowFunc(now func() time.Time) Option

+ func WithPollInterval(d time.Duration) Option

+ func WithQueueLimits(maxDepth int, dropPolicy string) Option

+ func WithRetention(maxAge, pruneInterval time.Duration) Option

+ type Store struct

+ func NewStore(dsn string, opts ...Option) (*Store, error)

+ func (s *Store) Ack(leaseID string) error

+ func (s *Store) AckBatch(leaseIDs []string) (queue.LeaseBatchResult, error)

+ func (s *Store) CancelMessages(req queue.MessageCancelRequest) (queue.MessageCancelResponse, error)

+ func (s *Store) CancelMessagesByFilter(req queue.MessageManageFilterRequest) (queue.MessageCancelResponse, error)

+ func (s *Store) CaptureBacklogTrendSample(at time.Time) error

+ func (s *Store) Close() error

+ func (s *Store) Delete(poolName, id string) (bool, error)

+ func (s *Store) DeleteDead(req queue.DeadDeleteRequest) (queue.DeadDeleteResponse, error)

+ func (s *Store) Dequeue(req queue.DequeueRequest) (queue.DequeueResponse, error)

+ func (s *Store) Enqueue(env queue.Envelope) error

+ func (s *Store) Extend(leaseID string, extendBy time.Duration) error

+ func (s *Store) ListAll() ([]secrets.Record, error)

+ func (s *Store) ListAttempts(req queue.AttemptListRequest) (queue.AttemptListResponse, error)

+ func (s *Store) ListBacklogTrend(req queue.BacklogTrendListRequest) (queue.BacklogTrendListResponse, error)

+ func (s *Store) ListByPool(poolName string) ([]secrets.Record, error)

+ func (s *Store) ListDead(req queue.DeadListRequest) (queue.DeadListResponse, error)

+ func (s *Store) ListMessages(req queue.MessageListRequest) (queue.MessageListResponse, error)

+ func (s *Store) LookupMessages(req queue.MessageLookupRequest) (queue.MessageLookupResponse, error)

+ func (s *Store) MarkDead(leaseID string, reason string) error

+ func (s *Store) MarkDeadBatch(leaseIDs []string, reason string) (queue.LeaseBatchResult, error)

+ func (s *Store) Nack(leaseID string, delay time.Duration) error

+ func (s *Store) NackBatch(leaseIDs []string, delay time.Duration) (queue.LeaseBatchResult, error)

+ func (s *Store) NotifyCh() <-chan struct{}

+ func (s *Store) RecordAttempt(attempt queue.DeliveryAttempt) error

+ func (s *Store) RequeueDead(req queue.DeadRequeueRequest) (queue.DeadRequeueResponse, error)

+ func (s *Store) RequeueMessages(req queue.MessageRequeueRequest) (queue.MessageRequeueResponse, error)

+ func (s *Store) RequeueMessagesByFilter(req queue.MessageManageFilterRequest) (queue.MessageRequeueResponse, error)

+ func (s *Store) ResumeMessages(req queue.MessageResumeRequest) (queue.MessageResumeResponse, error)

+ func (s *Store) ResumeMessagesByFilter(req queue.MessageManageFilterRequest) (queue.MessageResumeResponse, error)

+ func (s *Store) RuntimeMetrics() queue.StoreRuntimeMetrics

+ func (s *Store) Stats() (queue.Stats, error)

+ func (s *Store) Upsert(rec secrets.Record) error