Connecting to EDB Postgres Advanced Server with edb-psql v16
edb-psql is a command-line client application that allows you to execute SQL commands and view the results. To open the edb-psql client, the client must be in your search path. The executable resides in the bin directory under your EDB Postgres Advanced Server installation.
Starting the client
Use the following command and options to start the edb-psql client:
edb-psql -d edb -U enterprisedb
Where:
-d specifies the database to which edb-psql connects.
-U specifies the identity of the database user to use for the session.
The edb-psql executable file is a symbolic link to a binary called psql, a modified version of the PostgreSQL community psql, with added support for EDB Postgres Advanced Server features. For more information about using the command-line client, see the PostgreSQL core documentation.
Managing authentication on a Debian or Ubuntu host
By default, the server is running with the peer or md5 permission on a Debian or Ubuntu host. You can change the authentication method by modifying the pg_hba.conf file, located under /etc/edb-as/16/main/.
For more information about modifying the pg_hba.conf file, see the PostgreSQL core documentation.