#先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13版本，添加或修改以下配 置 data_directory = '/data_pg/data/' # mv /var/lib/pgsql/13/* mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/data/postgresql.conf #pg-10版本，添加或修改以下配置 data_directory = '/data_pg/data/' # mv /var/lib/pgsql/* /data_pg/ 0.0.1的ip及5432/tcp端口 ★PG-13版本 # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13版本 #若修改了存储路径，则在新的路径下/data_pg/data/postgresql.conf，默认监听 127.0.0.1:5432 listen_addresses = '*' port = 5432 # vi

.................................................. 2959 O.1. recovery.conf file merged into postgresql.conf ............................. 2959 O.2. Default Roles Renamed to Predefined Roles .......... usage pattern exists. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Everyone retains the ability to create instead. 6. Ensure that the constraint_exclusion configuration parameter is not disabled in postgresql.conf; otherwise child tables may be accessed unnecessarily. 106 Data Definition As we can see,

.................................................. 3113 O.1. recovery.conf file merged into postgresql.conf ............................. 3113 O.2. Default Roles Renamed to Predefined Roles .......... in schema pg_catalog. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Then, grant privileges to create in the instead. 6. Ensure that the constraint_exclusion configuration parameter is not disabled in postgresql.conf; otherwise child tables may be accessed unnecessarily. As we can see, a complex table hierarchy

.................................................. 2801 O.1. recovery.conf file merged into postgresql.conf ....................... 2801 O.2. Default Roles Renamed to Predefined Roles ................ usage pattern exists. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Everyone retains the ability to create can be selected by the user using the SET datestyle command, the DateStyle parameter in the postgresql.conf configuration file, or the PGDATESTYLE environment vari- able on the server or client. The formatting

.................................................. 2869 O.1. recovery.conf file merged into postgresql.conf ............................. 2869 O.2. pg_xlogdump renamed to pg_waldump .................. usage pattern exists. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Everyone retains the ability to create instead. 6. Ensure that the constraint_exclusion configuration parameter is not disabled in postgresql.conf; otherwise child tables may be accessed unnecessarily. 106 Data Definition As we can see,

.................................................. 3059 O.1. recovery.conf file merged into postgresql.conf ............................. 3059 O.2. Default Roles Renamed to Predefined Roles .......... in schema pg_catalog. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Then, grant privileges to create 95 instead. 6. Ensure that the constraint_exclusion configuration parameter is not disabled in postgresql.conf; otherwise child tables may be accessed unnecessarily. 109 Data Definition As we can see,

.................................................. 2946 O.1. recovery.conf file merged into postgresql.conf ....................... 2946 O.2. Default Roles Renamed to Predefined Roles ................ in schema pg_catalog. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Then, grant privileges to create in the can be selected by the user using the SET datestyle command, the DateStyle parameter in the postgresql.conf configuration file, or the PGDATESTYLE environment vari- able on the server or client. 1 https://datatracker

.................................................. 2714 O.1. recovery.conf file merged into postgresql.conf ....................... 2714 xx PostgreSQL 13.13 Documentation O.2. pg_xlogdump renamed to usage pattern exists. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Everyone retains the ability to create can be selected by the user using the SET datestyle command, the DateStyle parameter in the postgresql.conf configuration file, or the PGDATESTYLE environment vari- able on the server or client. The formatting

.................................................. 2873 M.1. recovery.conf file merged into postgresql.conf ............................ 2873 M.2. pg_xlogdump renamed to pg_waldump ................... usage pattern exists. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Everyone retains the ability to create instead. 6. Ensure that the constraint_exclusion configuration parameter is not disabled in postgresql.conf; otherwise child tables may be accessed unnecessarily. 107 Data Definition As we can see,

.................................................. 2904 O.1. recovery.conf file merged into postgresql.conf ....................... 2904 O.2. Default Roles Renamed to Predefined Roles ................ in schema pg_catalog. • Remove the public schema from the default search path, by modifying postgresql.conf or by issuing ALTER ROLE ALL SET search_path = "$user". Then, grant privileges to create in the can be selected by the user using the SET datestyle command, the DateStyle parameter in the postgresql.conf configuration file, or the PGDATESTYLE environment vari- able on the server or client. 1 https://tools