Omitir para ir al contenido principal
Cerrar

Bienvenido a Dell

Mi cuenta
  • Hacer pedidos rápida y fácilmente
  • Ver pedidos y realizar seguimiento al estado del envío
  • Cree y acceda a una lista de sus productos
  • Administre sus sitios, productos y contactos de nivel de producto de Dell EMC con Administración de la empresa.
Iniciar sesión Crear una cuenta Clientes Premier Iniciar sesión en el programa para partners
Contáctenos

Número del artículo: 000131368

Dell Security Management Server Virtual Accessing the Postgres Database Using pgAdmin

Resumen: 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. ...

Es posible que este artículo se traduzca automáticamente. Si tiene comentarios sobre su calidad, háganoslo saber mediante el formulario en la parte inferior de esta página.

Contenido del artículo

Síntomas

Affected Products:

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

Causa

Not Applicable

Resolución

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.

Propiedades del artículo

Producto comprometido

Dell Encryption

Fecha de la última publicación

03 ago 2023

Versión

10

Tipo de artículo

Solution

Volver al principio