Přeskočit na hlavní obsah
  • Vkládejte objednávky snadno a rychle
  • Zobrazit objednávky a sledovat stav expedice
  • Vytvořte a přistupujte k seznamu svých produktů

Dell Security Management Server Virtual Accessing the Postgres Database Using pgAdmin

Shrnutí: 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. ...

Tento článek se vztahuje na Tento článek se nevztahuje na Tento článek není vázán na žádný konkrétní produkt. V tomto článku nejsou uvedeny všechny verze produktu.

Pokyny

Affected Products:

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

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

    Update Database Password

    Enable Database Remote Access

pgAdmin 3

  1. Now that access is configured, launch pgAdmin. From the drop-down menu, select File > Add Server….
    Click Add Server
  2. Populate the necessary fields in the New Server Registration screen:
    • Name: The friendly name for the server you would like appears 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
  3. 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
  4. Select ddp_8_2_0 and the red X should disappear, and a SQL icon should become available:
    SQL icon
  5. Click that icon to bring up a query window:
    Open the Graphical Query Builder

pgAdmin 4

  1. Now that access is configured, open pgAdmin. From the drop-down menus select Object > Create> Server:
    Click Server
  2. Give the Server a name (this is how it appears in your pgAdmin browser):
    Update Server Name
  3. 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
  4. Open your server and go to the ddp database:
    Open ddp
  5. Right-click the database and select Query Tool…:
    Click Query Tool...
    This brings up the query window:
    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.

Dotčené produkty

Dell Encryption
Vlastnosti článku
Číslo článku: 000131368
Typ článku: How To
Poslední úprava: 14 Aug 2024
Verze:  12
Najděte odpovědi na své otázky od ostatních uživatelů společnosti Dell
Služby podpory
Zkontrolujte, zda se na vaše zařízení vztahují služby podpory.