To enable multiple schema support, use the following procedure.
Procedure
- Log in to the Netezza Performance Server active
host as the nz user.
- Using a text editor, open the /nz/data/postgresql.conf file.
- Locate the enable_schema_dbo_check variable
and uncomment it by deleting the #
character at the beginning of the line.
- Change the value of the variable to one of the following
values:
- 0 (the default) places the system in legacy behavior where
users cannot create, manage, set, or drop schemas. The system ignores
any schema information and uses the current schema for the database
to which the client is connected.
- 1 enables multiple schema support in limited mode. Users can
create, alter, set, and drop schemas. If a query references an invalid
schema, the system displays a warning message and uses the current
schema for the database session or a database’s default schema for
cross-database queries.
- 2 enables enforced support for multiple schemas. Users can create, alter, set, and drop
schemas. If a query references an invalid schema, the query returns an error. This is the default
value.
- Save the changes to the postgresql.conf file
and close the file.
- Run the nzstop and then the nzstart commands
to restart the Netezza Performance Server software
for the change to take effect.
Results
After restarting the systems, permitted users can create
and manage schemas within a database.