Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  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


NOTE: This configuration step only applies if the

D s item
are installed on a PostgreSQL instance that was not created as part of a
D s product

Please verify the datestyle setting for your PostgreSQL instance.


  1. Execute the following in PostgreSQL:

    Code Block
    trifacta=# show 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


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