...

1. 
   For CentOS 7.x:

   Code Block
   sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb

   
   

2. For CentOS 6.x, RHEL 6.x:

   Code Block
   sudo service postgresql-9.6 initdb

   
   

3. For RHEL 7.x:

   Code Block
   sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb

   
   

4. For Ubuntu 14.04 / 16.04:

   Code Block
   pg_createcluster -d /var/lib/postgresql/9.6/main 9.6 main

   
   

Verify datastyle value

Please verify the datestyle setting for your PostgreSQL instance.

Steps:

1. Execute the following in PostgreSQL:

   Code Block
   trifacta=# show datestyle; DateStyle ----------- ISO, MDY (1 row)

   
   

2. If the first value is not ISO, please edit the following file (PostgreSQL 9.6):
   1. RHEL/CentOS:  /var/lib/pgsql/9.6/data/postgresql.conf
   2. Ubuntu:  /etc/postgresql/9.6/main/postgresql.conf

3. Set the datestyle property to the following:

   Code Block
   datestyle = 'ISO,MDY';

   
   

4. Save the file. Restart the 

   D s platform

   .

MySQL

No additional steps are required to initialize the databases in MySQL.

...