2 files changed, 22 insertions, 0 deletions
diff --git a/debian/tests/control b/debian/tests/control
new file mode 100644
index 0000000..a59de84
--- /dev/null
+++ b/debian/tests/control
@@ -0,0 +1,3 @@
+Tests: default-psql
+Depends: postgresql
+Restrictions: needs-root
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; }