Accessing the PostgreSQL consoleĭuring the installation of PostgreSQL, a new user named postgres is created who is authorized to run psql which is the PostgreSQL console. This way, you can manage the PostgreSQL service and thus manage the application’s execution. Or revert the changes sudo systemctl enable postgresql If you don’t want this to be the case you have to run sudo systemctl disable postgresql sudo systemctl restart postgresqlīy default, PostgreSQL is configured to start with the system. Then, you can start it as follows sudo systemctl start postgresqlīut sometimes you may want to stop the service, so run sudo systemctl stop postgresqlĪnd when you make a change in the PostgreSQL configuration you have to restart it so that the changes can be applied correctly. If you want to know the status of the service, run sudo systemctl status postgresql PostgreSQL status When the program is installed correctly, we can manage its service from the systemctl command. With these two packages installed, we now have postgreSQL installed on the system. This will install the PostgreSQL server but we can also install a client that will allow us to make remote connections to other instances. In this sense, open a terminal or SSH session and once it has loaded, update the system sudo apt updateĪfter this, you can install PostgreSQL version 13 as follows sudo apt install postgresql-13 PostgreSQL is present in the official Debian 11 repositories so the installation process becomes easy to execute.
Also, other management tools such as PgAdmin will help us to get the most out of an instance.
In addition to the many new features that the application has, we can also say that the Linux support is top-notch.
0 kommentar(er)
