{"id":29272,"date":"2025-10-06T22:00:24","date_gmt":"2025-10-06T18:30:24","guid":{"rendered":"https:\/\/www.arvancloud.ir\/help\/?p=29272"},"modified":"2025-10-07T14:52:21","modified_gmt":"2025-10-07T11:22:21","slug":"troubleshoot-database-too-many-connections","status":"publish","type":"post","link":"https:\/\/www.arvancloud.ir\/help\/fa\/troubleshoot-database-too-many-connections\/","title":{"rendered":"\u0631\u0641\u0639 \u062e\u0637\u0627\u06cc Too Many Connections \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c \u0627\u0628\u0631\u06cc \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f"},"content":{"rendered":"

\u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u062f\u06cc\u0631\u06cc\u062a\u200c\u0634\u062f\u0647\u200c\u06cc \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f \u0633\u0631\u0648\u06cc\u0633\u06cc \u0627\u0628\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0622\u0633\u0627\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u0633\u062a. \u0647\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0627\u0631\u0627\u06cc \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0645\u0634\u062e\u0635\u06cc \u062f\u0631 \u062a\u0639\u062f\u0627\u062f \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u06cc\u0627 \u0647\u0645\u0627\u0646 Conn\u200de\u200dction Limit \u0627\u0633\u062a. \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627 \u0627\u0632 \u0627\u06cc\u0646 \u062d\u062f \u0639\u0628\u0648\u0631 \u06a9\u0646\u062f\u060c \u062e\u0637\u0627\u06cc Too Many Connections \u0631\u062e \u0645\u06cc\u200c\u062f\u0647\u062f. \u0639\u0644\u062a \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0645\u0639\u0645\u0648\u0644\u0646 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0646\u0627\u062f\u0631\u0633\u062a \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u0633\u062a\u060c \u0645\u062b\u0644 \u0628\u0627\u0632 \u06af\u0630\u0627\u0634\u062a\u0646 \u0627\u062a\u0635\u0627\u0644 \u0648 \u0646\u0628\u0633\u062a\u0646 \u0622\u0646 \u067e\u0633 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647.<\/span><\/p>\n

\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0628\u0627 \u0645\u06cc\u0632\u0627\u0646 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0631 \u0641\u0644\u06cc\u0648\u0631\u060c \u0634\u06cc\u0648\u0647\u200c\u06cc \u0628\u0631\u0631\u0633\u06cc \u062a\u0639\u062f\u0627\u062f \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0641\u0639\u0627\u0644 \u0648 \u0631\u0641\u0639 \u062e\u0637\u0627\u06cc Too Many Connections \u0622\u0634\u0646\u0627 \u0645\u06cc\u200c\u0634\u0648\u06cc\u062f.<\/span><\/p>\n

Connection Limit \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u0628\u0631\u06cc \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f<\/span><\/h2>\n

Connection Limit \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u062a\u0639\u062f\u0627\u062f \u0645\u062c\u0627\u0632 \u0627\u062a\u0635\u0627\u0644 \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u0628\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0641\u0644\u06cc\u0648\u0631 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0646\u0627\u0628\u0639 \u0633\u062e\u062a\u200c\u0627\u0641\u0632\u0627\u0631\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0648 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u067e\u0646\u0644 \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. <\/span><\/p>\n

<\/span><\/p>\n

\n

\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u0634\u0627\u0645\u0644 \u0647\u0645\u0647\u200c\u06cc \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0628\u06a9\u200c\u0627\u0646\u062f \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646\u060c \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u060c \u06a9\u0644\u0627\u06cc\u0646\u062a\u200c\u0647\u0627\u06cc Command Line \u06cc\u0627 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n<\/blockquote>\n

\u067e\u0633 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0648\u0636\u0639\u06cc\u062a \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u062a\u0628 <\/span>\u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af<\/span><\/strong><\/span> \u0647\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n

<\/span><\/p>\n

    \n
  • \n

    Connections:<\/span><\/strong><\/span> \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u0641\u0639\u0627\u0644 \u0641\u0639\u0644\u06cc<\/span><\/p>\n<\/li>\n

  • \n

    Max Used Connections:<\/span><\/strong><\/span> \u0628\u06cc\u0634\u200c\u062a\u0631\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0628\u0627\u0632\u0647\u200c\u06cc \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647<\/span><\/p>\n<\/li>\n

  • \n

    Max Connections:<\/span><\/strong><\/span> \u062a\u0639\u062f\u0627\u062f \u0645\u062c\u0627\u0632 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0647\u0645\u200c\u0632\u0645\u0627\u0646<\/span><\/p>\n<\/li>\n<\/ul>\n

    \u062c\u062f\u0648\u0644 Connection Limit \u0628\u0647\u200c\u062a\u0641\u06a9\u06cc\u06a9 \u0641\u0644\u06cc\u0648\u0631<\/span><\/h3>\n

    \u062f\u0631 \u062c\u062f\u0648\u0644 \u0632\u06cc\u0631 \u0645\u0642\u0627\u062f\u06cc\u0631 Connection Limit \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u06cc\u0646\u200c\u0647\u0627\u06cc PostgreSQL \u0648 MySQL \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/span><\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    \u00a0<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n\u00a0<\/span><\/span><\/td>\n<\/tr>\n
    \u00a0 Flavor (CPU – RAM)<\/strong><\/span><\/td>\n\u00a0 PostgreSQL<\/strong><\/span><\/td>\n\u00a0 MySQL<\/strong><\/span><\/td>\n<\/tr>\n
    1-2<\/span><\/span><\/td>\n50<\/span><\/span><\/td>\n–<\/td>\n<\/tr>\n
    2-2<\/span><\/span><\/td>\n100<\/span><\/span><\/td>\n250<\/span><\/span><\/td>\n<\/tr>\n
    2-4<\/span><\/span><\/td>\n200<\/span><\/span><\/td>\n250<\/span><\/span><\/td>\n<\/tr>\n
    4-8<\/span><\/span><\/td>\n300<\/span><\/span><\/td>\n800<\/span><\/span><\/td>\n<\/tr>\n
    4-12<\/span><\/span><\/td>\n400<\/span><\/span><\/td>\n1100<\/span><\/span><\/td>\n<\/tr>\n
    6-16<\/span><\/span><\/td>\n400<\/span><\/span><\/td>\n1500<\/span><\/span><\/td>\n<\/tr>\n
    8-16<\/span><\/span><\/td>\n600<\/span><\/span><\/td>\n1500<\/span><\/span><\/td>\n<\/tr>\n
    6-24<\/span><\/span><\/td>\n800<\/span><\/span><\/td>\n2500<\/span><\/span><\/td>\n<\/tr>\n
    8-32<\/span><\/span><\/td>\n900<\/span><\/span><\/td>\n3200<\/span><\/span><\/td>\n<\/tr>\n
    12-48<\/span><\/span><\/td>\n1000<\/span><\/span><\/td>\n3500<\/span><\/span><\/td>\n<\/tr>\n
    16-64<\/span><\/span><\/td>\n1000<\/span><\/span><\/td>\n4100<\/span><\/span><\/td>\n<\/tr>\n
    20-96<\/span><\/span><\/td>\n1000<\/span><\/span><\/td>\n5100<\/span><\/span><\/td>\n<\/tr>\n
    24-128<\/span><\/span><\/td>\n1000<\/span><\/span><\/td>\n6100<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

    \u0627\u06af\u0631 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u0641\u0639\u0627\u0644 \u0628\u0647 \u0633\u0642\u0641 \u0638\u0631\u0641\u06cc\u062a \u0628\u0631\u0633\u062f:<\/span><\/p>\n

      \n
    • \n

      \u0627\u0645\u06a9\u0627\u0646 \u0627\u062a\u0635\u0627\u0644 \u062c\u062f\u06cc\u062f \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/span><\/p>\n<\/li>\n

    • \n

      \u0628\u0627\u06cc\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631\u0636\u0631\u0648\u0631\u06cc \u0628\u0633\u062a\u0647 \u0634\u0648\u0646\u062f.<\/span><\/p>\n<\/li>\n<\/ul>\n

      \u0646\u0645\u0648\u0646\u0647 \u062e\u0637\u0627\u0647\u0627\u06cc \u0631\u0627\u06cc\u062c \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 Connection Limit<\/span><\/h2>\n

      \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u0639\u0645\u0648\u0644\u0646 \u0628\u0627 \u062e\u0637\u0627\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f:<\/span><\/p>\n

        \n
      • \n

        ERROR 1040 (08004): Too many connections<\/span><\/p>\n<\/li>\n

      • \n

        PostgresException: 53300: remaining connection slots are reserved for roles with the SUPERUSER attribute<\/span><\/p>\n<\/li>\n

      • \n

        \u067e\u0631 \u0634\u062f\u0646 Connection Pool \u0648 \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0646\u0628\u0648\u062f\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/span><\/p>\n<\/li>\n<\/ul>\n

        \u0631\u0641\u0639 \u062e\u0637\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 Connection Limit<\/span><\/h2>\n

        \u0628\u0631\u0627\u06cc \u0631\u0641\u0639 \u0627\u06cc\u0646 \u062e\u0637\u0627\u0647\u0627 \u0648 \u0628\u0633\u062a\u0646 \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631\u0636\u0631\u0648\u0631\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631 \u0627\u0633\u0627\u0633 \u0627\u0646\u062c\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u062a\u0627\u0646 (MySQL\/PostgreSQL) \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n

        \n

        \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u062f\u0631 \u0686\u0646\u06cc\u0646 \u0634\u0631\u0627\u06cc\u0637\u06cc \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u0627\u062a\u0635\u0627\u0644 \u062c\u062f\u06cc\u062f \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f\u060c \u0641\u0642\u0637 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0642\u0628\u0644\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0628\u0647 \u0647\u06cc\u0686 \u0627\u062a\u0635\u0627\u0644 \u0641\u0639\u0627\u0644\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0646\u062f\u0627\u0631\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0645\u0634\u06a9\u0644 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0631\u0641\u0639 \u0628\u0647 \u062a\u06cc\u0645 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f \u0627\u0631\u062c\u0627\u0639 \u062f\u0647\u06cc\u062f.<\/span><\/p>\n<\/blockquote>\n

        MySQL<\/span><\/h3>\n

        \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0644\u06cc\u0633\u062a \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u0628\u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u06cc\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0647 \u0622\u0633\u062a\u0627\u0646\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u0645\u062c\u0627\u0632 \u0631\u0633\u06cc\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631. <\/span><\/p>\n

        \u0646\u0645\u0627\u06cc\u0634 \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627<\/span><\/strong><\/span>:<\/span><\/p>\n

        SHOW<\/span> PROCESSLIST<\/span>;<\/span><\/span><\/code><\/pre>\n
        \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0646\u0634\u0627\u0646\u200c\u062f\u0647\u0646\u062f\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u060c \u0648\u0636\u0639\u06cc\u062a \u0622\u0646\u200c\u0647\u0627\u060c \u06cc\u0648\u0632\u0631\u06cc \u06a9\u0647 \u0622\u0646 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0648 \u0622\u062f\u0631\u0633 \u0647\u0627\u0633\u062a\u06cc \u06a9\u0647 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0627\u0632 \u0631\u0648\u06cc \u0622\u0646 \u0628\u0631\u0642\u0631\u0627\u0631 \u0634\u062f\u0647\u060c \u0627\u0633\u062a.<\/span><\/p>\n
        <\/span><\/p>\n
        \u067e\u0633 \u0627\u0632 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u063a\u06cc\u0631\u0636\u0631\u0648\u0631\u06cc \u0628\u0631\u0627\u06cc \u0628\u0633\u062a\u0646 \u0622\u0646 \u062f\u0631 \u0627\u0646\u062c\u06cc\u0646 MySQL \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n
        \u0628\u0633\u062a\u0646 \u06cc\u06a9 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u062e\u0627\u0635<\/span><\/strong><\/span>:<\/span><\/p>\n
        KILL<\/span> <<\/span>thread_id><\/span>;<\/span><\/span><\/code><\/pre>\n
        \u0628\u0647 \u062c\u0627\u06cc <thread_id> \u0645\u0642\u062f\u0627\u0631 \u0633\u062a\u0648\u0646 Id \u0627\u0632 \u062e\u0631\u0648\u062c\u06cc \u062f\u0633\u062a\u0648\u0631 \u0642\u0628\u0644 \u0631\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/span><\/p>\n
        \n
        \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0628\u0633\u062a\u0646 \u0647\u0645\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627\u0639\u062b \u0627\u062e\u062a\u0644\u0627\u0644 \u0645\u0648\u0642\u062a \u062f\u0631 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u06cc\u0627 \u0633\u0631\u0648\u06cc\u0633 \u0634\u0648\u062f.<\/span><\/p>\n<\/blockquote>\n
        PostgreSQL<\/span><\/h3>\n
        \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u062f\u0631 \u0627\u0646\u062c\u06cc\u0646 PostgreSQL \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
        SELECT<\/span> pid,<\/span> usename,<\/span> datname,<\/span> client_addr,<\/span> state<\/span>\r\nFROM<\/span> pg_stat_activity;<\/span><\/span><\/code><\/pre>\n
        \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u06a9\u0647 \u0646\u0634\u0627\u0646\u200c\u062f\u0647\u0646\u062f\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u060c \u0648\u0636\u0639\u06cc\u062a \u0622\u0646\u200c\u0647\u0627\u060c \u0622\u062f\u0631\u0633 \u06a9\u0644\u0627\u06cc\u0646\u062a\u06cc \u06a9\u0647 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0648 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631 \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0622\u0646 \u0627\u0633\u062a.<\/span><\/p>\n
        <\/span><\/p>\n
        \u06cc\u0627 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0631\u0627\u06cc \u062f\u06cc\u062f\u0646 \u0648\u0636\u0639\u06cc\u062a \u062e\u0644\u0627\u0635\u0647\u200c\u0627\u06cc \u0627\u0632 \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
        SELECT<\/span> datname,<\/span> count<\/span>(<\/span>*<\/span>)\r\n<\/span><\/span>FROM<\/span> pg_stat_activity\r\n<\/span>GROUP<\/span> BY<\/span> datname;<\/span><\/span><\/code><\/pre>\n
        \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u06a9\u0648\u0626\u0631\u06cc \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a \u0648 \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0644\u0627\u0635\u0647\u060c \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0628\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/span><\/p>\n
        <\/span><\/p>\n
        \u0628\u0631\u0627\u06cc \u0628\u0633\u062a\u0646 \u06cc\u06a9 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u062e\u0627\u0635 \u062f\u0631 \u0627\u0646\u062c\u06cc\u0646 PostgreSQL \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
        SELECT<\/span> pg_terminate_backend(<\/span><<\/span>pid><\/span>)<\/span>;<\/span><\/span><\/code><\/pre>\n
        \u0628\u0647\u200c\u062c\u0627\u06cc <\/span><pid><\/span> \u0645\u0642\u062f\u0627\u0631 \u0633\u062a\u0648\u0646 pid \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u06a9\u0647 \u0642\u0635\u062f \u0628\u0633\u062a\u0646 \u0622\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f. <\/span><\/p>\n
        \u062e\u0631\u0648\u062c\u06cc \u062f\u0633\u062a\u0648\u0631 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/span><\/p>\n
        <\/span><\/p>\n
        \u0647\u0645\u200c\u0686\u0646\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0628\u0633\u062a\u0646 \u0647\u0645\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 (\u063a\u06cc\u0631 \u0627\u0632 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0641\u0639\u0644\u06cc) \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
        SELECT<\/span> pg_terminate_backend(<\/span>pid)<\/span><\/span>\r\nFROM<\/span> pg_stat_activity<\/span>\r\nWHERE<\/span> datname =<\/span> '<DB_NAME>'<\/span> AND<\/span> pid <><\/span> pg_backend_pid()<\/span>;<\/span><\/span><\/code><\/pre>\n
        \n
        \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0628\u0633\u062a\u0646 \u0647\u0645\u0647\u200c\u06cc \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627\u0639\u062b \u0642\u0637\u0639 \u0634\u062f\u0646 \u0645\u0648\u0642\u062a \u0633\u0631\u0648\u06cc\u0633 \u0634\u0648\u062f.<\/span><\/p>\n<\/blockquote>\n
        \u0631\u0627\u0647\u06a9\u0627\u0631 \u067e\u0627\u06cc\u062f\u0627\u0631 \u062e\u0637\u0627\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 Connection<\/span><\/h3>\n
        \u0627\u06af\u0631 \u0645\u0634\u06a9\u0644 \u0634\u0645\u0627 \u0628\u0627 \u0628\u0633\u062a\u0646 \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u0648\u0642\u062a \u062d\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648\u0644\u06cc \u0628\u0647 \u0634\u06a9\u0644 \u067e\u0627\u06cc\u062f\u0627\u0631 \u0647\u0645\u200c\u0686\u0646\u0627\u0646 \u0628\u0647 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0628\u06cc\u0634\u200c\u062a\u0631\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u0628\u0627\u06cc\u062f \u0627\u0632 \u0641\u0644\u06cc\u0648\u0631\u200c\u06cc \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0686\u0631\u0627\u06a9\u0647 \u0627\u0641\u0632\u0627\u06cc\u0634 Connection Limit \u0628\u0647\u200c\u0634\u06a9\u0644 \u062f\u0633\u062a\u06cc \u06cc\u0627 \u0645\u0648\u0642\u062a \u0627\u0645\u06a9\u0627\u0646\u200c\u067e\u0630\u06cc\u0631 \u0646\u06cc\u0633\u062a.<\/span><\/p>\n
        \u0634\u0645\u0627 \u0647\u0645\u0648\u0627\u0631\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647\u200c\u06a9\u0645\u06a9 \u0642\u0627\u0628\u0644\u06cc\u062a \u00ab\u062a\u063a\u06cc\u06cc\u0631 \u0627\u0646\u062f\u0627\u0632\u0647\u00bb \u0641\u0644\u06cc\u0648\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631\u062a\u0627\u0646 \u0631\u0627 \u0628\u062f\u0648\u0646 \u0627\u062e\u062a\u0644\u0627\u0644 \u06cc\u0627 \u0642\u0637\u0639\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f \u0648 \u0628\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0638\u0631\u0641\u06cc\u062a\u060c \u0628\u0647 \u0645\u0646\u0627\u0628\u0639 \u0648 \u06a9\u0627\u0646\u06a9\u0634\u0646 \u0628\u06cc\u0634\u200c\u062a\u0631\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
        \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u062f\u06cc\u0631\u06cc\u062a\u200c\u0634\u062f\u0647\u200c\u06cc \u0622\u0631\u0648\u0627\u0646\u200c\u06a9\u0644\u0627\u062f \u0633\u0631\u0648\u06cc\u0633\u06cc \u0627\u0628\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0622\u0633\u0627\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u0633\u062a. \u0647\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0627\u0631\u0627\u06cc \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0645\u0634\u062e\u0635\u06cc \u062f\u0631 \u062a\u0639\u062f\u0627\u062f \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u06cc\u0627 \u0647\u0645\u0627\u0646 Conn\u200de\u200dction Limit \u0627\u0633\u062a. \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627 \u0627\u0632 \u0627\u06cc\u0646 \u062d\u062f \u0639\u0628\u0648\u0631 \u06a9\u0646\u062f\u060c \u062e\u0637\u0627\u06cc Too Many Connections \u0631\u062e \u0645\u06cc\u200c\u062f\u0647\u062f. \u0639\u0644\u062a \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0645\u0639\u0645\u0648\u0644\u0646 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0646\u0627\u062f\u0631\u0633\u062a \u06a9\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627\u0633\u062a\u060c \u0645\u062b\u0644 \u0628\u0627\u0632 \u06af\u0630\u0627\u0634\u062a\u0646 \u0627\u062a\u0635\u0627\u0644 \u0648 \u0646\u0628\u0633\u062a\u0646 […]<\/p>\n","protected":false},"author":79,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"r1_post_views_count":"327","feedback_yes":"0","feedback_no":"","ads_id_sidebar":"","ads_id_content":"","footnotes":""},"categories":[199,203],"tags":[],"class_list":["post-29272","post","type-post","status-publish","format-standard","hentry","category-databases","category-database-management"],"lang":"fa","translations":{"fa":29272},"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/posts\/29272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/comments?post=29272"}],"version-history":[{"count":22,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/posts\/29272\/revisions"}],"predecessor-version":[{"id":29294,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/posts\/29272\/revisions\/29294"}],"wp:attachment":[{"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/media?parent=29272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/categories?post=29272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.arvancloud.ir\/help\/wp-json\/wp\/v2\/tags?post=29272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}