Skip to main content

PostgreSQL for 1C cluster logs

Logging uses the Logs service. For more information about how the service works and its cost, see the Logs Service Overview guide. You can check the availability of the Logs service across locations in the Logs Availability by Location.

For a PostgreSQL for 1C Managed Database cluster, events in PostgreSQL databases are logged.

To collect cluster logs in the Logs service, enable logging. You can get logs in the control panel using API requests or via AWS CLI. If you no longer need to collect logs, you can disable logging.

Logs are stored for 30 days.

For more information about logging in PostgreSQL databases, see the Error Reporting and Logging guide in the PostgreSQL documentation.

Enable logging

You can enable logging via the API or in the Control Panel:

Enable logging in an existing cluster

Logging uses a portion of the cluster's computing resources. To control the amount of consumed resources, monitor the cluster node metrics. For more information on how to view metrics, see the article Monitoring of the cluster, nodes and databases PostgreSQL for 1C.

  1. In the Control Panel, in the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the Logging block, in the Log service field, click Connect.
  5. Select a log group or create a new group.
  6. If you selected a new group, enter its name.
  7. Click Save.

Get logs

Use the Get logs instructions in the Logs section.

An event stream postgresql.log-<instance_id> will be created for the PostgreSQL for 1C Managed Database cluster, where <instance_id> is the node ID of the PostgreSQL for 1C cluster.

View the description of log fields for the PostgreSQL cluster.

Log fields

_HOSTNAMECluster node name in the format dbaas-<instance_id>, where <instance_id> is the node ID of the PostgreSQL for 1C cluster
SYSLOG_IDENTIFIERLog source name
SYSLOG_TIMESTAMPLog event time
MESSAGEDescription of the event sent by the log source

Disable logging

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the Logging block in the Log Service field, click .
  5. Uncheck the Collect technical cluster logs to log service checkbox.
  6. Click Save.