So, to access the PostgreSQL console, you can run this command one at a time sudo -u postgres psql PostgreSQL on Debian 11 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. In addition to this, PostgreSQL works on a per-process basis and a failure in one process will not affect the rest and the system will continue to run.
High concurrency is present in PostgreSQL because it allows that while one process writes to a table, others can access the same table without blocking. It is one of the most popular database servers out there and many large projects prefer it over MariaDB. PostgreSQL is an open-source object-relational database server that runs on Client-Server architecture.
0 kommentar(er)
