From 5f22209cd002fd925ab134178157616fed9ea92b Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Tue, 4 Oct 2011 16:32:19 +0200 Subject: Add instructions on setting up PostgreSQL for ODB testing --- db/pgsql/setup | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 db/pgsql/setup (limited to 'db/pgsql/setup') diff --git a/db/pgsql/setup b/db/pgsql/setup new file mode 100644 index 0000000..49309d5 --- /dev/null +++ b/db/pgsql/setup @@ -0,0 +1,15 @@ +* In /etc/postgresql/X.Y/pg_hba.conf add the following two lines after + the "local all postgres ..." line: + +local odb_test odb_test trust +host odb_test odb_test 192.168.0.0/24 trust + + Restart the server. + +* Add user are database: + + su postgres + psql + create user odb_test; + create database odb_test; + grant all privileges on database odb_test to odb_test; -- cgit v1.1