summaryrefslogtreecommitdiff
path: root/db/pgsql/setup
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2013-06-27 12:26:29 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2013-06-27 12:26:29 +0200
commite78193d6848f9c61b8c8eabffef08c58a3bf64cb (patch)
tree2a521c47e1f0d588201be28b0eea22cc51f3818a /db/pgsql/setup
parent08d65d4442d63a6b68c4e86fc97e19feb2be1b02 (diff)
Update database setup instructions
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;