Bulk Load Logging for PostgreSQL Database
There is one log file created for each data input file. The bulk load process logs the various stages of execution. A unique ID is generated for each load.
The log files for the bulk load are created in the data directory of PostgreSQL <FSI_HOME>/bin/pgsql/data/directory.
The following log files are generated for the particular load process:
- Stored Procedure Log File
- This file is created by the procedures which copy the records from the external table to the actual table. This file displays the errors encountered during the copying process. It also displays the current status of the load. The file name has the following format:
Log-SP_<EntityName>_<LoadId>.log. For example,
25-Sept-201815:34:51 - Load has started 25-Sept-201815:34:51 - Completed load of inventory items after loading 1 record out of 1 record 25-Sept-201815:34:51 - Load has ended
Copyright © Cloud Software Group, Inc. All rights reserved.