![]() The directory /usr/lib/postgresql/10/bin also contains many utilities such as createdb (create database), dropdb (drop database), createuser (create PostgreSQL user), dropuser (drop PostgreSQL user), among others, with symlinks defined in /usr/bin. The actual program and utilities are located at /usr/lib/postgresql/10/bin and linked via pg_wrapper. Psql is a symlink located in /usr/bin (a PATH entry). The PostgreSQL installation provides a command-line client program called psql, which can be used to login to the server. c config_file=/etc/postgresql/10/main/nf usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main You could display the PostgreSQL server process via: There is also a symlink called postmaster in the same directory. The PostgreSQL server program is called postgres (in directory /usr/lib/postgresql/10/bin). ![]() The PostgreSQL server accepts connection by client program over the TCP/IP network. $ sudo systemctl status postgresql // Show th status $ sudo service postgresql reload // Reload the configuration without stopping the service // OR $ sudo service postgresql restart // Stop and restart the service $ sudo service postgresql start // Start the service $ sudo service postgresql stop // Stop the service The postgresql service is started automatically upon startup. ![]() In Ubuntu, the server is run as a service called postgresql (configured in /etc/init.d/postgresql). PostgreSQL runs as a client-server system. Reference: PostgreSQL Documentation - Tutorial.
0 Comments
Leave a Reply. |