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

22 Brocade Network Advisor SAN User Manual
53-1003154-01
PostgreSQL database
1
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.
Connecting to the database using the ODBC client (Windows systems)
The Open Database Connectivity (ODBC) driver enables you to configure the data source name
(DSN) for the database.
To install the ODBC driver and create a new data source, complete the following steps.
1. Double-click edb_psqlodbc.exe located on the DVD
(DVD_Drive/Management_Application/odbc/Windows).
2. Install the file to the usual location for your system’s application files (for example, C:\Program
Files\Management_Application ODBC Driver) on the Select Install Folder screen and click
Next.
NOTE
If you select an invalid location, the ODBC driver is installed in a different location than where
the ODBC executable drivers are located.
3. On the Ready to Install screen click Next.
4. Click Finish to complete the installation.
5. Choose one of the following opitions:
• (32-bit OS) Select Start > Settings > Control Panel > Administrative Tools > Data Sources
(ODBC).
• (62-bit OS) (Windows only) Select Start > Run, type
%windir%\SysWOW64\odbcad32.exe
and press Enter.
The ODBC Data Source Administrator dialog box displays.
6. Click the System DSN tab.
7. Click Add.
The Create a New Data Source dialog box displays.
8. Select PostgreSQL Unicode.