Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
redhat:other-redhat:psono-server-redhat [2019/05/14 09:58] – michael | redhat: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 < | + | - First install some requirements: < |
# yum -y install https:// | # yum -y install https:// | ||
# 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 | ||
</ | </ | ||
- | - Now lets switch the postgres user < | + | - Now lets switch the postgres user: < |
- | - Create our new DB < | + | - Create our new DB: < |
- | - Now switch the command prompt to postgres command prompt < | + | - Now switch the command prompt to postgres command prompt: < |
- Followed by some nice postgres commands to create the user and grant all privileges: < | - Followed by some nice postgres commands to create the user and grant all privileges: < | ||
CREATE USER psono WITH PASSWORD ' | CREATE USER psono WITH PASSWORD ' | ||
GRANT ALL PRIVILEGES ON DATABASE " | GRANT ALL PRIVILEGES ON DATABASE " | ||
- | </ | + | </ |
- Install some necessary extensions: < | - Install some necessary extensions: < | ||
CREATE EXTENSION IF NOT EXISTS ltree; | CREATE EXTENSION IF NOT EXISTS ltree; | ||
CREATE EXTENSION IF NOT EXISTS " | CREATE EXTENSION IF NOT EXISTS " | ||
</ | </ | ||
- | - (optional) If you want to use this database for unit testing, you should also do: < | + | - //(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:< | - To exit this shell and return to your normal user do:< | ||
\q | \q |