Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 76)

22 Brocade Network Advisor IP User Manual
53-1003153-01
PostgreSQL database
1
11. When the file is successfully created, the client changes the state of the data transfer to
“Uploading” and transmits the data.
The client transmits the data securely to the Brocade web server using the Apache HTTP
Components third-party library. The client communicates with the Brocade web server using an
authorization token.
12. When the transfer is complete, the client updates the Brocade web server database with the
transfer status (success or failure). The client also triggers an application event with the
following details: success or failure, source client IP address, and source user name.
PostgreSQL database
You can connect to the database using one of the following options:
• pgAdmin III
• ODBC client
• Command line interface
Connecting to the database using pgAdmin III
To access the PostgreSQL database, complete the following steps.
1. Choose one of the following options:
• On Windows systems, launch the dbadmin.bat script in the Install_Home\bin\ directory.
• On UNIX systems, launch the dbadmin script in the Install_Home\bin\ directory.
2. Selecting File > Add Server.
The New Server Registration dialog box displays.
3. Enter the DB_server_IP_address or “localhost” in the Host field.
4. Enter the port number (default is 5432) on which the PostgreSQL server is running in the Port
field.
5. Enter your username (default is dcmuser) in the Username field.
6. Enter your password (password) in the Password field.
7. Click OK on the New Server Registration dialog box.
The pgAdmin III application displays.
8. To browse data in the database, complete the following steps.
a. Expand the Tables tree in the Object browser pane.
b. Right-click a table in the list and select View Data > View All Rows.
9. To execute a freestyle SQL query in the database, complete the following steps.
a. Expand the Tables tree in the Object browser pane.
b. Right-click a table in the list and select Scripts > SELECT script.
The Query dialog box displays.
10. Select File > Exit to close the pgAdmin III application.