Differences

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

--- wmanager:setup_postgresql_db [2018/02/15 06:52]
ragahv naik created
+++ — (current)
@@ Line 1: / Line 1: @@
-===== 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>