Phase 3¶
- Returning the Lasso report
- Troubleshooting
- What do we gather in our Lasso report?
- Detailed breakdown of gathered data
- GNU/Linux operating system ### barman crontab/cron (
barman_crontab_cron)- Description
- Report output
- Depth
- Security impact
- debug_sources (
debug_sources) - Description
- Report output
- Depth
- Security impact
- EFM CLI (
efm_cli) - Description
- Report output
- Depth
- EFM configuration (
efm_configuration) - Description
- Report output
- Depth
- EFM systemctl (
efm_systemctl) - Description
- Report output
- Depth
- Security impact
- etcd CLI (
etcd_cli) - Description
- Report output
- Depth
- Security impact
- etcd configuration (
etcd_configuration) - Description
- Report output
- Depth
- Security impact
- etcd systemctl (
etcd_systemctl) - Description
- Report output
- Depth
- Security impact
- HARP CLI (
harp_cli) - Description
- Report output
- Depth
- Security impact
- HARP configuration (
harp_configuration) - Description
- Report output
- Depth
- Security impact
- HARP systemctl (
harp_systemctl) - Description
- Report output
- Depth
- Security impact
- Block devices layout (
linux_block_devices_layout) - Description
- Report output
- Depth
- Security impact
- Processor governor (
linux_cpu_governor) - Description
- Report output
- Depth
- Security impact
- Mounted file systems and available space (
linux_devices_info) - Description
- Report output
- Depth
- Security impact
- File systems configuration (
linux_disk_configuration) - Description
- Report output
- Depth
- Security impact
- OS distribution, kernel and device data (
linux_distro_collector) - Description
- Report output
- Depth
- Security impact
- Hardware (
linux_hardware_info) - Description
- Report output
- Depth
- Security impact
- Hypervisor (
linux_hypervisor_collector) - Description
- Report output
- Depth
- Security impact
- Kernel (
linux_kernel_info) - Description
- Report output
- Depth
- Security impact
- Kernel limits (
linux_kernel_limits) - Description
- Report output
- Depth
- Security impact
- Processor usage statistics (
linux_mpstat) - Description
- Report output
- Depth
- Security impact
- Network interfaces (
linux_network_interfaces) - Description
- Report output
- Depth
- Security impact
- Installed packages via rpm or dpkg (
linux_packages_info) - Description
- Report output
- Depth
- Security impact
- PostgreSQL disk layout (
linux_postgresql_disk_layout) - Description
- Report output
- Depth
- Security impact
- SELinux (
linux_sestatus) - Description
- Report output
- Depth
- Security impact
- System identification (
linux_system_identity) - Description
- Report output
- Depth
- Security impact
- dmesg and /proc information (
linux_system_info) - Description
- Report output
- Depth
- Security impact
- System status - iostat (
linux_system_status_iostat) - Description
- Report output
- Depth
- Security impact
- System status - nfsiostat (
linux_system_status_nfsiostat) - Description
- Report output
- Depth
- Security impact
- System status - ps (
linux_system_status_ps) - Description
- Report output
- Depth
- Security impact
- System status - sar (
linux_system_status_sar) - Description
- Report output
- Depth
- Security impact
- System status - top (
linux_system_status_top) - Description
- Report output
- Depth
- Security impact
- System status - vmstat (
linux_system_status_vmstat) - Description
- Report output
- Depth
- Security impact
- systemctl units (
linux_systemctl_units) - Description
- Report output
- Depth
- Security impact
- tuned (
linux_tuned) - Description
- Report output
- Depth
- Security impact
- PEM configuration (
pem_configuration) - Description
- Report output
- Depth
- Security impact
- PEM systemctl (
pem_systemctl) - Description
- Report output
- Depth
- Security impact
- PgBouncer configuration (
pgbouncer_configuration) - Description
- Report output
- Depth
- Security impact
- PgBouncer systemctl (
pgbouncer_systemctl) - Description
- Report output
- Depth
- Security impact
- postgres/enterprisedb crontab (
postgres_enterprisedb_crontab) - Description
- Report output
- Depth
- Security impact
- repmgr CLI (
repmgr_cli) - Description
- Report output
- Depth
- Security impact
- repmgr configuration (
repmgr_configuration) - Description
- Report output
- Depth
- Security impact
- repmgr systemctl (
repmgr_systemctl) - Description
- Report output
- Depth
- Security impact
- xDB CLI (
xdb_cli) - Description
- Report output
- Depth
- Security impact
- xDB configuration (
xdb_configuration) - Description
- Report output
- Depth
- Security impact
- xDB systemctl (
xdb_systemctl) - Description
- Report output
- Depth
- Security impact
- Microsoft Windows operating system ### PEM configuration - Windows (
pem_configuration_windows)- Description
- Report output
- Depth
- Security impact
- PEM sc (
pem_sc) - Description
- Report output
- Depth
- Security impact
- Disk information (
win_disk_information) - Description
- Report output
- Depth
- Security impact
- Hosts file (
win_hosts) - Description
- Report output
- Depth
- Security impact
- MsInfo (
win_msinfo) - Description
- Report output
- Depth
- Security impact
- ODBC/64 (
win_odbc32_info) - Description
- Report output
- Depth
- Security impact
- ODBC/32 (
win_odbc64_info) - Description
- Report output
- Depth
- Security impact
- systeminfo (
win_systeminfo) - Description
- Report output
- Depth
- Security impact
- Disk volumes (
win_volumes) - Description
- Report output
- Depth
- Security impact
- xDB CLI - Windows (
xdb_cli_windows) - Description
- Report output
- Depth
- Security impact
- xDB configuration - Windows (
xdb_configuration_windows) - Description
- Report output
- Depth
- Security impact
- xDB sc (
xdb_sc) - Description
- Report output
- Depth
- Security impact
- PostgreSQL/PGD3 nstance ### Current archiver stats (
postgresql_archiver)- Description
- Report output
- Depth
- Security impact
- Available extensions (
postgresql_available_extensions) - Description
- Report output
- Depth
- Security impact
- Current bg_writer stats (
postgresql_bgwriter) - Description
- Report output
- Depth
- Security impact
- Directory with binaries (
postgresql_bin_dir) - Description
- Report output
- Depth
- Security impact
- Current configuration (
postgresql_configuration) - Description
- Report output
- Depth
- Security impact
- Configuration files (
postgresql_configuration_files) - Description
- Report output
- Depth
- Security impact
- Databases (
postgresql_databases) - Description
- Report output
- Depth
- Security impact
- postgresql_db_bdr_tables_and_views (
postgresql_db_bdr_tables_and_views) - Description
- Report output
- Depth
- Security impact
- postgresql_db_pglogical_tables_and_views (
postgresql_db_pglogical_tables_and_views) - Description
- Report output
- Depth
- Security impact
- Database/Role Setting (
postgresql_db_role_setting) - Description
- Report output
- Depth
- Security impact
- Node and snapshot data (
postgresql_node) - Description
- Report output
- Depth
- Security impact
- pg_config (
postgresql_pg_config) - Description
- Report output
- Depth
- Security impact
- pg_controldata (
postgresql_pg_controldata) - Description
- Report output
- Depth
- Security impact
- Version (
postgresql_pg_version) - Description
- Report output
- Depth
- Security impact
- Current pg_prepared_xacts contents (
postgresql_prepared_xacts) - Description
- Report output
- Depth
- Security impact
- Current pg_replication_origin_status contents (
postgresql_replication_origin) - Description
- Report output
- Depth
- Security impact
- Current pg_replication_slots contents (
postgresql_replication_slots) - Description
- Report output
- Depth
- Security impact
- Roles (
postgresql_roles) - Description
- Report output
- Depth
- Security impact
- Current activity stats (
postgresql_running_activity) - Description
- Report output
- Depth
- Security impact
- Active locks (
postgresql_running_locks) - Description
- Report output
- Depth
- Security impact
- Current pg_shmem_allocations contents (
postgresql_shmem_allocations) - Description
- Report output
- Depth
- Security impact
- Current pg_stat_replication contents (
postgresql_stat_replication) - Description
- Report output
- Depth
- Security impact
- Server subscription statistics (
postgresql_subscription_statistics) - Description
- Report output
- Depth
- Security impact
- Server subscriptions (
postgresql_subscriptions) - Description
- Report output
- Depth
- Security impact
- Tablespaces (
postgresql_tablespaces) - Description
- Report output
- Depth
- Security impact
- Details for every Postgres/BDR3 database ### PGD1 replication slots (
postgresql_db_bdr1_replication_slots)- Description
- Report output
- Depth
- Security impact
- PGD2 replication slots (
postgresql_db_bdr2_replication_slots) - Description
- Report output
- Depth
- Security impact
- PGD conflict_history_summary aggregation (
postgresql_db_bdr3_conflict_history_summary_agg) - Description
- Report output
- Depth
- Security impact
- PGD current activity stats (
postgresql_db_bdr3_stat_activity) - Description
- Report output
- Depth
- Security impact
- PGD sequences (
postgresql_db_bdr_sequences) - Description
- Report output
- Depth
- Security impact
- PGD version (
postgresql_db_bdr_version) - Description
- Report output
- Depth
- Security impact
- Database extensions (
postgresql_db_extensions) - Description
- Report output
- Depth
- Security impact
- Database indexes (
postgresql_db_indexes) - Description
- Report output
- Depth
- Security impact
- Database procedural languages (
postgresql_db_languages) - Description
- Report output
- Depth
- Security impact
- PGD monitor_group_raft (
postgresql_db_monitor_group_raft) - Description
- Report output
- Depth
- Security impact
- PGD monitor_group_versions (
postgresql_db_monitor_group_versions) - Description
- Report output
- Depth
- Security impact
- PGD monitor_local_replslots (
postgresql_db_monitor_local_replslots) - Description
- Report output
- Depth
- Security impact
- Database operators (
postgresql_db_operators) - Description
- Report output
- Depth
- Security impact
- Database partitioned tables (
postgresql_db_partitioned_tables) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.agent table tuples (
postgresql_db_pem_agent) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.agent_config table tuples (
postgresql_db_pem_agent_config) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.agent_heartbeat table tuples (
postgresql_db_pem_agent_heartbeat) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.agent_server_binding table tuples (
postgresql_db_pem_agent_server_binding) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.config table tuples (
postgresql_db_pem_config) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.email_group table tuples (
postgresql_db_pem_email_group) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.email_group_option table tuples (
postgresql_db_pem_email_group_option) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.probe table tuples (
postgresql_db_pem_probe) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.probe_schedule table tuples (
postgresql_db_pem_probe_schedule) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.schema_version() output (
postgresql_db_pem_schema_version) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.server table tuples (
postgresql_db_pem_server) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.server_heartbeat table tuples (
postgresql_db_pem_server_heartbeat) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.smtp_spool table tuples (
postgresql_db_pem_smtp_spool) - Description
- Report output
- Depth
- Security impact
- Database PEM pem.snmp_spool table tuples (
postgresql_db_pem_snmp_spool) - Description
- Report output
- Depth
- Security impact
- Pglogical subscription status (
postgresql_db_pglogical_subscription_status) - Description
- Report output
- Depth
- Security impact
- Database functions (
postgresql_db_procs) - Description
- Report output
- Depth
- Security impact
- Database publication tables (
postgresql_db_publication_tables) - Description
- Report output
- Depth
- Security impact
- Database publications (
postgresql_db_publications) - Description
- Report output
- Depth
- Security impact
- Database repmgr repmgr.events table tuples (
postgresql_db_repmgr_events) - Description
- Report output
- Depth
- Security impact
- Database repmgr repmgr.monitoring_history table tuples (
postgresql_db_repmgr_monitoring_history) - Description
- Report output
- Depth
- Security impact
- Database repmgr repmgr.nodes table tuples (
postgresql_db_repmgr_nodes) - Description
- Report output
- Depth
- Security impact
- Database repmgr repmgr.replication_status table tuples (
postgresql_db_repmgr_replication_status) - Description
- Report output
- Depth
- Security impact
- Database repmgr repmgr.show_nodes table tuples (
postgresql_db_repmgr_show_nodes) - Description
- Report output
- Depth
- Security impact
- Database schema (
postgresql_db_schemas) - Description
- Report output
- Depth
- Security impact
- Database statistics (
postgresql_db_statistics) - Description
- Report output
- Depth
- Security impact
- Database subscription tables (
postgresql_db_subscription_tables) - Description
- Report output
- Depth
- Security impact
- Database tables (
postgresql_db_tables) - Description
- Report output
- Depth
- Security impact
- Database types (
postgresql_db_types) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.xdb_mmr_pub_group table tuples (
postgresql_db_xdb_mmr_pub_group) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.xdb_pub_database table tuples (
postgresql_db_xdb_pub_database) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.xdb_pub_replog table tuples (
postgresql_db_xdb_pub_replog) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.xdb_publication_subscriptionstable tuples (
postgresql_db_xdb_publication_subscriptions) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.xdb_publications table tuples (
postgresql_db_xdb_publications) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.rrep_mmr_pub_group table tuples (
postgresql_db_xdb_rrep_mmr_pub_group) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.rrep_mmr_txset table tuples (
postgresql_db_xdb_rrep_mmr_txset) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.rrep_properties table tuples (
postgresql_db_xdb_rrep_properties) - Description
- Report output
- Depth:** shallow
- Security impact
- Database xDB _edb_replicator_pub.rrep_publication_tablestable tuples (
postgresql_db_xdb_rrep_publication_tables) - Description
- Report output
- Depth
- Security impact
- Database xDB _edb_replicator_pub.rrep_txset table tuples (
postgresql_db_xdb_rrep_txset) - Description
- Report output
- Depth
- Security impact
- Barman (Backup and Recovery Manager) ### Barman check (
barman_check)- Description
- Report output
- Depth
- Security impact
- Barman diagnose (
barman_diagnose) - Description
- Report output
- Depth
- Security impact
- Barman executable location (
barman_executable) - Description
- Report output
- Depth
- Security impact
- Barman module location (
barman_modules_path) - Description
- Report output
- Depth
- Security impact
- GNU/Linux operating system ### barman crontab/cron (
- Servers accepting upload of reports
