From d34c508251344288aa91dba0c6c0587aa5e40d06 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 13 Jan 2014 07:59:35 -0500 Subject: [PATCH] Adding a copy of create_database_extensions.sql to re-create the PINES database during the upgrade. --- .../Pg/version-upgrade/pines-create-database.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-create-database.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-create-database.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-create-database.sql new file mode 100644 index 0000000000..c4905c7b05 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-create-database.sql @@ -0,0 +1,22 @@ +-- This file is intended to be called by eg_db_config.pl + +-- If manually calling: +-- Connect to the postgres database initially +-- Specify the database to create as -vdb_name=DATABASE +-- Specify the postgres contrib directory as -vcontrib_dir=CONTRIBDIR +-- You can get the contrib directory using pg_config --sharedir and adding a /contrib to it + +-- NOTE: This file does not do transactions +-- This is intentional. Please do not wrap in BEGIN/COMMIT. +DROP DATABASE IF EXISTS evergreen; + +CREATE DATABASE evergreen TEMPLATE template0 ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C'; + +\connect evergreen + +CREATE LANGUAGE plperlu; +CREATE LANGUAGE plperl; + +CREATE EXTENSION tablefunc; +CREATE EXTENSION xml2; +CREATE EXTENSION hstore; -- 2.11.0