{-| This module provides functions for creating a temporary @postgres@ instance. By default it will create a temporary data directory and a temporary directory for a UNIX domain socket for @postgres@ to listen on in addition to listening on @127.0.0.1@ and @::1@. Here is an example using the expection safe 'with' function: @ 'with' $ \\db -> 'Control.Exception.bracket' ('PG.connectPostgreSQL' ('toConnectionString' db)) 'PG.close' $ \\conn -> 'PG.execute_' conn "CREATE TABLE foo (id int)" @ To extend or override the defaults use `withConfig` (or `startConfig`). @tmp-postgres@ ultimately calls (optionally) @initdb@, @postgres@ and (optionally) @createdb@. All of the command line, environment variables and configuration files that are generated by default for the respective executables can be extended. In general @tmp-postgres@ is useful if you want a clean temporary @postgres@ and do not want to worry about clashing with an existing postgres instance (or needing to ensure @postgres@ is already running). Here are some different use cases for @tmp-postgres@ and their respective configurations: * The default 'with' and 'start' functions can be used to make a sandboxed temporary database for testing. * By disabling @initdb@ one could run a temporary isolated postgres on a base backup to test a migration. * By using the 'stopPostgres' and 'withRestart' functions one can test backup strategies. WARNING!! Ubuntu's PostgreSQL installation does not put @initdb@ on the @PATH@. We need to add it manually. The necessary binaries are in the @\/usr\/lib\/postgresql\/VERSION\/bin\/@ directory, and should be added to the @PATH@ > echo "export PATH=$PATH:/usr/lib/postgresql/VERSION/bin/" >> /home/ubuntu/.bashrc -} module Database.Postgres.Temp ( -- * Start and Stop @postgres@ -- ** Exception safe interface with , withConfig , withRestart -- *** Configuration -- *** Defaults , defaultConfig , defaultConfig_9_3_10 , defaultPostgresConf , verboseConfig -- *** Custom Config builder helpers , optionsToDefaultConfig -- *** General Configuration Types , module Database.Postgres.Temp.Config -- ** Main resource handle , DB -- *** 'DB' accessors , toConnectionString , toConnectionOptions , toDataDirectory , toTemporaryDirectory , toPostgresqlConf -- *** 'DB' modifiers , makeDataDirPermanent , reloadConfig -- *** 'DB' debugging , prettyPrintDB -- ** Separate start and stop interface. , start , startConfig , stop , restart , stopPostgres , stopPostgresGracefully -- * Making Starting Faster -- ** @initdb@ Data Directory Caching -- *** Exception safe interface , withDbCache , withDbCacheConfig -- *** @initdb@ cache configuration. , CacheConfig (..) , defaultCacheConfig -- *** @initdb@ cache handle. , CacheResources , cacheResourcesToConfig -- *** Separate start and stop interface. , setupInitDbCache , cleanupInitDbCache -- ** Data Directory Snapshots -- *** Exception safe interface , withSnapshot -- *** 'Snapshot' handle , Snapshot , snapshotConfig -- *** Separate start and stop interface. , takeSnapshot , cleanupSnapshot -- * Errors , StartError (..) ) where import Database.Postgres.Temp.Internal import Database.Postgres.Temp.Internal.Core import Database.Postgres.Temp.Config