tmp-postgres

Start and stop a temporary postgres for testing

https://github.com/jfischoff/tmp-postgres#readme

Version on this page:	0.1.2.2
LTS Haskell 21.25:	1.34.1.0
Stackage Nightly 2023-06-21:	1.34.1.0
Latest on Hackage:	1.34.1.0@rev:1

See all snapshots tmp-postgres appears in

BSD-3-Clause licensed by Jonathan Fischoff

Maintained by [email protected]

This version can be pinned in stack with:tmp-postgres-0.1.2.2@sha256:00d8d4ab74d467da311355fb4365f35dac7abefb271a050c6cd4a1d1237100d7,2589

Module documentation for 0.1.2.2

Database
- Database.Postgres
  - Database.Postgres.Temp
    - Database.Postgres.Temp.Internal

Depends on 10 packages(full list with versions):

async, base, bytestring, directory, network, port-utils, postgresql-simple, process, temporary, unix

Used by 1 package in lts-13.19(full list with versions):

hspec-pg-transact

tmp-postgres

tmp-postgres is a library for creating a temporary postgres instance on a random port for testing.

result <- start []
case result of
  Left err -> print err
  Right tempDB -> do
     -- Do stuff
     stop tempDB

Installation

macOS

$ brew install postgres
$ stack install tmp-postgres

Ubuntu

Ubuntu’s PostgreSQL installation does not put initdb on the PATH. We need to add it manually.

$ sudo apt-get install postgresql-VERSION
$ echo "export PATH=$PATH:/usr/lib/postgresql/VERSION/bin/" >> /home/ubuntu/.bashrc
$ stack install tmp-postgres