Differences

This shows you the differences between two versions of the page.

--- redhat:other-redhat:psono-server-redhat [2019/05/14 09:48] – created michael
+++ redhat:other-redhat:psono-server-redhat [2019/05/14 10:01] (current) – michael
@@ Line 6: / Line 6: @@
 The Psono server requires a postgres database with some extensions. This section will explain how to install one and prepare it for the Psono server.
-We will be using postgres (tested with version 9.6, but every 9.4+ version should work):
+<WRAP center box 100%>
+**We will be using postgres (tested with version 9.6, but every 9.4+ version should work):**
-First install some requirements
+  - First install some requirements: <code>
-<code>
 # yum -y install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
 # yum -y install postgresql96-server postgresql96-contrib
@@ Line 17: / Line 16: @@
 # systemctl enable postgresql-9.6.service
 </code>
+  - Now lets switch the postgres user: <code># su - postgres</code>
-Now lets switch the postgres user
+  - Create our new DB: <code># createdb psono</code>
+  - Now switch the command prompt to postgres command prompt: <code># psql psono</code>
-<code># su - postgres</code>
+  - Followed by some nice postgres commands to create the user and grant all privileges: <code>
-Create our new DB
-<code># createdb psono</code>
-Now switch the command prompt to postgres command prompt
-<code># psql psono</code>
-Followed by some nice postgres commands to create the user and grant all privileges:
-<code>
 CREATE USER psono WITH PASSWORD 'password';
 GRANT ALL PRIVILEGES ON DATABASE "psono" to psono;
-</code>
+</code> ''**Note**: Replace password with a unique password''
+  - Install some necessary extensions: <code>
- Note: Replace password with a unique password
-Install some necessary extensions:
-<code>
 CREATE EXTENSION IF NOT EXISTS ltree;
 CREATE EXTENSION IF NOT EXISTS "pgcrypto";
 </code>
+  - //(optional) If you want to use this database for unit testing, you should also do:// <code>ALTER USER psono CREATEDB;</code>
-(optional) If you want to use this database for unit testing, you should also do:
+  - To exit this shell and return to your normal user do:<code>
-<code>ALTER USER psono CREATEDB;</code>
-To exit this shell and return to your normal user do:
-<code>
 \q
 Ctrl + D
-</code>
+</code>''Other databases are not supported because of missing **ltree extension**''
+</WRAP>
-''Other databases are not supported because of missing **ltree extension**''
 <WRAP center box 100%>