Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How can I set parameter statement_timeout in barman backup configuration file ? #915

Open
Myshiner opened this issue Mar 25, 2024 · 4 comments

Comments

@Myshiner
Copy link

I got some errors like that "DETAILS: pg_start_backup(): canceling statement due to statement timeout" in backup log file and then backup task failded. so i wonder if i can set the postgresql database parameter "statement_timeout" in backup config file .

@Myshiner
Copy link
Author

image

@martinmarques
Copy link
Contributor

You should start by checking here: https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNSTRING

@barthisrael
Copy link
Contributor

For the record, you can use options in the connection string, e.g.:

$ psql "host=localhost user=postgres options='-c statement_timeout=10'"
psql (17beta1)
Type "help" for help.

postgres=# SHOW statement_timeout ;
 statement_timeout
-------------------
 10ms
(1 row)

@gonzalemario
Copy link
Contributor

@Myshiner do you need anything else from us?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants