The login to a BOC Management Office® database requires a role ✺DOxx«. Start pgAdmin and enter the master password you have set during the PostgreSQL server installation. It is part of the standard setup of PostgreSQL server. pgAdmin is a graphical administration tool for PostgreSQL. The following sections explain in detail, how a database for your BOC Management Office® product can be created and configured manually using pgAdmin. It creates and configures BOC Management Office® databases automatically (see Creating a Database Automatically). Otherwise you can use the tool Database Administration ( adbinstws.exe), which is installed together with every version of any BOC Management Office® product. because of specific organisational restrictions). The following complex procedure is only necessary if creating a database automatically is not possible in a specific scenario (e.g. For security reasons, the password of the role ✺DOxx« should be changed now (see Change Password of role ✺DOxx« (Optional)). The primary language serves as fallback language if some text is not available in other languages. From the Selected primary language list, select the governing language for creating models and objects. Make sure that the settings are correct, and then click Create. Optionally, activate Use customary schema name/DB user if you want to use another database login than ✺DOxx« to connect to the database and enter name and password of the user to be used in the fields DB-user name and DB-user password.ĥ. Enter the name and password of the database administrator in the DB-administrator user name and DB-administrator password boxes.Ĥ. The licence also indicates which components are available in the tool and the number of users who can use the application in parallel.ģ. The file extension of the library file is "*.axl" and the extension of the licence file "*.xxl". In the Library File and Licence File boxes, select the library file and the licence file provided by your BOC account manager. Enter the name of the new database in the Database name box. From the Database system list, select PostgreSQL. Select Create new database, and then click Next.Ģ. To create a new database, proceed as follows: 1. This tool can be launched from the BOC Management Office® product start menu by selecting Create new database, or from the installation directory by running adbinstws.exe. The latest 64 Bit Unicode PostgreSQL ODBC driver which allows the BOC Management Office® product to access the PostgreSQL database on the application server.īOC Management Office® products require a dedicated database that can be created automatically using the tool Database Administration ( adbinstws.exe).When you install PostgreSQL server, pgAdmin is installed along with the other tools. pgAdmin, a database management software for PostgreSQL on the database server, if you prefer to create the database manually.The latest 64 Bit version PostgreSQL server on the database server.Prerequisites īefore you can create a BOC Management Office® database with PostgreSQL, you need to have the following software: You can create the database automatically using the tool Database Administration ( adbinstws.exe) or create the database manually using pgAdmin or create the database from script. This document explains how to create a PostgreSQL database for BOC Management Office® products. Creating a PostgreSQL Database Introduction
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |