Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 73)

Brocade Network Advisor SAN User Manual 21
53-1003154-01
PostgreSQL database
1
• Last transfer timestamp must be greater than 24 hours to avoid frequent data uploads.
• Data must be available for transfer. Data availability is determined by the difference
between the last data transfer and the current data.
8. The client requests a data transfer.
If data is available, the server nominates the client to transfer data. Once nominated, any
further upload requests are denied.
NOTE
If the nominated client’s session is ended or stuck, the session is invalidated and the state is
cleared.
9. The nominated client requests the server to prepare the data.
10. The server compiles the usage data text file into a .zip file using the following naming
convention: UUID_usagedata_file_creataion_timestamp, where UUID is the unique
identification of the server based on the MAC address.
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.