CÀI ĐẶT THƯ VIỆN CHO PGSQL
sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
Import the repository signing key:
sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc –fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
Create the repository configuration file:
sudo sh -c ‘echo “deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main” > /etc/apt/sources.list.d/pgdg.list’
Update the package lists:
sudo apt update
Install the latest version of PostgreSQL:
If you want a specific version, use ‘postgresql-16’ or similar instead of ‘postgresql’
sudo apt -y install postgresql
CÀI ĐẶT postgis
apt update
apt install -y postgresql-16-postgis
Sau đó kiểm tra thư mục extension:
ls -l /usr/share/postgresql/16/extension/ | grep postgis
🔧 4️⃣ Copy file PostGIS về thư mục PostgreSQL của BT Panel
Vì BT Panel sử dụng /www/server/pgsql/ thay vì /usr/share/postgresql/, cần copy các file PostGIS vào thư mục này:
mkdir -p /www/server/pgsql/share/extension/
cp -r /usr/share/postgresql/16/extension/postgis* /www/server/pgsql/share/extension/
cp -r /usr/lib/postgresql/16/lib/postgis-3.so /www/server/pgsql/lib/
Sau đó, kiểm tra xem PostGIS đã có trong thư mục /www/server/pgsql/share/extension/ chưa:
ls /www/server/pgsql/share/extension/ | grep postgis
🔥 5️⃣ Khởi động lại PostgreSQL
Chạy và kiểm tra nó trong pgadmin:
CREATE EXTENSION postgis;
SELECT postgis_full_version();
