In PostgreSQL there are number of GUI applications which was used to manage the PostgreSQL database.

We can connect multiple client at the same time to the server to process the request of the client.

After authentication is successful then it will response to the client with his request.

After requesting client to the database server, it will check the request from client after checking request it will authenticate with the database server.

Client will first request to the database server through the client utility.

This library is similar with OCI which was used in ORACLE.

Libpq is the library which was used with each client applications through postmaster process in PostgreSQL.

PostgreSQL client is used libpq libraries to communicate and connect to the database server.

The client is defined as command execution environment like a psql or we have used special driver for the same.

PostgreSQL client server architecture is divided basically into two parts i.e.

Client is used to connect to the database server.īelow figure shows that client architecture in PostgreSQL.

Given below shows how the PostgreSQL Client works: This is optional parameter which was used with psql utility in PostgreSQL.

Port no: This is defined as port number is used while connecting with database server through port number.

This is the optional parameter which is used with psql utility in PostgreSQL. If we connect to the local host there is no need to define host name with psql utility.

Host name: If we want to connect from another host then we need to use this parameter in PostgreSQL.

To connect to the database we need to provide connect grant on database to the specified user.

Database name: This is defined as database name to connect with specified database.

We need to provide password with psql utility to connect the database server. Wrong password is not authenticated with the database.

Password: This is defined as password parameter to authenticate client user with password.

Username is used to authenticate with database server.

Username: This is important parameter which was used to connect the database server.

Psql is useful and important utility of client which was used to connect to the database server.

We can use this utility with the username, password and hostname. Psql: This is client utility which was used to connect the database server.

# psql –U username –W user_password –d database_name –p port_noīelow are the parameter description syntax of PostgreSQL client: # psql –U username –W user_password –d database_name –h hostname # psql –U username –W user_password –d database_name Hadoop, Data Science, Statistics & others

Postgresql admin tutorial