Brocade Network Advisor IP User Manual 21
53-1003056-01
PostgreSQL database 1
Testing the connection on Linux systems
To test the connection, complete the following steps.
1. Download and install Open Office.
2. Select File > New > Database.
The Database Wizard displays.
3. On the Select database screen, complete the following steps.
a. Select the Connect to an existing database option.
b. Select ODBC from the list.
c. Click Next.
4. On the Set up ODBC connection screen, complete the following steps.
a. Click Browse.
The datasource saved in the odbc.ini file is populated in the Datasource dialog box.
b. Select the datasource and click OK on the Datasource dialog box.
c. Click Next.
5. On the Set up user authentication screen, complete the following steps.
a. Enter the database user name in the User name field.
b. Select the Password required check box.
c. Click Test Connection to test the connection.
The Authentication Password dialog box displays.
d. Enter the database password in the Password field and click OK.
e. Click OK on the Connection Test dialog box.
If an error message (file not found while testing the connection) displays, copy the lib files
from the <postgresSQL path>/lib/* directory to the /usr/lib/ directory.
f. Click Next.
6. On the Save and proceed screen, click Finish.
Executing SQL queries from the CLI
To execute SQL queries from the command line interface (CLI) , complete the following steps.
1. Choose one of the following options:
On Windows systems, launch the dbsql.bat script in the Install_Home\bin\ directory.
On UNIX systems, launch the dbsql script in the Install_Home\bin\ directory.
2. Execute your query from the command window.
3. Close the command window.