安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install ephemeralpg

local Homebrew formula metadata

Linux

Nix已验证 · 92%

nix profile install nixpkgs#ephemeralpg

nixpkgs package indexes · pkgs/by-name/ep/ephemeralpg/package.nix · 来源: api.github.com

概览

软件包摘要

Run tests on an isolated, temporary Postgres database

项目链接

命令和别名

getsocket
pg_tmp

历史

项目历史与用法

Ephemeral PostgreSQL is a compact test utility centered on `pg_tmp`, a shell script that starts isolated temporary PostgreSQL databases. It gives test suites a real PostgreSQL server without making developers keep a long-lived database around or substitute SQLite for PostgreSQL behavior.

项目历史

The NEWS file records version 1.0 on January 7, 2015 as an initial Bitbucket release and describes it as a cross-platform implementation in fewer than one hundred lines of code. Later releases added TCP binding through the bundled `getsocket` utility, better cleanup behavior, PostgreSQL-version compatibility fixes, extra server options, and a test framework.

The project moved hosting from Bitbucket to GitHub in version 2.8 on September 25, 2019. Its public project page was still maintained in 2025 and documents `pg_tmp` as a compact shell script for unit and integration testing with PostgreSQL in any language.

采用历史

ephemeralpg is not a mass-market database package, but it has a clear testing niche: teams that need PostgreSQL-specific behavior in tests without shared state. Homebrew and Nix packaging make the tool easy to install in developer workstations and CI images.

使用方式

A common workflow is `uri=$(pg_tmp)` followed by running `psql` or an application test suite against that connection URI. The tool can start a database on a random TCP port, keep it alive for a specified window, pass server options such as disabling autovacuum, and garbage-collect temporary databases automatically.

The project page explains several performance techniques: avoiding fully sequential init/start/stop work, disabling runtime fsync, spinning for the first connection, pre-initializing a background database under `/tmp`, and shutting down asynchronously.

为什么软件包爱好者会关心

ephemeralpg is interesting because it solves a common developer-tools problem with shell and standard PostgreSQL tools instead of a service daemon. It is small, inspectable, and very package-manager-friendly: install it, call `pg_tmp`, and get a disposable database URI.

时间线

2015-01-07: Version 1.0 initially released on Bitbucket.
2015-12-12: Version 1.7 added a more extensive `make test` framework.
2016-03-29: Version 2.0 allowed temporary directories with initdb/start/stop arguments.
2019-09-25: Version 2.8 moved hosting from Bitbucket to GitHub.
2025-02-06: Version 3.4 adjusted startup behavior and Mac OS locale handling.

Related projects

ephemeralpg depends on the standard PostgreSQL toolchain, especially `initdb`, `pg_ctl`, `postgres`, and `psql`, and includes helper utilities such as `getsocket` plus optional contrib scripts.

来源

安全态势

风险级别：blue

broad file, network, media, or database tool signal.

风险分类器

blue 风险 · 中置信度 · tool

原因

broad file, network, media, or database tool signal

信号

text:database

安装行为

formula 元数据中未记录 Homebrew post-install 钩子。
Homebrew bottle 元数据适用于 8 个平台目标。
安装时包含 1 个运行时依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`getsocket`	cli	全局可执行文件
`pg_tmp`	cli	全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-07-25

管理器版本3.4

管理器更新时间

本地数据OK

上游not checked

检测到的最新版本未检测到

https://eradman.com/ephemeralpg/

信息No package-manager update timestamp was available.低置信度
信息Release/tag comparison is only available for GitHub repositories.https://eradman.com/ephemeralpg/none 置信度

安装元数据

软件包元数据

软件包键	brew:ephemeralpg
版本	3.4
软件包管理器	Homebrew
软件包管理器页面	https://formulae.brew.sh/formula/ephemeralpg
主页	https://eradman.com/ephemeralpg/
仓库	https://github.com/eradman/ephemeralpg
上游文档	https://eradman.com/ephemeralpg
许可证	ISC
源码归档	https://eradman.com/ephemeralpg/code/ephemeralpg-3.4.tar.gz
依赖	libpq
Bottle	可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, sonoma, ventura, x86_64_linux)
Homebrew post-install	未定义
服务	未声明

注册表事实

源数据库详情

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	ephemeralpg
Version Scheme	0
Revision	0
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	stable

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

Nix95%

ephemeralpg

nix profile install nixpkgs#ephemeralpg

normalized package name match
匹配方式：Ephemeralpg

nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/ep/ephemeralpg/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

软件包图谱

链接来自本地软件包关系图、补充数据、依赖边、生态匹配和软件包 hub 归属。

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

Combined YAML source

View the package source record on GitHub.

combined/ephemeralpg.yml

使用的来源

Geiger risk classifier
Nucleus package database
av.db category and tag curation
cross-ecosystem install command graph
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment

使用 Homebrew, Nix 安装 ephemeralpg