summaryrefslogtreecommitdiff
path: root/db/pgsql/setup
diff options
context:
space:
mode:
Diffstat (limited to 'db/pgsql/setup')
-rw-r--r--db/pgsql/setup9
1 files changed, 8 insertions, 1 deletions
diff --git a/db/pgsql/setup b/db/pgsql/setup
index bb872ac..69beff1 100644
--- a/db/pgsql/setup
+++ b/db/pgsql/setup
@@ -16,6 +16,13 @@ host odb_test odb_test 192.168.0.0/24 trust
create database odb_test;
grant all privileges on database odb_test to odb_test;
-* If need to add hstore support:
+* If need to add hstore support (postgresql-contrib-X.Y package):
+
+ For 8.x:
psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql
+
+ For 9.x:
+
+ psql odb_test
+ CREATE EXTENSION hstore;