# ephemeralpg を Homebrew, Nix でインストール

ephemeralpg のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。

## インストール

```sh
sudo av install brew:ephemeralpg
```

追加のインストールコマンド:

### macOS

- Homebrew (100%):

```sh
brew install ephemeralpg
```

  証拠: local Homebrew formula metadata

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#ephemeralpg
```

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

## パッケージ情報

- **パッケージキー:** brew:ephemeralpg
- **パッケージマネージャ:** Homebrew
- **バージョン:** 3.4
- **ソース概要:** Run tests on an isolated, temporary Postgres database
- **ホームページ:** <https://eradman.com/ephemeralpg/>
- **生成日時:** 2026-08-03T19:37:03+00:00

## 実行可能ファイル

- getsocket (エイリアス)
- pg_tmp (エイリアス)

## インストール挙動

- Bottle: 利用不可

## バージョンと鮮度

- ページ生成日: 2026-08-03
- マネージャ版: 3.4
## プロジェクトの歴史と使われ方

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.

### ソース

- <https://eradman.com/ephemeralpg/>
- <https://github.com/eradman/ephemeralpg>
- <https://raw.githubusercontent.com/eradman/ephemeralpg/master/NEWS>


## セキュリティノート

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

- **Geiger リスク:** blue / 中
- broad file, network, media, or database tool signal

## 他のパッケージマネージャ記録

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


## Combined YAML source

View the package source record on GitHub. [combined/ephemeralpg.yml](https://github.com/mxcl/pkgdb/blob/main/combined/ephemeralpg.yml)


## ソース

- pkg.so package database
- Geiger risk classifier
- curated package history
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph