Detailed breakdown of gathered data v4

GNU/Linux operating system

barman crontab/cron (barman_crontab_cron)

Output from crontab -l, if running as barman. Content of /etc/cron.d/barman, if it exists.

Report output:

  • File /linux/barman_cron.data: Content of /etc/cron.d/barman, if it exists
  • File /linux/barman_crontab.data: Output from barman crontab -l, if barman user

Depth: Surface

Security impact: Low Might have entries in crontab/cron with sensitive data.

debug_sources (debug_sources)

Count files under /usr/src/debug to detect the applications whose source code is present in the system and facilitate live debugging.

Report output:

  • File /linux/debug_sources.data: Sources for GNU debugger

Depth: Surface

Security impact: Low No known security impact.

EFM CLI (efm_cli)

Get output of efm cluster-status command.

Report output:

  • File /tools/efm/cli/cluster_status.out: Output of efm cluster-status cluster_name command

Depth: Surface

Security impact: Low No known security impact.

EFM configuration (efm_configuration)

EFM properties and nodes configuration files.

Report output:

  • File /tools/efm/config/efm.nodes: EFM nodes file
  • File /tools/efm/config/efm.properties: EFM properties file

Depth: Surface

Security impact: Low No known security impact.

EFM systemctl (efm_systemctl)

When EFM services are detected, collects status and cat of the corresponding services. Checks for any service whose name starts with edb-efm-.

Report output:

  • File /tools/efm/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/efm/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

etcd CLI (etcd_cli)

Gathers the output of some etcdctl commands, if etcdctl is available in the server. The commands are endpoint status and endpoint health.

Report output:

  • File /tools/etcd/cli/endpoint_status.out: Output of etcdctl endpoint status command
  • File /tools/etcd/cli/endpoint_health.out: Output of etcdctl endpoint health command

Depth: Surface

Security impact: Low No known security impact.

etcd configuration (etcd_configuration)

Collects etcd configuration file that's found in the server.

Report output:

  • File /tools/etcd/config/basename: etcd configuration file

Depth: Surface

Security impact: Low No known security impact.

etcd systemctl (etcd_systemctl)

When etcd services are detected, collects status and cat of the corresponding services. Checks for any service whose name starts with etcd.

Report output:

  • File /tools/etcd/systemd/service_name_cat.data: Output of 'systemctl cat service_name
  • File /tools/etcd/systemd/service_name_status.data: Output of 'systemctl status service_name

Depth: Surface

Security impact: low No known security impact.

HARP CLI (harp_cli)

Gathers output of a few harpctl command outputs using the config.yml file, which is found in the server. The commands are: cluster, proxies, locations, nodes, and version.

Report output:

  • File /tools/harp/cli/version.out: Output of harpctl -f conf_file_path version command
  • File /tools/harp/cli/proxies.out: Output of harpctl -f conf_file_path get proxies -o yaml command
  • File /tools/harp/cli/nodes.out: Output of harpctl -f conf_file_path get nodes -o yaml command
  • File /tools/harp/cli/locations.out: Output of harpctl -f conf_file_path get locations -o yaml command
  • File /tools/harp/cli/cluster.out: Output of harpctl -f conf_file_path get cluster -o yaml command

Depth: Surface

Security impact: Low No known security impact.

HARP configuration (harp_configuration)

Collects HARP configuration file that's found in the server.

Report output:

  • File /tools/harp/config/harp.cluster.init.yml: HARP bootstrap configuration file
  • File /tools/harp/config/basename: HARP configuration file

Depth: Surface

Security impact: Low No known security impact.

HARP systemctl (harp_systemctl)

When HARP services are detected, collects status and cat of the corresponding services. Checks for any service whose name starts with harp.

Report output:

  • File /tools/harp/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/harp/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

Block devices layout (linux_block_devices_layout)

Information on block devices layout from the lsblk command.

Report output:

  • File /linux/lsbk.data: lsbk command output

Depth: Surface

Security impact: Low No known security impact.

Processor governor (linux_cpu_governor)

Processor scaling governor from the files in /sys/devices/system/cpu.

Report output:

  • File /linux/sys/energy_perf_bias.data: Intel Performance and Energy Bias attributes
  • File /linux/sys/intel_pstate.data: Intel pstate configuration
  • File /linux/sys/cpu_scaling_driver.data: Available CPU scaling driver
  • File /linux/sys/cpu_scaling_available_governors.data: Available CPU scaling governors
  • File /linux/sys/cpu_scaling_governor.data: Active CPU scaling governor

Depth: Surface

Security impact: Low No known security impact.

Mounted file systems and available space (linux_devices_info)

List-mounted file systems through the mount command and free space using df.

Report output:

  • File /linux/diskspace.data: Amount of available disk space
  • File /linux/mount.data: Output of the mount command

Depth: Surface

Security impact: Low No known security impact.

File systems configuration (linux_disk_configuration)

Disk configuration obtained through the /etc/fstab file.

Report output:

  • File /linux/fstab.data: Contents of /etc/fstab

Depth: Surface

Security impact: Low No known security impact.

OS distribution, kernel, and device data (linux_distro_collector)

Information about the Linux distribution currently in use returned by the lsb_release command.

Report output:

  • File /linux/release.data: Linux distribution currently in use
  • File /linux/release_source.data: Name of the collected file or the executed command

Depth: Surface

Security impact: Low No known security impact.

Hardware (linux_hardware_info)

Hardware info through lspci.

Report output:

  • File /linux/lspci.data: Hardware info from lspci

Depth: Surface

Security impact: Low No known security impact.

HTTP(s) proxies in use for package downloads (linux_http_proxy_configuration)

Gathers information about HTTP(s) proxies in use for package downloads. Passwords are redacted.

Report output:

  • File /linux/packages-yum-config-manager.data: YUM configuration
  • File /linux/packages-dnf-config-manager.data: DNF configuration
  • File /linux/etc_environment.data: Contents of /etc/environment

Depth: Surface

Security Impact: Low No known security impact.

Hypervisor (linux_hypervisor_collector)

Information about the type of virtualization used, as returned by the systemd-detect-virt command.

Report output:

  • File /linux/hypervisor.data: Name of the collected file or the executed command

Depth: Surface

Security impact: Low No known security impact.

Kernel (linux_kernel_info)

Kernel info, transparent huge pages status, and disk scheduler configuration. Obtained by combining the output of the commands uname and ipcs with the contents of the /proc and /sys file systems.

Report output:

  • File /linux/read_ahead.data: Info on the read ahead
  • File /linux/schedulers.data: Scheduler info from /sys dir
  • File /linux/sys/kernel_mm_transparent_hugepage.data: Transparent huge pages info
  • File /linux/ipcs.data: ipcs command output
  • File /linux/uname.data: uname command output

Depth: Surface

Security impact: Low No known security impact.

Kernel limits (linux_kernel_limits)

Configuration file for the pam_limits module.

Report output:

  • File /linux/limits.data: Content of the limits.conf file

Depth: Surface

Security impact: Low No known security impact.

Processor usage statistics (linux_mpstat)

Processor statistics from the mpstat command.

Report output:

  • File /linux/mpstat.data: Output from mpstat -P ALL 1 10

Depth: Surface

Security impact: Low No known security impact.

Network interfaces (linux_network_interfaces)

Network interface information from the ip and ifconfig commands.

Report output:

  • File /linux/ifconfig.data: Output from ifconfig
  • File /linux/ip_address_list.data: Output from ip address list

Depth: Surface

Security impact: Low No known security impact.

Installed packages via rpm or dpkg (linux_packages_info)

Information about the system packages installed using rpm or dpkg.

Report output:

  • File /linux/packages-dpkg.data: List of packages installed using dpkg
  • File /linux/packages-rpm.data: List of packages installed using rpm

Depth: Surface

Security impact: Low No known security impact.

Installed packages origins (linux_packages_origin_info)

Information about the packages origins.

Report output:

  • File /linux/packages-apt_conf.data: apt configuration
  • File /linux/packages-apt-cache-policy.data: apt configuration
  • File /linux/packages-apt-list-installed.data: Repositories that were used to install packages
  • File /linux/packages-yum-repolist.data: Repositories that are enabled in yum
  • File /linux/packages-dnf-module-list.data: Repositories that are enabled in dnf
  • File /linux/packages-dnf-repolist.data: Repositories that are enabled in dnf
  • File /linux/packages-yum-list-installed.data: Repositories that were used to install packages
  • File /linux/packages-dnf-list-installed.data: Repositories that were used to install packages

Depth: Surface

Security Impact: Low No known security impact.

PostgreSQL disk layout (linux_postgresql_disk_layout)

List all files in the PostgreSQL data directory using find for links and ls for files.

Report output:

  • File /linux/pg_ls.data: List of files inside the data directory
  • File /linux/pg_links.data: List of links inside the data directory

Depth: Surface

Security impact: Low No known security impact.

SELinux (linux_sestatus)

SELinux status from sestatus.

Report output:

  • File /linux/sestatus.data: Output from sestatus

Depth: Surface

Security impact: Low No known security impact.

System identification (linux_system_identity)

Collect hostname, network interfaces, system info (uname), system identifier, and release info.

Report output:

  • File /linux/id/system_release.data: OS information from /etc/system-release
  • File /linux/id/os_release.data: OS information from /etc/os-release
  • File /linux/id/machine_id.data: Machine ID contained in /etc/machine-id
  • File /linux/id/uname.data: Information about the running kernel
  • File /linux/id/hostname.data: Fully qualified domain name
  • File /linux/id/interfaces.data: Network addresses of the host

Depth: Surface

Security impact: Low No known security impact.

dmesg and /proc information (linux_system_info)

System info from the contents of the /proc filesystem and through the output of dmesg command.

Report output:

  • File /linux/lsmod.data: lsmod output
  • File /linux/dmesg_with_timestamp.data: Dmesg output (human-readable timestamps)
  • File /linux/dmesg.data: dmesg output
  • File /linux/proc/sys_net_ipv4.data: Network info from /proc
  • File /linux/proc/sys_vm.data: VM info from /proc
  • File /linux/proc/sys_kernel.data: Kernel info from /proc
  • File /linux/vmstat.data: VM statistics from /proc
  • File /linux/proc/mounts.data: Mount points from /proc
  • File /linux/proc/uptime.data: Uptime info from /proc
  • File /linux/proc/loadavg.data: Load avg from /proc
  • File /linux/proc/meminfo.data: Memory info from /proc

Depth: Surface

Security impact: Low No known security impact.

System status device mapper devices (linux_system_status_dmdevices)

Get information about device mapper devices.

Report output:

  • File /linux/lsdevmapper.data: Information about /dev/mapper device mapper symlinks

Depth: Surface

Security impact: Low No known security impact.

System status iostat (linux_system_status_iostat)

System status from the iostat command.

Report output:

  • File /linux/iostat.data: Info on I/O statistics

Depth: Surface

Security impact: Low No known security impact.

System status nfsiostat (linux_system_status_nfsiostat)

System status from the nfsiostat command.

Report output:

  • File /linux/nfsiostat.data: nfs I/O statistics

Depth: Surface

Security impact: Low No known security impact.

System status ps (linux_system_status_ps)

System status from the ps command.

Report output:

  • File /linux/ps.data: Active processes info

Depth: Surface

Security impact: Low Some processes might contain sensitive data in their names.

System status sar (linux_system_status_sar)

System status from the sar command.

Report output:

  • File /linux/sar.data: Actual sar info
  • File /linux/sar-yesterday.data: sar info from yesterday

Depth: Surface

Security impact: Low No known security impact.

System status top (linux_system_status_top)

System status from the top command.

Report output:

  • File /linux/top.data: Process information

Depth: Surface

Security impact: Low Some processes might contain sensitive data in their names.

System status vmstat (linux_system_status_vmstat)

System status from the vmstat command.

Report output:

  • File /linux/vmstat.data: Info on processes, memory, paging, block IO, traps, disks, and CPU activity

Depth: Surface

Security impact: Low No known security impact.

systemctl units (linux_systemctl_units)

Systemctl list-units on a systemd server.

Report output:

  • File /linux/systemd/list-units.data: Output of systemctl list-units

Depth: Surface

Security impact: Low No known security impact.

tuned (linux_tuned)

Tuned status and profiles.

Report output:

  • Directory /linux/tuned/tune-profiles: Files from /etc/tune-profiles
  • Directory /linux/tuned/tuned: Files from /etc/tuned
  • File /linux/tuned/tuned.conf: File /etc/tuned.conf
  • File /linux/tuned/tuned-list.data: Output from tuned_adm list
  • File /linux/tuned/tuned-active.data: Output from tuned_adm active

Depth: Surface

Security impact: Low No known security impact.

PEM configuration (pem_configuration)

PEM configuration files from PEM agent, PEM server, and PEM web server.

Report output:

  • File /tools/pem/config/edb-ssl-pem.conf: PEM web server SSL configuration file
  • File /tools/pem/config/edb-pem.conf: PEM web server configuration file
  • File /tools/pem/config/install-config: PEM server configuration file (installation config file)
  • File /tools/pem/config/config_setup.py: PEM server setup configuration file
  • File /tools/pem/config/pem.wsgi: PEM server WSGI definition file
  • File /tools/pem/config/agent.cfg: PEM agent configuration file

Depth: Surface

Security impact: Low No known security impact.

PEM systemctl (pem_systemctl)

When PEM is detected, collects PEM agent and PEM web server status and content.

Report output:

  • File /tools/pem/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/pem/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

PgBouncer configuration (pgbouncer_configuration)

PgBouncer configuration files.

Report output:

  • File /tools/pgbouncer/num/config/basename: PgBouncer configuration file from instance num

Depth: Surface

Security impact: Low No known security impact.

PgBouncer systemctl (pgbouncer_systemctl)

When PgBouncer services are detected, collects status and cat of the corresponding services. Checks for any service that contains any of the PgBouncer configuration files.

Report output:

  • File /tools/pgbouncer/num/systemd/service_name_cat.data: Output of systemctl cat service_name from instance num
  • File /tools/pgbouncer/num/systemd/service_name_status.data: Output of systemctl status service_name from instance num

Depth: Surface

Security impact: Low No known security impact.

PGD Proxy configuration (pgd_proxy_configuration)

Collects PGD Proxy configuration file that's found in the server.

Report output:

  • File /tools/pgd-proxy/config/basename: PGD Proxy configuration file

Depth: Surface

Security impact: Low No known security impact.

PGD Proxy systemctl (pgd_proxy_systemctl)

When PGD Proxy services are detected, collects status and cat of the corresponding services. Checks for any service whose name starts with pgd-proxy.

Report output:

  • File /tools/pgd-proxy/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/pgd-proxy/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

postgres/enterprisedb crontab (postgres_enterprisedb_crontab)

Output from crontab -l, if running as postgres or enterprisedb.

Report output:

  • File /linux/enterprisedb_crontab.data: Output from enterprisedb crontab -l, if enterprisedb user
  • File /linux/postgres_crontab.data: Output from postgres crontab -l, if postgres user

Depth: Surface

Security impact: Low Might have entries in crontab/cron with sensitive data.

PostgreSQL systemctl (postgresql_systemctl)

Collects PostgreSQL service status and content.

Report output:

  • File /linux/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /linux/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

repmgr CLI (repmgr_cli)

Collects output of repmgr cluster crosscheck and repmgr daemon status using the repmgr.conf file, which is found in the server.

Report output:

  • File /tools/repmgr/cli/daemon_status.out: Output of repmgr daemon status -f conf_file_path command
  • File /tools/repmgr/cli/cluster_crosscheck.out: Output of repmgr cluster crosscheck -f conf_file_path command

Depth: Surface

Security impact: Low No known security impact.

repmgr configuration (repmgr_configuration)

Collects repmgr configuration file that's found in the server.

Report output:

  • File /tools/repmgr/config/repmgr.conf: repmgr configuration file

Depth: Surface

Security impact: Low No known security impact.

repmgr systemctl (repmgr_systemctl)

When repmgr services are detected, collects status and cat of the corresponding services. Checks for any service whose name starts with repmgr.

Report output:

  • File /tools/repmgr/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/repmgr/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

xDB CLI (xdb_cli)

xDB output from several CLI commands, from the xDB publication and subscription server that are running.

Report output:

  • Directory /tools/xdb/cli: xDB CLI print commands

Depth: Surface

Security impact: Low No known security impact.

xDB configuration (xdb_configuration)

xDB configuration files.

Report output:

  • File /tools/xdb/config/xdbReplicationServer.config: xDB startup configuration
  • File /tools/xdb/config/edb-repl.conf: xDB replication configuration
  • File /tools/xdb/config/xdb_subserver.conf: xDB subscription server configuration
  • File /tools/xdb/config/xdb_pubserver.conf: xDB publication server configuration

Depth: Surface

Security impact: Low No known security impact.

xDB systemctl (xdb_systemctl)

When xDB services are detected, collects status and cat of edb- xdbpubserver and edb-xdbsubserver.

Report output:

  • File /tools/xdb/systemd/service_name_cat.data: Output of systemctl cat service_name
  • File /tools/xdb/systemd/service_name_status.data: Output of systemctl status service_name

Depth: Surface

Security impact: Low No known security impact.

Microsoft Windows operating system

PEM configuration Windows (pem_configuration_windows)

PEM configuration files from PEM agent, PEM server, and PEM web server in a Windows environment.

Report output:

  • File /tools/pem/config/edb-ssl-pem.conf: PEM web server SSL configuration file
  • File /tools/pem/config/edb-pem.conf: PEM web server configuration file
  • File /tools/pem/config/pem.wsgi: PEM server WSGI definition file
  • File /tools/pem/config/agent.cfg: PEM agent configuration file

Depth: Surface

Security impact: Low No known security impact.

PEM sc (pem_sc)

When PEM is detected, collects PEM agent and PEM web server status and content

Report output:

  • File /tools/pem/sc/service_name_query.data: Output of sc query service_name

Depth: Surface

Security impact: Low No known security impact.

Disk information (win_disk_information)

Disk and controller information from the system registry.

Report output:

  • File /windows/enum_ide.reg: Local machine ide device settings
  • File /windows/enum_scsi.reg: Local machine scsi device settings

Depth: Surface

Security impact: Low No known security impact.

Hosts file (win_hosts)

Host files and network-related information.

Report output:

  • File /windows/services.data: Windows services file
  • File /windows/protocol.data: Windows protocol file
  • File /windows/networks.data: Windows networks file
  • File /windows/hosts.sam: Windows hosts.sam file
  • File /windows/hosts.data: Windows hosts file

Depth: Surface

Security impact: Low No known security impact.

MsInfo (win_msinfo)

MsInfo32 report in NFO and TXT format.

Report output:

  • File /windows/msinfo_report.txt: Information from the MsInfo32 in textual format
  • File /windows/msinfo_report.nfo: Information from the MsInfo32 in NFO

Depth: Surface

Security impact: Low No known security impact.

ODBC/64 (win_odbc32_info)

ODBC configuration from the 64-bit registry section.

Report output:

  • File /windows/user_odbc_wow64.reg: User DSN list
  • File /windows/localmachine_odbcinst_wow64.reg: List of installed ODBC drivers
  • File /windows/localmachine_odbc_wow64.reg: System DSN list

Depth: Surface

Security impact: Medium ODBC connection information could expose the presence of other databases or connection information to PostgreSQL that can be used to attack the system.

ODBC/32 (win_odbc64_info)

ODBC configuration from the 32-bit registry section.

Report output:

  • File /windows/user_odbc.reg: User DSN list
  • File /windows/localmachine_odbcinst.reg: list of installed ODBC drivers
  • File /windows/localmachine_odbc.reg: System DSN list

Depth: Surface

Security impact: Medium ODBC connection information could expose the presence of other databases or connection information to PostgreSQL that can be used to attack the system.

systeminfo (win_systeminfo)

Output of the systeminfo command.

Report output:

  • File /windows/systeminfo_report.txt: Information from the systeminfo command

Depth: Surface

Security impact: Low No known security impact.

Disk volumes (win_volumes)

Volume list from WMI.

Report output:

  • File /windows/association_structure: Association between drive letters and physical drives
  • File /windows/volume_disk: Volume list from the WMI subsystem
  • File /windows/logical_disk_list: Logical disk list from the WMI subsystem
  • File /windows/disk_partition_list: Disk partition list from the WMI subsystem
  • File /windows/disk_drive_list: Disk list from the WMI subsystem

Depth: Surface

Security impact: Low No known security impact.

xDB CLI Windows (xdb_cli_windows)

xDB output from several CLI commands, from the running xDB publication and subscription servers.

Report output:

  • Directory /tools/xdb/cli: xDB CLI print commands

Depth: Surface

Security impact: Low No known security impact.

xDB configuration Windows (xdb_configuration_windows)

xDB configuration files.

Report output:

  • File /tools/xdb/config/xdbReplicationServer.config: xDB startup configuration`
  • File /tools/xdb/config/edb-repl.conf: xDB replication configuration`
  • File /tools/xdb/config/xdb_subserver.conf: xDB subscription server configuration
  • File /tools/xdb/config/xdb_pubserver.conf: xDB publication server configuration

Depth: Surface

Security impact: Low No known security impact.

xDB sc (xdb_sc)

When xDB is detected, collects xDB publication and subscription server status.

Report output:

  • File /tools/xdb/sc/service_name_query.data: Output of sc query service_name

Depth: Surface

Security impact: Low No known security impact.

PostgreSQL/BDR3 instance

Current archiver stats (postgresql_archiver)

Statistics about the archiver process activity (from pg_stat_archiver).

Report output:

  • File postgresql/archiver.out

Depth: Surface

Security impact: Low No known security impact.

Available extensions (postgresql_available_extensions)

List of extensions available on the server.

Report output:

  • File postgresql/available_extensions.out

Depth: Surface

Security impact: Low No known security impact.

Current bg_writer stats (postgresql_bgwriter)

Statistics about the background writer process activity (from pg_stat_bgwriter).

Report output:

  • File postgresql/bgwriter.out

Depth: Surface

Security impact: Low No known security impact.

Directory with binaries (postgresql_bin_dir)

PostgreSQL binary directory.

Report output:

  • File /postgresql/postgresql_bin_path.data: Path to the PostgreSQL bin directory

Depth: Surface

Security impact: Low No known security impact.

Current configuration (postgresql_configuration)

PostgreSQL current configuration.

Report output:

  • File postgresql/configuration.out

Depth: Surface

Security impact: Medium postgresql.conf might contain bad security policies

Configuration files (postgresql_configuration_files)

PostgreSQL configuration files and the data directory path. Passwords contained in well-known connection strings are redacted for information-security reasons.

Report output:

  • File /postgresql/pg_ident.conf: PostgreSQL ident configuration file
  • File /postgresql/pg_hba.conf: PostgreSQL host-based authentication file
  • File /postgresql/postgresql.auto.conf: PostgreSQL auto configuration file
  • File /postgresql/recovery.done: PostgreSQL recovery.done file
  • File /postgresql/recovery.conf: PostgreSQL recovery.conf file
  • File /postgresql/postgresql.conf: PostgreSQL configuration file

Depth: Surface

Security impact: Medium pg_hba.conf and pg_ident.conf might expose potential security holes, such as trusted connections.

Current rate of new connections established to the DB (postgresql_conns_per_second)

Current rate of new connections established during 3s observation period.

Report output:

  • File postgresql/conns_per_second.out

Depth: Surface

Security impact: Low No known security impact.

Databases (postgresql_databases)

List of databases in the PostgreSQL node.

Report output:

  • File postgresql/databases.out

Depth: Surface

Security impact: Low No known security impact.

postgresql_db_bdr_tables_and_views (postgresql_db_bdr_tables_and_views)

Collect all the tables and views of the BDR extension, except for:

  • bdr.apply_log
  • bdr.conflict_history
  • bdr.consensus_kv_data
  • bdr.internal_node_pre_commit
  • bdr.replication_status
  • bdr.state_journal
  • bdr.stat_activity

Report output:

  • File /postgresql/dbs/dbname/bdr/*: Content of all tables under the BDR schema

Depth: Shallow

Security impact: Low No known security impact.

postgresql_db_pglogical_tables_and_views (postgresql_db_pglogical_tables_and_views)

Collect all the tables and views of the pglogical extension.

Report output:

  • File /postgresql/dbs/dbname/pglogical/*: Content of all tables under the pglogical schema

Depth: Shallow

Security impact: Low No known security impact.

Database/role setting (postgresql_db_role_setting)

List of database/role settings in the PostgreSQL node.

Report output:

  • File postgresql/db_role_setting.out

Depth: Shallow

Security impact: Low No known security impact.

Node and snapshot data (postgresql_node)

Information about the running PostgreSQL node.

Report output:

  • File postgresql/node.out

Depth: Surface

Security impact: Low No known security impact.

pg_config (postgresql_pg_config)

PostgreSQL pg_config command output.

Report output:

  • File /postgresql/pg_config.data: pg_config command output

Depth: Surface

Security impact: Low No known security impact.

pg_controldata (postgresql_pg_controldata)

PostgreSQL pg_controldata information.

Report output:

  • File /postgresql/pg_controldata.data: pg_controldata command output

Depth: Surface

Security impact: Low No known security impact.

Version (postgresql_pg_version)

PostgreSQL client and server version.

Report output:

  • File /postgresql/postgresql_server_version.data: PostgreSQL server version
  • File /postgresql/postgresql_client_version.data: PostgreSQL client version

Depth: Surface

Security impact: Low No known security impact.

Current pg_prepared_xacts contents (postgresql_prepared_xacts)

Status of prepared xacts (from pg_prepared_xacts)

Report output:

  • File postgresql/prepared_xacts.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_replication_origin_status contents (postgresql_replication_origin)

Status of replication origins (from pg_replication_origin_status)

Report output:

  • File postgresql/replication_origins.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_replication_slots contents (postgresql_replication_slots)

Replication slots (from pg_replication_slots).

Report output:

  • File postgresql/replication_slots.out

Depth: Surface

Security impact: Low No known security impact.

Roles (postgresql_roles)

Database roles from pg_roles.

Report output:

  • File postgresql/roles.out

Depth: Shallow

Security impact: Medium pg_roles might contain bad security policies.

Current activity stats (postgresql_running_activity)

Information related to the current activity on running processes (from pg_stat_activity).

Report output:

  • File postgresql/running_activity.out

Depth: Shallow

Security impact: Low Queries in pg_stat_activity could contain user names and application names.

Age of current oldest running backend/transaction/query in the cluster (postgresql_running_activity_oldestage)

Age of current oldest running backend/transaction/query in the cluster.

Report output:

  • File postgresql/running_activity_maxage.out

Depth: Surface

Security impact: Low No known security impact.

Active locks (postgresql_running_locks)

List of active locks.

Report output:

  • File postgresql/running_locks.out

Depth: Surface

Security impact: Low No known security impact.

pg_server_limits (postgresql_server_limits)

Real effective kernel OS limits for the postmaster PID.

Report output:

  • File /postgresql/pg_server_limits_PORT.data: prlimit for postmaster PID

Depth: Surface

Security impact: Low No known security impact.

Current pg_shmem_allocations contents (postgresql_shmem_allocations)

Status of shared memory allocations (from pg_shmem_allocations).

Report output:

  • File postgresql/shmem_allocations.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_stat_progress_analyze contents (postgresql_stat_progress_analyze)

ANALYZE progress.

Report output:

  • File postgresql/pg_stat_progress_analyze.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_stat_progress_basebackup contents (postgresql_stat_progress_basebackup)

BASEBACKUP progress.

Report output:

  • File postgresql/pg_stat_progress_basebackup.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_stat_progress_copy contents (postgresql_stat_progress_copy)

COPY progress.

Report output:

  • File postgresql/pg_stat_progress_copy.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_stat_progress_vacuum contents (postgresql_stat_progress_vacuum)

VACUUM progress.

Report output:

  • File postgresql/pg_stat_progress_vacuum.out

Depth: Surface

Security impact: Low No known security impact.

Current pg_stat_replication contents (postgresql_stat_replication)

Replication connections (from pg_stat_replication).

Report output:

  • File postgresql/replication.out

Depth: Surface

Security impact: Low No known security impact.

Server subscription statistics (postgresql_subscription_statistics)

Statistics of subscriptions.

Report output:

  • File postgresql/subscription_statistics.out

Depth: Shallow

Security impact: Low No known security impact.

Server subscriptions (postgresql_subscriptions)

List of subscriptions.

Report output:

  • File postgresql/subscriptions.out

Depth: Shallow

Security impact: Low No known security impact.

Tablespaces (postgresql_tablespaces)

Tablespaces information and location.

Report output:

  • File postgresql/tablespaces.out

Depth: Surface

Security impact: Low No known security impact.

Workload characteristics using waits (postgresql_waits_stats)

PostgreSQL workload characterization using built-in wait events.

Report output:

  • File postgresql/running_waits_sample.out: Workload characterization using built-in wait events

Depth: Surface

Security impact: Low No known security impact.

Details for every PostgreSQL/BDR3 database

BDR1 replication slots (postgresql_db_bdr1_replication_slots)

List of replication slots with 9.6 format for BDR1.

Report output:

  • File bdr1_replication_slots.out

Depth: Surface

Security impact: Low No known security impact.

BDR2 replication slots (postgresql_db_bdr2_replication_slots)

List of replication slots with 9.6 format for BDR2.

Report output:

  • File bdr2_replication_slots.out

Depth: Surface

Security impact: Low No known security impact.

BDR conflict_history_summary aggregation (postgresql_db_bdr3_conflict_history_summary_agg)

Collect aggregate count for all types of conflicts.

Report output:

  • File bdr_conflict_history_summary_agg.out

Depth: Surface

Security impact: Low No known security impact.

BDR current activity stats (postgresql_db_bdr3_stat_activity)

Information related to the current activity on running processes (from bdr.stat_activity).

Report output:

  • File bdr_stat_activity.out

Depth: Shallow

Security impact: Low Queries in bdr.stat_activity could contain user names and application names.

BDR sequences (postgresql_db_bdr_sequences)

List of the BDR sequences.

Report output:

  • File bdr_sequences.out

Depth: Surface

Security impact: Low No known security impact.

BDR version (postgresql_db_bdr_version)

Currently used version of BDR.

Report output:

  • File bdr_version.out

Depth: Surface

Security impact: Low No known security impact.

edb_wait_states database settings (postgresql_db_edb_wait_states_database_settings)

Shows information on database settings.

Report output:

  • File edb_wait_states/database_settings.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states load profile (postgresql_db_edb_wait_states_load_profile)

Average load profile of transactions.

*Report output:

  • File edb_wait_states/load_profile.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states operating system information (postgresql_db_edb_wait_states_operating_system_information)

Information about the operating system.

Report output:

  • File edb_wait_states/operating_system_information.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states server information part 1 (postgresql_db_edb_wait_states_server_information_1)

Information about the Postgres server part 1.

Report output:

  • File edb_wait_states/server_information_1.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states server information part 2 (postgresql_db_edb_wait_states_server_information_2)

Information about the Postgres server part 2.

Report output:

  • File edb_wait_states/server_information_2.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states shared buffers statistics (postgresql_db_edb_wait_states_shared_buffers_stats)

Shows statistics in terms of buffer hits and misses.

Report output:

  • File edb_wait_states/shared_buffers_stats.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states temp file statistics (postgresql_db_edb_wait_states_temp_file_stats)

Shows statistics about temp files usage.

Report output:

  • File edb_wait_states/temp_file_stats.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states top 10 SQL statements by cputime (postgresql_db_edb_wait_states_top_sql_statements_cputime)

Shows which SQL statements are taking more CPU time.

Report output:

  • File edb_wait_states/top_sql_statements_cputime.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states top 10 SQL statements by dbtime (postgresql_db_edb_wait_states_top_sql_statements_dbtime)

Shows which SQL statements are taking more database time.

Report output:

  • File edb_wait_states/top_sql_statements_dbtime.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states top 10 SQL statements by waittime (postgresql_db_edb_wait_states_top_sql_statements_waittime)

Shows which SQL statements are waiting for more time.

Report output:

  • File edb_wait_states/top_sql_statements_waittime.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states top 10 wait events (postgresql_db_edb_wait_states_top_wait_events)

Shows which events are taking more time on the cluster.

Report output:

  • File edb_wait_states/top_wait_events.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states transactions statistics (postgresql_db_edb_wait_states_transaction_stats)

Shows statistics in terms of commits and rollbacks.

Report output:

  • File edb_wait_states/transaction_stats.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states tuple statistics (postgresql_db_edb_wait_states_tuple_stats)

Shows statistics in terms of tuple reads and writes.

Report output:

  • File edb_wait_states/tuple_stats.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states user sessions (postgresql_db_edb_wait_states_user_sessions)

Shows information about user sessions.

Report output:

  • File edb_wait_states/user_sessions.out

Depth: Shallow

Security impact: Low No known security impact.

edb_wait_states WAL statistics (postgresql_db_edb_wait_states_wal_stats)

Shows statistics in terms of WAL writes.

Report output:

  • File edb_wait_states/wal_stats.out

Depth: Shallow

Database extensions (postgresql_db_extensions)

List of extensions in the database.

Report output:

  • File extensions.out

Depth: Shallow

Security impact: Low No known security impact.

Database indexes (postgresql_db_indexes)

List of indexes in the database.

Report output:

  • File indexes.out

Depth: Shallow

Security impact: Low No known security impact.

Database procedural languages (postgresql_db_languages)

Procedural languages in the database.

Report output:

  • File language.out

Depth: Shallow

Security impact: Low No known security impact.

BDR monitor_group_raft (postgresql_db_monitor_group_raft)

Check the raft status in the BDR cluster.

Report output:

  • File bdr_monitor_group_raft.out

Depth: Surface

Security impact: Low No known security impact.

BDR monitor_group_versions (postgresql_db_monitor_group_versions)

Check the version of all BDR nodes.

Report output:

  • File bdr_monitor_group_versions.out

Depth: Surface

Security impact: Low No known security impact.

BDR monitor_local_replslots (postgresql_db_monitor_local_replslots)

Check all the replication slot status.

Report output:

  • File bdr_monitor_local_replslots.out

Depth: Surface

Security impact: Low No known security impact.

Database operators (postgresql_db_operators)

Operators in the database.

Report output:

  • File operator.out

Depth: Shallow

Security impact: Low No known security impact.

Database partitioned tables (postgresql_db_partitioned_tables)

Information about partitioned tables (using declarative partitioning).

Report output:

  • File partitioned_table.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.agent table tuples (postgresql_db_pem_agent)

Data from metatable pem.agent.

Report output:

  • File pem_agent.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.agent_config table tuples (postgresql_db_pem_agent_config)

Data from metatable pem.agent_config.

Report output:

  • File pem_agent_config.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.agent_heartbeat table tuples (postgresql_db_pem_agent_heartbeat)

Data from metatable pem.agent_heartbeat.

Report output:

  • File pem_agent_heartbeat.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.agent_server_binding table tuples (postgresql_db_pem_agent_server_binding)

Data from metatable pem.agent_server_binding.

Report output:

  • File pem_agent_server_binding.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.config table tuples (postgresql_db_pem_config)

Data from metatable pem.config.

Report output:

  • File pem_config.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.email_group table tuples (postgresql_db_pem_email_group)

Data from metatable pem.email_group.

Report output:

  • File pem_email_group.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.email_group_option table tuples (postgresql_db_pem_email_group_option)

Data from metatable pem.email_group_option.

Report output:

  • File pem_email_group_option.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.probe table tuples (postgresql_db_pem_probe)

Data from metatable pem.probe.

Report output:

  • File pem_probe.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.probe_schedule table tuples (postgresql_db_pem_probe_schedule)

Data from metatable pem.probe_schedule.

Report output:

  • File pem_probe_schedule.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.schema_version() output (postgresql_db_pem_schema_version)

Output from function pem.schema_version().

Report output:

  • File pem_schema_version.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.server table tuples (postgresql_db_pem_server)

Data from metatable pem.server.

Report output:

  • File pem_server.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.server_heartbeat table tuples (postgresql_db_pem_server_heartbeat)

Data from metatable pem.server_heartbeat.

Report output:

  • File pem_server_heartbeat.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.smtp_spool table tuples (postgresql_db_pem_smtp_spool)

Data from metatable pem.smtp_spool.

Report output:

  • File pem_smtp_spool.out

Depth: Shallow

Security impact: Low No known security impact.

Database PEM pem.snmp_spool table tuples (postgresql_db_pem_snmp_spool)

Data from metatable pem.snmp_spool.

Report output:

  • File pem_snmp_spool.out

Depth: Shallow

Security impact: Low No known security impact.

Pglogical subscription status (postgresql_db_pglogical_subscription_status)

List of tables replicated by pglogical.

Report output:

  • File pglogical_subscription_status.out

Depth: Surface

Security impact: Low No known security impact.

Database functions (postgresql_db_pkgs)

Database packages/functions/procedures with arguments.

Report output:

  • File pkgs.out

Depth: Shallow

Security impact: Low No known security impact.

Database functions (postgresql_db_procs)

Functions in the database.

Report output:

  • File proc.out

Depth: Shallow

Security impact: Low No known security impact.

Database publication tables (postgresql_db_publication_tables)

List of tables of publications of the database.

Report output:

  • File publication_tables.out

Depth: Shallow

Security impact: Low No known security impact.

Database publications (postgresql_db_publications)

List of publications of the database.

Report output:

  • File publications.out

Depth: Shallow

Security impact: Low No known security impact.

Database repmgr repmgr.events table tuples (postgresql_db_repmgr_events)

Data from metatable repmgr.events.

Report output:

  • File repmgr/events.out

Depth: Shallow

Security impact: Low No known security impact.

Database repmgr repmgr.monitoring_history table tuples (postgresql_db_repmgr_monitoring_history)

Data from metatable repmgr.monitoring_history.

Report output:

  • File repmgr/monitoring_history.out

Depth: Shallow

Security impact: Low No known security impact.

Database repmgr repmgr.nodes table tuples (postgresql_db_repmgr_nodes)

Data from metatable repmgr.nodes.

Report output:

  • File repmgr/nodes.out

Depth: Shallow

Security impact: Low No known security impact.

Database repmgr repmgr.replication_status table tuples (postgresql_db_repmgr_replication_status)

Data from metatable repmgr.replication_status.

Report output:

  • File repmgr/replication_status.out

Depth: Shallow

Security impact: Low No known security impact.

Database repmgr repmgr.show_nodes table tuples (postgresql_db_repmgr_show_nodes)

Data from metatable repmgr.show_nodes.

Report output:

  • File repmgr/show_nodes.out

Depth: Shallow

Security impact: Low No known security impact.

Database schema (postgresql_db_schemas)

List of schemas in the database.

Report output:

  • File schemas.out

Depth: Shallow

Security impact: Low No known security impact.

Database statistics (postgresql_db_statistics)

Statistics of the database.

Report output:

  • File statistics.out

Depth: Deep

Security impact: Low No known security impact.

Database subscription tables (postgresql_db_subscription_tables)

List of tables of subscriptions of the database.

Report output:

  • File subscription_tables.out

Depth: Shallow

Security impact: Low No known security impact.

Database tables (postgresql_db_tables)

List of tables in the database.

Report output:

  • File tables.out

Depth: Shallow

Security impact: Low No known security impact.

Database types (postgresql_db_types)

Types in the database.

Report output:

  • File type.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.xdb_mmr_pub_group table tuples (postgresql_db_xdb_mmr_pub_group)

Data from metatable _edb_replicator_pub.xdb_mmr_pub_group.

Report output:

  • File xdb_mmr_pub_group.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.xdb_pub_database table tuples (postgresql_db_xdb_pub_database)

Data from metatable _edb_replicator_pub.xdb_pub_database.

Report output:

  • File xdb_pub_database.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.xdb_pub_replog table tuples (postgresql_db_xdb_pub_replog)

Last 50 rows from metatable _edb_replicator_pub.xdb_pub_replog.

Report output:

  • File xdb_pub_replog.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.xdb_publication_subscriptionstable tuples (postgresql_db_xdb_publication_subscriptions)

Data from metatable _edb_replicator_pub.xdb_publication_subscriptions.

Report output:

  • File xdb_publication_subscriptions.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.xdb_publications table tuples (postgresql_db_xdb_publications)

Data from metatable _edb_replicator_pub.xdb_publications.

Report output:

  • File xdb_publications.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.rrep_mmr_pub_group table tuples (postgresql_db_xdb_rrep_mmr_pub_group)

Data from metatable _edb_replicator_pub.rrep_mmr_pub_group.

Report output:

  • File xdb_rrep_mmr_pub_group.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.rrep_mmr_txset table tuples (postgresql_db_xdb_rrep_mmr_txset)

Last 10 rows from metatable _edb_replicator_pub.rrep_mmr_txset.

Report output:

  • File xdb_rrep_mmr_txset.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.rrep_properties table tuples (postgresql_db_xdb_rrep_properties)

Data from from metatable _edb_replicator_pub.rrep_properties.

Report output:

  • File xdb_rrep_properties.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.rrep_publication_tablestable tuples (postgresql_db_xdb_rrep_publication_tables)

Data from from metatable _edb_replicator_pub.rrep_publication_tables.

Report output:

  • File xdb_rrep_publication_tables.out

Depth: Shallow

Security impact: Low No known security impact.

Database xDB _edb_replicator_pub.rrep_txset table tuples (postgresql_db_xdb_rrep_txset)

Data from metatable _edb_replicator_pub.rrep_txset.

Report output:

  • File xdb_pub_rrep_txset.out

Depth: Shallow

Security impact: Low No known security impact.

Oracle-compatibile partitioning key view (postgresql_epas_all_part_key_columns)

Provides partitioning key details (all_part_key_columns, EDB Postgres Advanced Server specific).

Report output:

  • File epas_all_part_key_columns.out

Depth: Surface

Security impact: Low No known security impact.

Oracle-compatibile all partitioned table view (postgresql_epas_all_part_tables)

All partitioned tables view (from all_part_tables, EDB Postgres Advanced Server specific).

Report output:

  • File epas_all_part_tables.out

Depth: Surface

Security impact: Low No known security impact.

Oracle-compatibile subpartitioning key view (postgresql_epas_all_subpart_key_columns)

Provides subpartitioning key details (all_subpart_key_columns, EDB Postgres Advanced Server specific).

Report output:

  • File epas_all_subpart_key_columns.out

Depth: Surface

Security impact: Low No known security impact.

Oracle-compatibile all table partitions view (postgresql_epas_all_tab_partitions)

All partitions of all partitioned tables view (all_tab_partitions, EDB Postgres Advanced Server specific).

Report output:

  • File epas_all_tab_partitions.out

Depth: Surface

Security impact: Low No known security impact.

Oracle-compatibile all table subpartitioning view (postgresql_epas_all_tab_subpartitions)

All subpartitions of all partitioned tables view (all_tab_subpartitions, EDB Postgres Advanced Server specific).

Report output:

  • File epas_all_tab_subpartitions.out

Depth: Surface

Security impact: Low No known security impact.

Current EDB Postgres Advanced Server dblink information from edb_dblink.

Report output:

  • File epas_dblink.out

Depth: Surface

Security impact: Low No known security impact.

EDB Postgres Advanced Server-specific queue information (postgresql_epas_queue)

Current EDB Postgres Advanced Server queue information from edb_queue.

Report output:

  • File epas_edb_queue.out

Depth: Surface

Security impact: Low No known security impact.

EDB Postgres Advanced Server-specific queue callback information (postgresql_epas_queue_callback)

Current EDB Postgres Advanced Server queue callback information from edb_queue_callback.

Report output:

  • File epas_edb_queue_callback.out

Depth: Surface

Security impact: Low No known security impact.

EDB Postgres Advanced Server-specific queue table information (postgresql_epas_queue_table)

Current EDB Postgres Advanced Server queue table information from edb_queue_table.

Report output:

  • File epas_edb_queue_table.out

Depth: Surface

Security impact: Low No known security impact.

Barman (Backup and Recovery Manager)

Barman check (barman_check)

Collect the status of the Barman check framework for all configured servers.

Report output:

  • File /barman/barman_check.data: Output of barman check

Depth: Surface

Security impact: Low No known security impact.

Barman diagnose (barman_diagnose)

Collect the Barman diagnosis information.

Report output:

  • File /barman/diagnose.data: Output from barman diagnose

Depth: Surface

Security impact: Low No known security impact.

Barman executable location (barman_executable)

Collect the barman executable location.

Report output:

  • File /barman/barman_location.data: The path of the main barman executable

Depth: Surface

Security impact: Low No known security impact.

Barman module location (barman_modules_path)

Collect the location of the Barman Python modules.

Report output:

  • File /barman/barman_python_verbose.data: The list of Barman Python modules

Depth: Surface

Security impact: Low No known security impact.