http://200yi.com/ff_internal/ 2026-04-27T21:13:04+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2025-01-25T01:00:20+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:%E5%AE%89%E8%A3%85%E4%B8%8E%E8%B0%83%E8%AF%95:PostgreSQL%E5%8A%A0%E5%AF%86%E8%BF%9E%E6%8E%A5SSL%E9%85%8D%E7%BD%AE&rev=1737738020&do=diff 转自：<https://blog.csdn.net/myneth/article/details/143722950> SSL说明 什么是SSL？ SSL的全名叫做Secure Socket Layer(安全套接字层)，最开始是由一家叫网景的互联网公司开发出来，主要是防止信息在互联网上传输的时候不被窃听或者篡改，后来网景公司提交SSL给ISOC组织做标准化，改名为TLS。 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:%E5%AE%89%E8%A3%85%E4%B8%8E%E8%B0%83%E8%AF%95:PostgreSQL%E5%85%81%E8%AE%B8%E8%BF%9C%E7%A8%8B%E8%AE%BF%E9%97%AE%E8%AE%BE%E7%BD%AE&rev=1687008318&do=diff 安装PostgreSQL数据库之后，默认是只接受本地访问连接。如果想在其他主机上访问PostgreSQL数据库服务器，就需要进行相应的配置。 配置远程连接PostgreSQL数据库的步骤很简单，只需要修改data目录下的pg__ text/html 2026-01-09T01:00:05+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:%E5%AE%89%E8%A3%85%E4%B8%8E%E8%B0%83%E8%AF%95:RedHat%207%E6%BA%90%E7%A0%81%E5%AE%89%E8%A3%85PostgreSQL&rev=1767891605&do=diff 安装环境：CentOS x64 安装 postgresql-12.3 一、下载源码 https://www.postgresql.org/ftp/source/v12.3/ 二、安装依赖 yum install -y perl-ExtUtils-Embed yum install -y readline-devel yum install -y zlib-devel yum install -y pam-devel yum install -y libxml2-devel yum install -y libxslt-devel yum install -y openldap-devel yum install -y python-devel yum install -y gcc-c++ yum install -y openssl-devel yum install -y cmake yum install -y freetype-devel yum install -y bison yum install -y perl-FindBin… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:%E5%AE%89%E8%A3%85%E4%B8%8E%E8%B0%83%E8%AF%95:%E9%AB%98%E5%B9%B6%E5%8F%91psql%E8%BF%9E%E6%8E%A5%E6%8A%A5Resource%20temporarily%20unavailable&rev=1687008318&do=diff 问题 在Postgresql并发测试时，我们发现当并发psql数比较大时，会报告以下类似错误： psql: error: could not connect to server: Resource temporarily unavailable Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5404"?