summaryrefslogtreecommitdiff
path: root/temp-postgres.sh
blob: 48bb9e8bdac31451e69bb5bec8c7efea30e2e688 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
#! /bin/sh

# Copyright (c) 2019, 2020, 2022 Stefan Kreutz <mail@skreutz.com>
#
# Permission to use, copy, modify, and distribute this software for any purpose
# with or without fee is hereby granted, provided that the above copyright
# notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH
# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
# AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT,
# INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
# LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
# OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
# PERFORMANCE OF THIS SOFTWARE.

set -o nounset

# Remove the temporary directory before exiting.
trap 'quit' INT
quit() {
  code="${1:-0}"
  trap '' INT TERM
  kill -TERM 0
  wait
  rm -rf "${tmpdir-}" || {
    ( >&2 printf "temp-postgres: failed to remove temporary directory: %s\\n" "${tmpdir}" )
    [ "${code}" -ne 0 ] || code=1
  }
  exit "${code}"
}

# Parse arguments.
[ $# -eq 2 ] || {
  ( >&2 printf "temp-postgres: invalid arguments\\n" )
  printf "Usage: temp-postgres <dbname> <username>\\n"
  quit 1
}
dbname="$1"
username="$2"

# Create a temporary directory
tmpdir="$( mktemp -d )" || {
  ( >&2 printf "temp-postgres: failed to create temporary directory\\n" )
  quit 1
}

# Initialize the directory
initdb --pgdata="${tmpdir}" --username="${username}" || {
  ( >&2 printf "temp-postgres: failed to initialize database\\n" )
  quit 1
}

# Serve the directory
( postgres -k "${tmpdir}" -D "${tmpdir}" </dev/null ) &

# Test the connection
sleep 1
pg_isready --host="${tmpdir}" --dbname="nope" --username="${username}" --timeout=10 || {
  ( >&2 printf "temp-postgres: failed to connect to server\\n" )
  quit 1
}

# Create the database
createdb --host="${tmpdir}" --username="${username}" --no-password "${dbname}" || {
  ( >&2 printf "temp-postgres: failed to create database\\n" )
  quit 1
}

printf '
Connect with the following command:

\tpsql --host=localhost "%s" "%s"

' "${dbname}" "${username}"

wait
Generated by cgit. See skreutz.com for my tech blog and contact information.