Adding further data collection to pt-k8s-debug-collector

Description

Hello team,

The support team struggled a lot with PostgreSQL Operator issues related to the backup and restore process.
We made a sync-up with the engineering team, and we asked what logs would be relevant for them if we need to escalate the problem.
Additionally to the existing data collection we need to collect

  1. Database logs (everything under $PGDATA/logs. Similar to what we would get by performing:
    kubectl exec -i cluster1-instance1-xxxx-0 -c database -- bash -c 'tar cz /pgdata/*/log' > cluster1-instance1-xxxx-0.tar

  2. Output of patronictl list. Similar to what we would get by performing:
    kubectl exec cluster1-instance1-xxxx-0 -c database -i -- bash -c 'patronictl list' > patronictl_list.log

  3. pgbackrest container logs

    kubectl logs cluster1-instance1-xxxx-0 -c pgbackrest > cluster1-instance1-xxxx-0_pgbackrest_container.log

  4. pgbackrest execution logs
    kubectl exec -i cluster1-instance1-xxxx-0 -c pgbackrest -- bash -c 'tar cz /pgdata/pgbackrest/log' > cluster1-instance1-xxxx-0_pgbackrest_execution_logs.tar

  5. pgbackrest info output
    kubectl exec cluster1-repo-host-0 -it -c pgbackrest -- bash -c 'pgbackrest info' > pgbackrest_info.out

If you need any additional info, please let us know.

Best regards,

Environment

None

Activity

Show:

Aaditya Dubey January 27, 2025 at 10:42 AM

Hi

Thank you for the report and feedback.

Details

Assignee

Reporter

Priority

Fix versions

Needs QA

Yes

Smart Checklist

Created January 24, 2025 at 7:51 PM
Updated January 27, 2025 at 10:55 AM