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.