Configuration Guide

Back Next

PostgreSQL Database Requirements

You can create a test data warehouse on a PostgreSQL database.

Use the following guidelines when you create a test data warehouse on PostgreSQL:

On the database, set the configuration parameters.

The following table lists the minimum and recommended values for the configuration parameters that you must set:

For information about configuring the database, see the documentation for the database system.

Ensure that PostgreSQL has sufficient disk space for the data files. By default, the data files are present in the following location:

<PostgreSQL installation directory>/data

Verify that the database user account has CONNECT, CREATE TABLE, and CREATE VIEW privileges.

Specify the database schema name when you use PostgreSQL as the database.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.