: sudo -u postgres psql -c "SELECT version() " To verify the installation we’ll connect to the PostgreSQL database server using the psql utility and print the server version When the installation is completed, the PostgreSQL service will start automatically. Install the PostgreSQL server and PostgreSQL contrib package which provides additional features for the PostgreSQL database: sudo apt install postgresql postgresql-contrib To install PostgreSQL on your Debian server complete the following steps:īegin by updating the local package index: sudo apt update Prerequisites #īefore proceeding with this tutorial, make sure the user you are logged in as has sudo privilegesĪt the time of writing this article, the latest version of PostgreSQL available from the Debian repositories is PostgreSQL version 9.6. In this tutorial, we will show you how to install PostgreSQL on Debian 9 and explore the fundamentals of basic database administration. PostgreSQL has many advanced features such as online backups, point in time recovery, nested transactions, SQL and JSON querying, multi-version concurrency control (MVCC), asynchronous replication and more. PostgreSQL, often known simply as Postgres, is an open-source general-purpose object-relational database management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |