PostgreSQL ERROR: canceling statement due to conflict with recovery

by

No need to touch hot_standby_feedback. As others have mentioned, setting it to on can bloat master. Imagine opening transaction on a slave and not closing it.

Instead, set max_standby_archive_delay and max_standby_streaming_delay to some sane value:

# /etc/postgresql/10/main/postgresql.conf on a slave
max_standby_archive_delay = 900s
max_standby_streaming_delay = 900s

This way queries on slaves with a duration less than 900 seconds won’t be cancelled. If your workload requires longer queries, just set these options to a higher value.

More Related Contents:

  1. How to exit from PostgreSQL command line utility: psql
  2. Generating time series between two dates in PostgreSQL
  3. I forgot the password I entered during postgres installation
  4. Generate series of dates – using date type as input
  5. Test for null in function with varying parameters
  6. Postgres query optimization (forcing an index scan)
  7. Dynamically generate columns for crosstab in PostgreSQL
  8. I forgot the password I entered during PostgreSQL installation
  9. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  10. Postgresql insert trigger to set value
  11. How to add column if not exists on PostgreSQL?
  12. now() default values are all showing same timestamp
  13. Convert escaped Unicode character back to actual character in PostgreSQL
  14. Why the “Group BY” by month didn’t work? [closed]
  15. Truncating all tables in a Postgres database
  16. How can I drop all the tables in a PostgreSQL database?
  17. How to change PostgreSQL user password?
  18. quick random row selection in Postgres
  19. Running PostgreSQL in memory only
  20. How do I login and authenticate to Postgresql after a fresh install?
  21. Strange behaviour in Postgresql
  22. Postgres: Distinct but only for one column
  23. Cursor based records in PostgreSQL
  24. Docker – Postgres and pgAdmin 4 : Connection refused
  25. Configuration parameter work_mem in PostgreSQL on Linux
  26. How to delete an enum type value in postgres?
  27. Why unsigned integer is not available in PostgreSQL?
  28. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  29. PostgreSQL – dynamic value as table name [duplicate]
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment