Install PostgreSQLĭebian’s default repositories contain PostgreSQL packages, so we can install these using the apt packaging system. sudo apt update sudo apt install postgresql postgresql-contrib Setup of Roles The installation of Postgres creates a user postgres with access to a default postgres database. My goal was to have a simple as possible setup, avoiding run multiple database systems simultaneously.Įither way, PostgreSQL has its advantages like an extensive SQL compliance, data integrity and being open source and community driven.īut maybe it isn’t the right choice for you and for a more informed decision you can, for example, read this comparison between SQLite vs MySQL vs PostgreSQL. The default repositories for Ubuntu and Mint (and others) have the Postgres packages so we can use apt to install. I choosed PostgreSQL mainly because I planned to run other applications, in the same server, that are only compatible with it. In fact, the officially recommended database management system by Nextcloud is MySQL or MariaDB. PostgreSQL isn’t the obvious choice to use with Nextcloud. I’m currently using Debian 11, but these instructions may be equally valid for other versions of Debian and Ubuntu. Instead, depending how Postgres was originally installed and what version you are using, the default authentication method will either be ident or peer. We’ll now proceed with the installation of PostgreSQL, a relational database management system. For Mac Postgres App For Linux For APT systems (Ubuntu, Debian, Mint, Etc) sudo apt-get install postgresql For Arch Linux sudo pacman -S postgresql For YUM.
On the way to install Nextcloud we’ve already completed the initial setup of our VPS and the installation of a webserver (Nginx).
0 kommentar(er)
