1. 切换用户，修改密码
su - postgres
alter user postgres with password '123'
2. 忘记密码，重置
https://www.cnblogs.com/wuling129/p/4917574.html
3. 安装扩展
SELECT name, default_version,installed_version FROM pg_available_extensions WHERE name LIKE 'postgis%';
create extension postgis;
create extension postgis_topology;
create extension postgis_raster;
create extension postgis_sfcgal;
create extension fuzzystrmatch;
create extension postgis_tiger_geocoder;
4. 查看当前版本
select version();
select PostGIS_Full_Version();
5.过程截图
6. 登出
传送门
上一篇
下一篇
