PostgreSQL setup

wizard database

Install PostgreSQL, initialize database, create user and database

Steps

Step 1 of 5 20%

OS family *

Ubuntu/Debian = apt, Rocky/Alma/Amazon = dnf

Show all steps

OS family *

Ubuntu/Debian = apt, Rocky/Alma/Amazon = dnf

Database name *

Database user *

Database user password *

Allow remote connections Allow remote connections

Adds listen_addresses = '*' to postgresql.conf

Generated Output

sudo apt update && sudo apt install -y postgresql && sudo systemctl enable --now postgresql && sudo -u postgres psql -c "CREATE USER appuser WITH PASSWORD '';" && sudo -u postgres psql -c "CREATE DATABASE myapp OWNER appuser;" && sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE myapp TO appuser;"

PostgreSQL setup

Steps

Generated Output

Related