High availabilityĪt this version of i2 Analyze, PostgreSQL is not supported in deployments for which HADR is required. ![]() The PostgreSQL installation process creates a suitable user that has the name postgres and a password that you specify during the procedure. The PostgreSQL database user that you specify in credentials.properties must be a superuser, and it must have all available privileges enabled. If you need to be able to run tasks such as deletion by rule on an automated schedule, you must install a third-party tool such as pg_cron. PostgreSQL does not have a built-in scheduling agent. On Linux, it's just referred to as the "client". Note: On Windows, this installation is called the "Command Line Tools". The PostgreSQL client Command Line Tools (that is, psql) must be installed on the same server as the i2 Analyze toolkit. For these and other downloads associated with PostgreSQL, see the official download page at. Note: PostgreSQL packages and installers are available with and without PostGIS. EXPLAIN ANALYZE SELECT lastname FROM employees where salary > 50000 QUERY. Other featuresĪll installations of PostgreSQL for use with i2 Analyze must include the PostGIS (geospatial) extension. Postgres has a great ability to show you how it will actually execute a. Important: Before any deployment of i2 Analyze with the Chart Store or the Information Store, read the documentation about the Collation_Deterministic, Collation_Locale, and Collation_Sensitivity settings in InfoStoreNamesPostgres.properties and change the default values if you need to. ![]() In PostgreSQL, the collation settings that determine the case- and accent-sensitivity of comparisons in a database (for example, whether Cafe matches café) are set at creation and cannot be changed without re-creating the database. In addition, an example deployment needs the PostgreSQL database server to listen on (the default) port 5432. If you are creating an example deployment, install PostgreSQL (server and client) in the following location:įor Windows: C:/Program Files/PostgreSQL/15 ![]() When you install PostgreSQL, record the location of the installation directory because you must specify this location in the deployment toolkit before you can deploy i2 Analyze. If you are creating a production deployment, you can install PostgreSQL in any location. This topic describes how to install PostgreSQL for use with i2 Analyze. I2 Analyze supports using PostgreSQL as its database management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |