Client Tools

The availability of free PostgreSQL client tools allows database application developers to connect to the PostgreSQL cluster database. In addition, DBAs can use these tools with database resources in the cloud. ODBC or JDBC must be installed on the client machine to use these free software tools. The PostgreSQL installation package includes both server and client software. You can install only the PostgreSQL client on Linux from Red Hat 8 onwards. The advantage of using the psql client tool over PGAdmin or SQLJ is that it is an interactive command line tool useful for managing complex database tasks. As a DBA, you have to work with the application team and data analysts to configure client connectivity to PostgreSQL databases.