陌讯skills聚合平台

pgpm-docker

📁 constructive-io/constructive-skills 📅 2 days ago
8
总安装量
8
周安装量
#35919
全站排名
安装命令
npx skills add https://github.com/constructive-io/constructive-skills --skill pgpm-docker

Agent 安装分布

windsurf 8
mcpjam 7
claude-code 7
junie 7
kilo 7
zencoder 7

Skill 文档

PGPM Docker

Manage PostgreSQL Docker containers for local development using the pgpm docker command.

When to Apply

Use this skill when:

  • Setting up a local PostgreSQL database for development
  • Starting or stopping PostgreSQL containers
  • Recreating a fresh database container
  • User asks to run tests that need a database
  • Troubleshooting database connection issues

Quick Start

Start PostgreSQL Container

pgpm docker start

This starts a PostgreSQL 17 container with default settings:

  • Container name: postgres
  • Port: 5432
  • User: postgres
  • Password: password

Start with Custom Options

pgpm docker start --port 5433 --name my-postgres

Recreate Container (Fresh Database)

pgpm docker start --recreate

Stop Container

pgpm docker stop

Command Reference

pgpm docker start

Start a PostgreSQL Docker container.

Option Description Default
--name <name> Container name postgres
--image <image> Docker image pyramation/postgres:17
--port <port> Host port mapping 5432
--user <user> PostgreSQL user postgres
--password <pass> PostgreSQL password password
--recreate Remove and recreate container false

pgpm docker stop

Stop a running PostgreSQL container.

Option Description Default
--name <name> Container name to stop postgres

Common Workflows

Development Setup

# Start fresh database
pgpm docker start --recreate

# Load environment variables
eval "$(pgpm env)"

# Deploy your PGPM modules
pgpm deploy

Running Tests

# Ensure database is running
pgpm docker start

# Run tests with environment
pgpm env pnpm test

Multiple Databases

# Start main database on default port
pgpm docker start --name main-db

# Start test database on different port
pgpm docker start --name test-db --port 5433

PostgreSQL Version

The default image pyramation/postgres:17 includes PostgreSQL 17 which is required for:

  • security_invoker views
  • Latest PostgreSQL features used by Constructive

If you see errors like “unrecognized parameter security_invoker”, ensure you’re using PostgreSQL 17+.

Troubleshooting

Issue Solution
“Docker is not installed” Install Docker Desktop or Docker Engine
“Port already in use” Use --port to specify a different port, or stop the conflicting container
Container won’t start Check docker logs postgres for errors
“Container already exists” Use --recreate to remove and recreate
Permission denied Ensure Docker daemon is running and user has permissions

Environment Variables

After starting the container, use pgpm env to set up environment variables:

eval "$(pgpm env)"

This sets:

  • PGHOST=localhost
  • PGPORT=5432
  • PGUSER=postgres
  • PGPASSWORD=password
  • PGDATABASE=postgres

References

For related skills:

  • Environment management: See pgpm-env skill
  • Running tests: See pgpm-testing skill
GitHub 仓库 ↗ ← 返回陌讯 Skills 聚合平台
本页面由 陌讯 Skills 聚合平台 收录整理，数据定期更新。