Month: August 2017

This article is also written for describing about how to show current database accessed or being operated in PostgreSQL Database Server and it is related with the management function of PostgreSQL Database Server.

In order to show the current database accessed or being operated, it must be done by executing a specific command which is typed in the PostgreSQL Command Console.

To be able to log in to the PostgreSQL Command Console, there are several things which is needed to be confirmed.

1. Make sure that the PostgreSQL Database Server is properly installed.

2. Make sure that the service of PostreSQL Databse Server is running and active. Read the article titled ‘Check PostgreSQL Service Status’ in this link.

3. Make sure that PostgreSQL Command Console can be accessed and to be logged in for further operation which in the context of this article is for showing the current database accessed in PostgreSQL Command Console. In order to do that, the article titled ‘Check PostgreSQL Service Status’ in this link can be used as further reference. Below is the process of logging in to PostgreSQL Database Server :

This is one of the article relates on the management of PostgreSQL Database Server. The function which is the focus of the database management specifically in PostgreSQL Database Server is about how to show current user in PostgreSQL Database Server. The function for showing current user in PostgreSQL Database Server only works after logging in into PostgreSQL Command Console.

The main function in the management of PostgreSQL Database Server to show current user in the PostgreSQL Command Console after logging in is just to make sure that the SQL command executed further later on will be executed by the correct user.

Before logging in to the PostgreSQL Command Console, make sure that PostgreSQL Database Server is installed and the service is currently running. In order to check the service, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After checking the service and the service itself is currently running, just logged in to the PostgreSQL Database Server. In order to logged in to PostgreSQL Command Console, just read the article titled ‘PostgreSQL Database Access from Command Line in Linux’ in this link.

After logging in to PostgreSQL Comamnd Console, the SQL command executed in PostgreSQL Command Console itself where in this context is to show current user in PostgreSQL Database Server is shown below :

This is yet another article relates on PostgreSQL which is focusing to show how to check the PostgreSQL version via command console. Off course, the main point is the PostgreSQL Database Server must be installed and has already started. To check whether the service has already been installed or not just do the following step :

Check the service of PostgreSQL Database Server. To grasp on how to do it, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After everything has already been checked, mainly the PostgreSQL Database Server installation, the service itself also has already running properly, the process for checking the version can be performed.