Create the INOW database - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License

To create the Perceptive Content INOW Database, complete the following steps.

  1. Log in to the postgres database as the postgres user.
  2. Execute the PostgreSQL version of the full DDL script: SunflowerPG.sql.
    Note: You must execute thePerceptive Content DDL scriptsfrom the command line using thePSQL utility.Specific psql commands within the script will not work with GUI tools, such as pgAdmin III.
    EXAMPLE CONNECT STRING:
    
    psql -h <IP_ADDRESS or localhost> -d postgres -U postgres -p 5432
    
    EXAMPLE OF EXECUTING A SCRIPT WITHIN PSQL:
    
    \i C:/DDL/7.3.0/ddl/SunflowerPG.sql
    \i 'C:/DDL/7.3.0/ddl/SunflowerPG.sql'