diff options
| -rw-r--r-- | db/pgsql/setup | 15 |
1 files changed, 15 insertions, 0 deletions
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; |