timescale / helm-charts

Configuration and Documentation to run TimescaleDB in your Kubernetes cluster
Apache License 2.0
264 stars 223 forks source link

pgbackrest fails when pgbouncer disabled #406

Open lionelyoung opened 2 years ago

lionelyoung commented 2 years ago

Not sure if I missed it in the docs, but pgBackrest curl fails when pgBouncer is disabled. I have no problem enabling pgBouncer, this might help others who have this issue

I removed --silent from pgbackrest.yaml and then used kubectl gets logs -f ${POD} and it looks like this:

pgBackrest job fails when pgBouncer

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    17    0     0  100    17      0    148 --:--:-- --:--:-- --:--:--   147
curl: (22) The requested URL returned error: 500
HTTP/1.0 500 Internal Server Error
Server: BaseHTTP/0.6 Python/3.10.4
Date: Mon, 01 Aug 2022 23:40:20 GMT
Content-Type: application/json

pgBackrest job works when pgBouncer enabled

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
HTTP/1.0 202 Accepted
Server: BaseHTTP/0.6 Python/3.10.4
Date: Tue, 02 Aug 2022 00:05:46 GMT
Location: /backups/backup/20220802000545
Content-Type: application/json

{
    "age": 1.0,
    "duration": 1.0,
    "finished": null,
    "label": "20220802000545",
    "pgbackrest": {},
100   239    0   222  100    17    220     16  0:00:01  0:00:01 --:--:--   237
    "pid": 28,
    "returncode": null,
    "started": "2022-08-02T00:05:45+00:00",
    "status": "RUNNING"
}