História stránky

...

• Kotva
  pg_createtrezor pg_createtrezor

  PG_CreateTrezor - SQL command for creating a depository database. The default value is
  CREATE DATABASE "#TREZOR#" WITH ENCODING='UTF8' OWNER=dba TABLESPACE="D2000" TEMPLATE=template0
  where #TREZOR# is the name of the depository database (defined by configuration parameter PG_TrezorName0 resp. for depository database segments 1..N by parameter PG_TrezorName). By default existence of a tablespace named D2000 and a template database template0 is required in the PostgreSQL database server.

• Kotva
  pg_trezorfilemulti pg_trezorfilemulti

  PG_TrezorFileMulti - parameter is active if the PG_TrezorFilePath parameter is also specified. The parameter defines a multiplier for the CommitCount parameterparameter. The default value of this parameter is 10.

• Kotva
  pg_trezorfilepath pg_trezorfilepath

  PG_TrezorFilePath - parameter can be used for PostgreSQL 9.5 and above. It activates writing to depository databases via files, which is 2 to 3 times faster than the standard batch insert via the ODBC interface. After PG_TrezorFileMulti * CommitCount values are accumulated, they are stored in a file named archiv_<TrezorId>_<SegmentId>.txt (e.g. archiv_4_1.txt) in directory PG_TrezorFilePath and an UPSERT into a depository database is performed, using a foreign table mapped onto this file (using PostgreSQL extension file_fdw) as a source of data.
  The directory PG_TrezorFilePath must be available both for reading and writing to the archive as well as to the PostgreSQL database; therefore, this parameter can be used if both the archive and database are on the same computer.

• Kotva
  pg_trezorname0 pg_trezorname0

  PG_TrezorName0 - mask for the name of the created depository databases. If depository database segments are enabled, this mask will be used for segment 0. The default value is appname_TREZOR_#ID#, where appname is the application's name and #ID# is replaced by the depository database number.
  E.g. for the application named Test, depository databases Test_TREZOR_1, Test_TREZOR_2, Test_TREZOR_3, etc, will be created.
  The specified mask must contain text #ID#.
  Note: If the default value is not acceptable, the desired value must be configured before enabling depository databases. Should the value of this parameter be changed after some depository databases have been created, it is necessary to rename all existing depository databases according to the newly specified mask.

• Kotva
  pg_trezorname pg_trezorname

  PG_TrezorName - mask for the name of created databases - depository database segments 1..N.
  Parameter is used only when TrezorCountSegments > 0. The default value is je appname_TREZOR_#ID#_#SEG#, where appname is the application's name, #ID# is replaced by the depository database number, and #SEG# is replaced by the segment number.
  E.g. for an application named Test with a number of segments equal to 1, databases Test_TREZOR_1, Test_TREZOR_1_1, Test_TREZOR_2, Test_TREZOR_2_2, Test_TREZOR_3, Test_TREZOR_3_1, etc will be created.
  The specified mask must contain text #ID# and #SEG#.
  Note: If the default value is not acceptable, the desired value must be configured before enabling depository databases. Should the value of this parameter be changed after some depository databases have been created, it is necessary to rename all existing depository databases according to the newly specified mask.

• Kotva
  trezorperiodpg trezorperiodpg

  TrezorPeriod - the period of the depository creation. It is specified in the format NX, where N is an integer number and X defines a time unit.
  Permitted time units are:
  • H - hour
  • D - day
  • W - week
  • M - month.
    Note: Setting the parameter either to an empty value or to 0H disables the functionality of depository databases.

...