6.4 Connecting to Advanced Server

Table of Contents Previous Next


6 Configuring Advanced Server : 6.4 Connecting to Advanced Server

After creating a startup database, starting the server, and modifying the pg_hba.conf file (if necessary), you can connect to the server with the psql client (see Figure 6.4). psql is an Advanced Server client that allows you to query the server, and review the query results. Please note that additional configuration steps are required before connecting to an Oracle or MySQL database.
If you have used a package manager to install Advanced Server and the psql client, use su - to assume the database superuser identity (enterprisedb):
C:\Users\susan\AppData\Local\Temp\VMwareDnD\dbdf6ca8\Screen shot 2015-02-03 at 9.54.42 AM.png
Please note that the psql client must be in your search path.
If you have performed an installation with the interactive installer, you can easily access the psql client through the Applications or Start menu. Navigate through the Postgres Plus Advanced Server 9.4 menu to the Run SQL Command Line menu, and select EDB-PSQL. When the Terminal window opens, provide connection information for your session.

6 Configuring Advanced Server : 6.4 Connecting to Advanced Server

Table of Contents Previous Next