From e78193d6848f9c61b8c8eabffef08c58a3bf64cb Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 27 Jun 2013 12:26:29 +0200
Subject: Update database setup instructions

---
 db/pgsql/setup | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'db/pgsql/setup')

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;
-- 
cgit v1.1