![]() The configuration file is read when you start the server, so you need to restart the PostgreSQL service for the changes to take effect. The file consists of lines in the form NAME = VALUE and makes sure your changes are valid. You can use any text editor of your choice to open and edit a configuration file for PostgreSQL. So, if your PostgreSQL version is 9.6, the location is /etc/postgresql/9.6/main/nf. The main configuration file for PostgreSQL is in /etc/postgresql/VERSION-NUMBER/main. If you want to manage PostgreSQL file locations, connections, and authentication, resource utilization, logging, etc., you need to edit the main configuration file. If you want PostgreSQL to shut down at system startup, run the following command: To enable the PostgreSQL service when booting the system, run the following command: Main PID: 1018 (code=exited, status=0/SUCCESS) Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (exited) since Sat 10:57:16 CDT 40min ago If PostgreSQL is running and running on your Linux VPS at the moment, the output will be similar to the following: To check the status of the PostgreSQL service, run the following command: To restart the service, you can run the following command: To stop the PostgreSQL service, you can use the following command: To run the PostgreSQL service, run the following command on your terminal: Now that the PostgreSQL installation is complete, it’s good to know how you can manage PostgreSQL service on your PostgreSQL VPS. Psql (PostgreSQL) 9.6.7 PostgreSQL management on Debian 9 It will show you the current version of PostgreSQL installed on your server: To check if the PosgreSQL server/client is installed, you can use the following command: It will install the PostgreSQL database server, client, and other necessary tools. This step is quite simple, just run the next command: The next step is to install the PostgreSQL database system on your Debian 9 VPS. This may take from a few seconds to a few minutes depending on the software to be updated. First, update the package index using the following command:Īfter updating the package index, you can update all your system software to the latest version using the following command: If you do, connect to your server via SSH and make sure that all your system software is up-to-date. Let’s get started.īefore starting the installation phase, make sure you have full access to your Debian 9 VPS, or at least you have a system user with sudo privileges. Installing PostgreSQL on Debian 9 is quite an easy task and should not take more than 10 minutes to complete the installation of PostgreSQL on Debian. It is a free and open-source system, whose main functions are to safely store data and return data as an answer to other application queries. PostgreSQL is an object-relational database management system written in C. We will show you how to install PostgreSQL on Debian 9.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |