1 PostgreSQL database

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.

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.

18

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 70
Image 70
Brocade Communications Systems IP250 user manual PostgreSQL database, Selecting File Add Server