Установка LAMP с PostgreSQL и PostGIS

sudo apt update && sudo apt upgrade -y

sudo apt install apache2 -y

sudo systemctl status apache2

sudo apt install php libapache2-mod-php php-pgsql -y

php -v

sudo apt install postgresql postgresql-contrib -y

sudo systemctl status postgresql

sudo apt install postgis postgresql-<VERSION>-postgis-3 -y

sudo -u postgres psql

CREATE DATABASE your_database_name;
\c your_database_name
CREATE EXTENSION postgis;

CREATE USER your_user_name WITH ENCRYPTED PASSWORD 'your_password';
GRANT ALL PRIVILEGES ON DATABASE your_database_name TO your_user_name;