1. Eric Radman
  2. ephemeralpg

Overview

HTTPS SSH

Ephemeral PostgreSQL

Run tests on an isolated, temporary PostgreSQL database.

Temporary database created with pg_tmp have a limited shared memory footprint and are automatically garbage-collected after the number of seconds specified by the -w option (the default is 60).

pg_tmp reduces the wait time for a new database to less than one second by initializing a database in the background that is used by subsequent invocations.

Installation - BSD, Mac OS, and Linux

make install

Or to specify a specific installation location

PREFIX=$HOME/local make install

Installation - Mac OS/Homebrew

brew install ephemeralpg

Installation - SmartOS/Solaris

LDFLAGS='-lsocket -lnsl' make install

Man Page Examples

Create a temporary database and run a query:

uri=$(pg_tmp)
psql $uri -f my.sql

Start a temporary server with a custom extension:

uri=$(pg_tmp -o "-c shared_preload_libraries=$PWD/auth_hook")
psql $uri -c "SELECT 1"

Requirements

  • KSH or BASH
  • PostgreSQL 9.3+

News

A release history as well as features in the upcoming release are covered in the NEWS file.

License

Source is under and ISC-style license. See the LICENSE file for more detailed information on the license used for compatibility libraries.