From 69d4c4c37d342dbd70977af8bddeecf09545cc15 Mon Sep 17 00:00:00 2001 From: =?utf8?q?R=C3=A9gis=20Hanol?= Date: Mon, 17 Feb 2014 19:13:31 +0100 Subject: [PATCH] make sure public schema is owned by discourse we need to be owner of the public schema when restoring a backup --- templates/postgres.template.yml | 1 + 1 file changed, 1 insertion(+) diff --git a/templates/postgres.template.yml b/templates/postgres.template.yml index 1c83fc7..e0d471a 100644 --- a/templates/postgres.template.yml +++ b/templates/postgres.template.yml @@ -108,6 +108,7 @@ run: cmd: sudo -u postgres psql discourse raise_on_fail: false + - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "alter schema public owner to discourse;"' - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "create extension if not exists hstore;"' - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "create extension if not exists pg_trgm;"' -- 2.25.1