navicat登录Postgres数据库

1、登录数据库

[root@localhost postgis-3.0.5]# su - postgres

[postgres@localhost postgis-3.0.5]$ psql

　2、安装插件

Last login: Fri Mar 3 13:47:40 CST 2023 on pts/1
su: warning: cannot change directory to /home/postgres: No such file or directory
Password for user postgres:         # 输入密码postgres
psql (12.5)
Type "help" for help.
 
postgres=#
创建控件数据库：
create database gisdb;\c gisdb
 需要给gisdb安装扩展gis插件：
CREATE EXTENSION postgis;gisdb=# CREATE EXTENSION postgis;
ERROR:  could not open extension control file "/export/servers/app/postgresql-12.5/share/extension/postgis.control": No such file or directory翻译：ERROR:无法打开扩展控制文件"/export/servers/app/postgresql-12.5/share/extension/postgis.control":没有这样的文件或目录处理方法：[root@localhost auto_explain]# make && make install[root@localhost auto_explain]# make
make -C ../../src/backend generated-headers
make[1]: Entering directory '/export/servers/app/postgresql-12.5/src/backend'
make -C catalog distprep generated-header-symlinks
make[2]: Entering directory '/export/servers/app/postgresql-12.5/src/backend/catalog'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend/catalog'
make -C utils distprep generated-header-symlinks
make[2]: Entering directory '/export/servers/app/postgresql-12.5/src/backend/utils'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend/utils'
make[1]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend'
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -O2 -fPIC -I. -I. -I../../src/include  -D_GNU_SOURCE   -c -o auto_explain.o auto_explain.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -O2 -fPIC -shared -o auto_explain.so auto_explain.o  -L../../src/port -L../../src/common    -Wl,--as-needed -Wl,-rpath,'/export/servers/app/postgresql-12.5/lib',--enable-new-dtags  
[root@localhost auto_explain]# make install
make -C ../../src/backend generated-headers
make[1]: Entering directory '/export/servers/app/postgresql-12.5/src/backend'
make -C catalog distprep generated-header-symlinks
make[2]: Entering directory '/export/servers/app/postgresql-12.5/src/backend/catalog'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend/catalog'
make -C utils distprep generated-header-symlinks
make[2]: Entering directory '/export/servers/app/postgresql-12.5/src/backend/utils'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend/utils'
make[1]: Leaving directory '/export/servers/app/postgresql-12.5/src/backend'
/usr/bin/mkdir -p '/export/servers/app/postgresql-12.5/lib'
/usr/bin/install -c -m 755  auto_explain.so '/export/servers/app/postgresql-12.5/lib/auto_explain.so'
报错：ERROR: could not load library "/export/servers/app/postgresql-12.5/lib/postgis-3.so": libgeos_c.so.1: cannot open shared object file: No such file or directory 问题处理：原因是找不到链接库，新增动态链接库的配置文件 vim /etc/ld.so.conf.d/postgres.conf/usr/local/geos-3.7.4/lib/usr/local/gdal-3.1.1/lib/usr/local/proj-6.2.1/lib 