Shulou(Shulou.com)06/01 Report--

PostgreSQL is a very powerful, open source client / server relational database management. PostgreSQL supports most SQL standards and provides many other modern features, such as complex queries, foreign keys, triggers, views, transaction integrity, multi-version concurrency control, and so on. Open the PostgreSQL official website https://www.postgresql.org/ and click Download on the menu bar. You can see that it contains installation packages for many platforms, including Linux, Windows, Mac OS and so on.

For Linux, we can see that various platforms such as Ubuntu and Red Hat are supported. Click the specific platform link to view the installation method:

Click on the file browser in the image above and we can also download the latest source code for PostgreSQL.

This chapter takes Ubuntu as an example.

Ubuntu install PostgreSQLUbuntu you can install PostgreSQL using apt-get:

After sudo apt-get update sudo apt-get install postgresql postgresql-client is installed, the system creates a database superuser postgres with an empty password.

# sudo-I-u postgres uses the following command to enter postgres at this time, and outputs the following information, indicating that the installation is successful:

~ $psql psql (9.5.17) Type "help" for help. Postgres=# exits the PostgreSQL prompt by entering the following command:

\ qPostgreSQL is started by default after installation, but the service can also be started manually in the following ways.

Sudo / etc/init.d/postgresql start # Open sudo / etc/init.d/postgresql stop # close sudo / etc/init.d/postgresql restart # restart this article on "how to install postgresql on a Linux system" ends here, thank you for reading! I believe that everyone has a certain understanding of the knowledge of "how to install postgresql in Linux system". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.