Deployment of PostgreSQL Portable Version

1. Download the Portable Zip Package

Official website address: https://www.enterprisedb.com/download-postgresql-binaries

Or

Cloud drive link: "PostgreSQL"

Link: https://pan.baidu.com/s/1U9ZTYZ1OG2ihFnmLVE6MhQ?pwd=6jx5

Extraction code: 6jx5

2. Unzip the file, and create a data folder to store data

D:\tools\postgres\pgsql\data

3. Initialize the Database

Run cmd as administrator and enter the bin directory

 initdb.exe -D D:\tools\postgres\pgsql\data -E UTF-8 --locale=chs -U postgres -W

4. Register as a System Service

pg_ctl.exe register -N pgsql -D D:\tools\postgres\pgsql\data

5. Install PostGIS

postgis address: https://www.postgresql.org/ftp/

AI Translation | AI 翻译

This article was translated from Chinese to English by AI. If there are any inaccuracies, please refer to the original Chinese version.


本文由 AI 辅助从中文翻译为英文。如遇不准确之处，请以中文原版为准。