/var/lib/pgsql/13/* /data_pg/ #将原数据目录下所有内容移动到新 数据目录下 # vi /usr/lib/systemd/system/postgresql-13.service #pg-13版本，修改systemd服 务文件，指定数据目录 #修改这行：Environment=PGDATA=/var/lib/pgsql/13/data/ 改为新的路径，如 下： /var/lib/pgsql/* /data_pg/ #将原数据目录下所有内容移动到新数 据目录下 # vi /usr/lib/systemd/system/postgresql.service #pg-10版本，修改systemd服务 文件，指定数据目录 #修改这行：Environment=PGDATA=/var/lib/pgsql/data/ 改为新的路径，如下： E HeidiSQL官网： h�ps://www.heidisql.com/ pgAdmin官网下载： h�ps://www.pgadmin.org/download/ 下载并安装最新版本的HeidiSQL，新建会话，网络类型为PostgreSQL(TCP/IP)，依 赖库要>=目标pg数据库版本 下载最新版本的pgAdmin并安装运行 ★第6章、数据库及表基础操作 pg数据库名称及表名称不区分大小写

......................................................................690 31.16. The Connection Service File ..............................................................................690 31.17. LDAP installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this https://buildfarm.postgresql.org/ 406 Chapter 15. Installation from Source Code AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel

......................................................................729 31.16. The Connection Service File .....................................................................................729 31 installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 2. https://buildfarm.postgresql.org/ 432 Chapter 15. Installation from Source Code AIX

......................................................................642 31.15. The Connection Service File ..............................................................................643 31.16. LDAP installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel

......................................................................678 31.15. The Connection Service File .....................................................................................679 31 Chapter 15. Installation from Source Code --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel

......................................................................669 31.16. The Connection Service File ..............................................................................669 31.17. LDAP installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this https://buildfarm.postgresql.org/ 394 Chapter 15. Installation from Source Code AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel

......................................................................710 31.16. The Connection Service File .....................................................................................711 31 installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 2. https://buildfarm.postgresql.org/ 421 Chapter 15. Installation from Source Code AIX

......................................................................426 28.13. The Connection Service File .....................................................................................427 28 installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal. postgres is the default. There’s usually no reason to change this. --with-openssl Build Sets the Kerberos service name. See Section 20.2.3 for details. This parameter can only be set at server start. krb_server_hostname (string) Sets the host name part of the service principal. This, combined

......................................................................645 31.15. The Connection Service File .....................................................................................646 31 installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel

......................................................................605 31.15. The Connection Service File ..............................................................................606 31.16. LDAP installation is sufficient before proceeding. --with-krb-srvnam=NAME The default name of the Kerberos service principal (also used by GSSAPI). postgres is the default. There’s usually no reason to change this + post ML11 bundle AIX 5.1 Maintenance Level 9 + post ML9 bundle AIX 5.2 Technology Level 10 Service Pack 3 AIX 5.3 Technology Level 7 AIX 6.1 Base Level To check your current fix level, use oslevel