Pervasive PSQL Database Tasks

The following tasks pertain to databases.

For conceptual information on named databases, see Pervasive PSQL Database Concepts

To create a new database

Note
On Linux, the owner of the directory where you want to create the database must be psql. If not, error message 7039: Dictionary path is invalid results. Use the chown command to change owner of the directory. For example, chown psql directoryname.

In PCC Pervasive PSQL Explorer, right-click on the database engine for which you want the new database.

Click New4Database.

The Create New Database dialog appears (see Figure 1-1).

Provide a name for the database and a location (see Table 1-1, Identifier Restrictions by Identifier Type, ).

The name cannot be the same as an existing DSN.

Specify the additional options on the dialog as required for the database. See Table 1-9 for a discussion of the options.

To modify properties of a database

In PCC Pervasive PSQL Explorer, right-click on the database engine for which you want to modify the properties, then click Properties

.

On the Properties dialog, click the tree node for which you want to specify properties:

Directories

General

Relational Constraints

Security

Set the specific properties as required.

To delete a database

You cannot delete the database to which you are currently logged in. See To log out from a database engine in Pervasive PSQL User's Guide.

If database security is set to "mixed" or "database," you must first remove the security. You cannot delete a database if security on it is set to "mixed" or "database." See To turn off security using Pervasive PSQL Explorer and To turn off security using SQL .

In PCC Pervasive PSQL Explorer, right-click on the database engine that you want to delete.

Click Delete.

Click Yes to confirm the deletion.

The "Confirm DSN Removal" dialog appears.

If you want to remove a DSN associated with the database, ensure that the DSN is check marked in the list.

Note that multiple DSNs can be associated with one database. In such cases, you may remove the DSNs that you want and retain the ones that you want.

Optionally, select the option Always remove associated DSN entries if you want PCC to set DSN removal as the default action.

Note
If you select the option, PCC no longer prompts you for DSN removal when you delete a database. PCC will automatically remove all DSNs associated with the database being deleted.

If you decide later to turn off the option, in PCC click Window 4 Preferences 4 General.