The home directory for the user is set to /var/lib/postgresql. id postgres uid=107(postgres) gid=115(postgres) groups=115(postgres),114(ssl-cert) PostgreSQL 13.3 (Debian 13.3-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bitīy default, postgres user is created upon the installation of PostgreSQL. Similarly, you can use the command sudo -Hiu postgres psql -c "SELECT version() " Sample command output postgres (PostgreSQL) 13.3 (Debian 13.3-1) You can find the version of install PostgreSQL on command line using the command below /usr/lib/postgresql/13/bin/postgres -V If you want to install other versions of PostgreSQL on Debian 11, you need to add the PostgreSQL apt repository echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list curl -sL | sudo tee /etc/apt//pgdg.asc >/dev/null apt update Install PostgreSQL 12 on Debian 11 apt install postgresql-12 postgresql-contrib-12 Install PostgreSQL 11 on Debian 11 apt install postgresql-11 postgresql-contrib-11 Verifying Version of Installed PostgreSQL on command line Installing Other Versions of PostgreSQL on Debian 11 └─3595 postgres: 13/main: logical replication launcherĪug 30 20:17:42 debian11 systemd: Starting PostgreSQL Cluster 13-main.Īug 30 20:17:45 debian11 systemd: Started PostgreSQL Cluster 13-main. ├─3594 postgres: 13/main: stats collector ├─3593 postgres: 13/main: autovacuum launcher ├─3591 postgres: 13/main: background writer ├─3588 /usr/lib/postgresql/13/bin/postgres -D /var/lib/postgresql/13/main -c config_file=/etc/postgresql/13/main/nf Loaded: loaded (/lib/systemd/system/ enabled-runtime vendor preset: enabled)Īctive: active (running) since Mon 20:17:45 EAT 1min 25s agoĬGroup: /system.slice/system-postgresql.slice/ When installation is done, PostgreSQL is set to run and start on system boot. Therefore, to install PostgreSQL 13 on Debian 11, run the command below apt install postgresql postgresql-contrib Running PostgreSQL This makes it easy to install PostgreSQL 13.x on Debian 11. As of this writing, PostgreSQL 13 is the current major PostgreSQL release.įortunately, the default Debian 11 main repositories provides PostgreSQL packages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |