跳至主要內容
登出

歡迎來到 Dell

我的帳戶
  • 簡單快速地下訂單
  • 檢視訂單及追蹤商品運送狀態
  • 建立並存取您的產品清單
  • 使用「公司管理」來管理您的 Dell EMC 網站、產品和產品層級連絡人。
登入 建立帳戶 Premier 登入 合作夥伴計畫登入
與我們連絡

您的 Dell.com 購物車

文章編號: 000131368

Dell Security Management Server Virtual Accessing the Postgres Database Using pgAdmin

摘要: In order to change the database of a Dell Security Management Server Virtual (formerly Dell Data Protection | Virtual Edition), you have to access postgres. This can be done in command line, but third-party tools such as pgAdmin can provide a better experience. ...

本文可能採用自動翻譯。如果您對翻譯品質有任何寶貴意見，請使用此頁面底部的表單告訴我們，謝謝。

文章內容

症狀

Affected Products:

  • Dell Security Management Server Virtual
  • Dell Data Protection | Virtual Edition

原因

Not Applicable

解析度

To access the database:

  1. Set a password.
  2. Allow remote access.
Note: These options can be found within the advanced configuration menu of the Dell Security Management Server Virtual console.

Select Database Password
Figure 1: (English Only) Select Database Password

Update Database Password
Figure 2: (English Only) Update Database Password

Enable Database Remote Access
Figure 3: (English Only) Enable Database Remote Access

  1. Now that access is configured, launch pgAdmin. From the drop-down menu, select File > Add Server….

Click Add Server
Figure 4: (English Only) Click Add Server

  1. Populate the necessary fields in the New Server Registration screen:
    • Name: The friendly name for the server you would like to appear in the pgAdmin console.
    • Host: The hostname or IP address of the Dell Data Protection | Virtual Edition server
    • Port: The port number for accessing the database (It is 5432 by default and should be pre-populated.)
    • Username: ddp_admin
    • Password: The password that was entered in the database password field of the Dell Data Protection | Virtual Edition server console.

Populate the fields in the New server Registration screen
Figure 5: (English Only) Populate the fields in the new server Registration screen

  1. Once that information is entered, press OK to complete the addition of the server to the pgAdmin console. 

Expand Servers to verify your server is listed
Figure 6: (English Only) Expand Servers to verify that your server is listed

  1. Select ddp_8_2_0 and the red X should disappear, and a SQL icon should become available:

SQL icon
Figure 7: (English Only) SQL icon

  1. Click that icon to bring up a query window:

Open the Graphical Query Builder
Figure 8: (English Only) Open the Graphical Query Builder

  1. Now that access is configured, open pgAdmin. From the drop-down menus select Object > Create> Server:

Click Server
Figure 9: (English Only) Click Server

  1. Give the Server a name (this is how it appears in your pgAdmin browser):

Update Server Name
Figure 10: (English Only) Update Server Name

  1. Click the connection tab. Enter the following fields:
    • Host: The hostname or IP address of the Dell Data Protection | Virtual Edition server
    • Port: The port number for accessing the database (It is 5432 by default and should be pre-populated.)
    • Username: ddp_admin
    • Password: The password that was entered in the database password field of the Dell Data Protection | Virtual Edition server console.

Update the Create - Server fields
Figure 11: (English Only) Update the Create - Server fields

  1. Open your server and go to the ddp database:

Open ddp
Figure 12: (English Only) Open ddp

  1. Right Click on the database and select Query Tool…:

Click Query Tool...
Figure 13: (English Only) Click Query Tool…

This brings up the query window:

Query Window
Figure 14: (English Only) Query Window

To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.

文章屬性

受影響的產品

Dell Encryption

上次發佈日期

03 8月 2023

版本

10

文章類型

Solution

返回頁首