unix_socket_directories = '/usr/local/postgresql' /usr/local:表示数据库安装路径,请用户根据实际规划路径修改。 按“Esc”键,输入:wq!,按“Enter”保存并退出编辑。 执行以下命令,切换至root用户。 su - root 执行以下命令,重启PostgreSQL服务。 非HA场景 systemctl restart postgresql.service systemctl status...
下面把unix_socket_directories设置为/data/pg12,重新启动 [pg12@localhost pg120db]$ grep'unix' postgresql.confunix_socket_directories ='/data/pg12' # comma-separated list of directories#unix_socket_directories ='/tmp' # comma-separated list of directories#unix_socket_group ='' # (change requir...
修改unix_socket_directories,但是如果只是单纯修改这个参数指定的路径,那么psql会报错,在用户环境变量中指定PGHOST变量为这个目录就可以解决这个问题了,所以前面的PGHOST环境变量已经指定 unix_socket_directories = '/app/pgsql/13.7/socket' 重启数据库生效,在root下用systemctl restart postgresql-13重启 postgres=# s...
unix_socket_directories = '.' # comma-separated list of directories shared_buffers = 194GB # 尽量用数据库管理内存,减少双重缓存,提高使用效率 huge_pages = on # on, off, or try ,使用大页 work_mem = 256MB # min 64kB , 减少外部文件排序的可能,提高效率 maintenance_work_mem = 2GB # min ...
unix_socket_directories: 这个参数用来指定 Unix 套接字目录的路径。Unix 套接字是一种用于本地连接的通信机制,通常用于在同一台主机上连接 PostgreSQL 服务器。 authentication_timeout: 这个参数指定了客户端认证的超时时间。默认值是 1min。如果认证超时时间较长,可以适当增加这个值。 以上是一些常见的网络设置指南...
unix_socket_directories = '/tmp' pcp_listen_addresses = '*' pcp_port = 9898 pcp_socket_dir = '/tmp' # master backend_hostname0 = '172.16.128.10' #主机名或IP地址 backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/home/postgres/pgdata' ...
;# defaults to 'localhost'; use '*' for all# (change requires restart)port=5432# (change requires restart)max_connections=100# (change requires restart)#superuser_reserved_connections = 3 # (change requires restart)#unix_socket_directories = '/tmp' # comma-separated list of directories...
#unix_socket_directories = '/tmp' # comma-separated list of directories # (change requires restart) #bonjour = off # advertise server via Bonjour # (change requires restart) #bonjour_name = '' # defaults to the computer name # (change requires restart) ...
12/main/pg_ident.conf'# ident configuration fileexternal_pid_file='/var/run/postgresql/12-main.pid'# write an extra PID fileport=5432# (change requires restart)max_connections=100# (change requires restart)unix_socket_directories='/var/run/postgresql'# comma-separated list of directoriesssl=...
unix_socket_directories = '/tmp' # Unix domain socket path(s) # The Debian package defaults to # /var/run/postgresql # (change requires restart) #unix_socket_group = '' # The Owner group of Unix domain socket(s) # (change requires restart) ...