postgres

Documentation

Overview

Package postgres opens the application pool and applies the embedded migrations, following the startup sequence of instance-config §6.1.

Index

• func Connect(ctx context.Context, dsn string, logger *slog.Logger) (*pgxpool.Pool, error)
• func Migrate(ctx context.Context, dsn string, logger *slog.Logger) error

Functions

func Connect

func Connect(ctx context.Context, dsn string, logger *slog.Logger) (*pgxpool.Pool, error)

Connect opens a pgx pool, retrying with backoff for at most 30 seconds.

func Migrate

func Migrate(ctx context.Context, dsn string, logger *slog.Logger) error

Migrate applies the embedded goose migrations, before any network listen (§6.1 step 3). Each migration runs in its own transaction; a failure stops the process with the database left at the last complete migration.