Adding debian version 248.debian/248debian

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 19 insertions, 0 deletions

diff --git a/debian/tests/default-psql b/debian/tests/default-psql
new file mode 100755
index 0000000..3392ea4
--- /dev/null
+++ b/debian/tests/default-psql
@@ -0,0 +1,19 @@
+#!/bin/sh
+# autopkgtest to check that installing the "postgresql" metapackage results in
+# a working cluster
+set -e
+
+# disabled default cluster creation?
+if grep -q '\bcreate_main_cluster\b.*\bfalse\b' /etc/postgresql-common/createcluster.conf; then
+    echo "SKIP: default cluster creation disabled in createcluster.conf"
+    exit 0
+fi
+
+if ! pg_lsclusters | grep -q 'main .* online'; then
+    echo "No running cluster!" >&2
+    pg_lsclusters >&2
+fi
+
+# check that we can connect to template1 on the default cluster
+OUT=$(su - -c 'psql -Atc "select 21*2" template1' postgres)
+[ "$OUT" = "42" ] || { echo "$OUT"; exit 1; }