====== TECH2018/S1/Postgres Database creation ======


=== Create a specific user/pw ===

<code>
postgres=# CREATE USER wmanager;
CREATE ROLE
postgres=# alter user wmanager WITH PASSWORD  'xxxx';
ALTER ROLE
postgres=# 
</code>

=== Create a new empty db ===
<code>
[root@mon publics]# su - postgres
-bash-4.1$ psql 
psql (8.4.20)
Type "help" for help.
postgres=# create database demo_wmanager_org;
CREATE DATABASE
postgres=# 
</code>

=== Assign database ownership ===
<code>
postgres=# alter DATABASE demo_wmanager_org owner to wmanager;
ALTER DATABASE
</code>


=== Testing the connection ===
<code>
-bash-4.1$ psql demo_wmanager_org -U wmanager -W
Password for user wmanager: 
psql (8.4.20)
Type "help" for help.

demo_wmanager_org=> 
</code>

=== Note: DateTime/currency/chartset settings ===
WManger uses your default postgres settings.
If you want to explicit setting to your database:
<code>
ALTER DATABASE demo_wmanager_org SET datestyle TO "SQL, DMY";
</code>

[[ tech2018:s1:installation_guide | Back to installation page ]]