:~$ exit Step 3: Enable remote access (Optional)īy default, access to PostgreSQL database server is only from localhost. We need to set PostgreSQL admin user Password: $ sudo su - postgres :~$ psql -c "alter user postgres with password ' StrongDBPassword '" May 18 20:12:39 systemd: Started PostgreSQL Cluster 11-main. May 18 20:12:36 systemd: Starting PostgreSQL Cluster 11-main. └─1070625 postgres: 11/main: logical replication launcher ├─1070624 postgres: 11/main: stats collector ├─1070623 postgres: 11/main: autovacuum launcher ├─1070621 postgres: 11/main: background writer
├─1070618 /usr/lib/postgresql/11/bin/postgres -D /var/lib/postgresql/11/main -c config_file=/etc/postgresql/11/main/nf Process: 1070613 ExecStart=/usr/bin/pg_ctlcluster -skip-systemctl-redirect 11-main start (code=exited, status=0/SUCCESS)ĬGroup: /system.slice/system-postgresql.slice/
Loaded: loaded (/lib/systemd/system/ enabled-runtime vendor preset: enabled)Īctive: active (running) since Wed 20:12:39 UTC 35s ago The service is usually started after installation. Now install PostgreSQL 11 on Debian 11 / Debian 10 by running the command below. Sudo apt install vim curl gpg gnupg2 software-properties-common apt-transport-https lsb-release ca-certificatesĬurl -fsSL |sudo gpg -dearmor -o /etc/apt//postgresql.gpgĪdd the repository: echo "deb `lsb_release -cs`-pgdg main" |sudo tee /etc/apt//pgdg.list Step 2: Install PostgreSQL 11 on Debian 11 / Debian 10 Then Import the repository signing key: sudo apt update
0 kommentar(er)
