設定 Azure Database for PostgreSQL-透過 Azure 入口網站的單一伺服器伺服器參數Configure server parameters in Azure Database for PostgreSQL - Single Server via the Azure portal

您可以透過 Azure 入口網站列出、顯示、更新適用於 PostgreSQL 的 Azure 資料庫伺服器的設定參數。You can list, show, and update configuration parameters for an Azure Database for PostgreSQL server through the Azure portal.

先決條件Prerequisites

為了逐步執行本作法指南,您需要︰To step through this how-to guide you need:

檢視和編輯參數Viewing and editing parameters

  1. 開啟 Azure 入口網站Open the Azure portal.

  2. 選取適用於 PostgreSQL 的 Azure 資料庫伺服器。Select your Azure Database for PostgreSQL server.

  3. 在 [設定] 區段下,選取 [伺服器參數] 。Under the SETTINGS section, select Server parameters. 頁面會顯示一份參數、值和說明的清單。The page shows a list of parameters, their values, and descriptions. 參數的概觀頁面Overview Page for Parameters

  4. 選取下拉按鈕可查看列舉型別參數 (如 client_min_messages) 的可能值。Select the drop down button to see the possible values for enumerated-type parameters like client_min_messages. 列舉下拉按鈕Enumerate drop down

  5. 選取或將滑鼠停留在 [i] (資訊) 按鈕上可查看數值參數 (如 cpu_index_tuple_cost) 的可能值範圍。Select or hover over the i (information) button to see the range of possible values for numeric parameters like cpu_index_tuple_cost. 資訊按鈕information button

  6. 如有需要,使用 [搜尋方塊] 縮小至特定參數。If needed, use the search box to narrow down to a specific parameter. 搜尋作業是依據參數的名稱和說明。The search is on the name and description of the parameters. 搜尋結果Search results

  7. 變更您想要調整的參數值。Change the parameter values you would like to adjust. 您在工作階段中所做的所有變更都會以紫色顯示。All changes you make in a session are highlighted in purple. 變更值之後,可以選取 [儲存] 。Once you have changed the values, you can select Save. 或者,也可以 [捨棄] 您的變更。Or you can Discard your changes. 儲存或捨棄變更Save or Discard changes

  8. 儲存新的參數值後,隨時可以選取 [全部重設為預設值] 回復為所有參數的預設值。If you have saved new values for the parameters, you can always revert everything back to the default values by selecting Reset all to default. 全部重設為預設值Reset all to default

後續步驟Next steps

了解:Learn about: