{"id":4809,"date":"2019-09-13T20:22:18","date_gmt":"2019-09-14T00:22:18","guid":{"rendered":"https:\/\/microdevsys.com\/wp\/?p=4809"},"modified":"2019-09-15T19:43:27","modified_gmt":"2019-09-15T23:43:27","slug":"fatal-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections","status":"publish","type":"post","link":"https:\/\/microdevsys.com\/wp\/fatal-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections\/","title":{"rendered":"FATAL: remaining connection slots are reserved for non-replication superuser connections"},"content":{"rendered":"

\n\tGetting this?\n<\/p>\n

\n\tFATAL:  remaining connection slots are reserved for non-replication superuser connections<\/span>\n<\/p>\n

\n\tFix that by updating the Patroni configuration like like so:\n<\/p>\n

\n\t[root@psql01 log]# patronictl -c \/etc\/patroni.yml edit-config postgres
\n\t—
\n\t+++
\n\t@@ -1,9 +1,10 @@
\n\t loop_wait: 10
\n\t maximum_lag_on_failover: 1048576
\n\t postgresql:
\n\t+  parameters:
\n\t–  max_connections: 256
\n\t+    max_connections: 256
\n\t–  max_replication_slots: 64
\n\t+    max_replication_slots: 64
\n\t–  max_wal_senders: 32
\n\t+    max_wal_senders: 32
\n\t   use_pg_rewind: true
\n\t retry_timeout: 10
\n\t ttl: 30<\/span>\n<\/p>\n

\n\tApply these changes? [y\/N]: y
\n\tConfiguration changed
\n\t[root@psql01 log]#
\n\t[root@psql01 log]#
\n\t[root@psql01 log]# patronictl -c \/etc\/patroni.yml restart postgres
\n\t+———-+————-+—————+——–+———+———–+
\n\t| Cluster  |    Member   |      Host     |  Role  |  State  | Lag in MB |
\n\t+———-+————-+—————+——–+———+———–+
\n\t| postgres | postgresql0 | 192.168.0.108 | Leader | running |       0.0 |
\n\t| postgres | postgresql1 | 192.168.0.124 |        | running |       0.0 |
\n\t| postgres | postgresql2 | 192.168.0.118 |        | running |       0.0 |
\n\t+———-+————-+—————+——–+———+———–+
\n\tAre you sure you want to restart members postgresql0, postgresql1, postgresql2? [y\/N]: y
\n\tRestart if the PostgreSQL version is less than provided (e.g. 9.5.2)  []:
\n\tWhen should the restart take place (e.g. 2015-10-01T14:30)  [now]:
\n\tSuccess: restart on member postgresql0
\n\tSuccess: restart on member postgresql1
\n\tSuccess: restart on member postgresql2
\n\t[root@psql01 log]# sudo su – postgres
\n\tLast login: Sat Sep 14 09:15:34 EDT 2019 on pts\/0
\n\t-bash-4.2$ psql -h psql-c01 -p 5432 -W
\n\tPassword:
\n\tpsql (10.5)
\n\tType "help" for help.<\/span>\n<\/p>\n

\n\tpostgres=#
\n\tpostgres=#
\n\tpostgres=#
\n\tpostgres=# show max_connections; show  max_replication_slots;
\n\t max_connections
\n\t—————–
\n\t 256
\n\t(1 row)<\/span>\n<\/p>\n

\n\t max_replication_slots
\n\t———————–
\n\t 64
\n\t(1 row)<\/span>\n<\/p>\n

\n\tpostgres=#<\/span>
\n\t \n<\/p>\n

\n\tKeep in mind that cluster name above is your scope from the config file:\n<\/p>\n

\n\t[root@psql01 patroni]# cat \/etc\/patroni.yml
\n\tscope: postgres<\/span>\n<\/p>\n

\n\tAlternately, update the PostgresSQL settings with the above, if you're not running Patroni.  Verify status:\n<\/p>\n

\n\t[<\/font><\/u>root@psql01 ~]# patronictl -c \/etc\/patroni.yml list
\n\t+———-+————-+—————+——–+———+———–+
\n\t| Cluster  |    Member   |      Host     |  Role  |  State  | Lag in MB |
\n\t+———-+————-+—————+——–+———+———–+
\n\t| postgres | postgresql0 | 192.168.0.108 |        | running |       0.0 |
\n\t| postgres | postgresql1 | 192.168.0.124 | Leader | running |       0.0 |
\n\t| postgres | postgresql2 | 192.168.0.118 |        | running |       0.0 |
\n\t+———-+————-+—————+——–+———+———–+
\n\t[root@psql01 ~]#<\/font><\/span>
\n\t \n<\/p>\n

\n\tCheers,
\n\tTK\n<\/p>\n

\n\tREF:<\/strong> My post on the project page: https:\/\/github.com\/zalando\/patroni\/issues\/1177<\/a><\/p>\n\n

\n\n\t\t\n
    \n\t\t\t <\/ul>\n <\/div> \n","protected":false},"excerpt":{"rendered":"

    Getting this? FATAL:  remaining connection slots are reserved for non-replication superuser connections Fix that by updating the Patroni configuration like like so: [root@psql01 log]# patronictl -c \/etc\/patroni.yml edit-config postgres — +++ @@ -1,9 +1,10 @@  loop_wait: 10  maximum_lag_on_failover: 1048576  postgresql: +  parameters: –  max_connections: 256 +    max_connections: 256 –  max_replication_slots: 64 +    max_replication_slots: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4809","post","type-post","status-publish","format-standard","hentry","category-unix-linux-admin-stuff"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/posts\/4809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/comments?post=4809"}],"version-history":[{"count":5,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/posts\/4809\/revisions"}],"predecessor-version":[{"id":4814,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/posts\/4809\/revisions\/4814"}],"wp:attachment":[{"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/media?parent=4809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/categories?post=4809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microdevsys.com\/wp\/wp-json\/wp\/v2\/tags?post=4809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}