redhat:other-redhat:psono-server-redhat

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
redhat:other-redhat:psono-server-redhat [2019/05/14 09:58] michaelredhat:other-redhat:psono-server-redhat [2019/05/14 10:01] (current) michael
Line 7: Line 7:
  
 <WRAP center box 100%> <WRAP center box 100%>
-We will be using postgres (tested with version 9.6, but every 9.4+ version should work):+**We will be using postgres (tested with version 9.6, but every 9.4+ version should work):**
  
-  - First install some requirements <code>+  - First install some requirements<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 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 # yum -y install postgresql96-server postgresql96-contrib
Line 16: Line 16:
 # systemctl enable postgresql-9.6.service # systemctl enable postgresql-9.6.service
 </code> </code>
-  - Now lets switch the postgres user <code># su - postgres</code> +  - Now lets switch the postgres user<code># su - postgres</code> 
-  - Create our new DB <code># createdb psono</code> +  - Create our new DB<code># createdb psono</code> 
-  - Now switch the command prompt to postgres command prompt <code># psql 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>   - Followed by some nice postgres commands to create the user and grant all privileges: <code>
 CREATE USER psono WITH PASSWORD 'password'; CREATE USER psono WITH PASSWORD 'password';
 GRANT ALL PRIVILEGES ON DATABASE "psono" to psono; GRANT ALL PRIVILEGES ON DATABASE "psono" to psono;
-</code> Note: Replace password with a unique password+</code> ''**Note**: Replace password with a unique password''
   - Install some necessary extensions: <code>   - Install some necessary extensions: <code>
 CREATE EXTENSION IF NOT EXISTS ltree; CREATE EXTENSION IF NOT EXISTS ltree;
 CREATE EXTENSION IF NOT EXISTS "pgcrypto"; CREATE EXTENSION IF NOT EXISTS "pgcrypto";
 </code> </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:// <code>ALTER USER psono CREATEDB;</code>
   - To exit this shell and return to your normal user do:<code>   - To exit this shell and return to your normal user do:<code>
 \q \q
  • redhat/other-redhat/psono-server-redhat.1557820705.txt.gz
  • Last modified: 2019/05/14 09:58
  • by michael