pgsql FAQ

1，./pgadmin3: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

解决方法：

1: Know the path of "libpq.so.5"

find / -name libpq.so.5

Output example:"/usr/pgsql-9.4/lib/libpq.so.5"If found nothing, check if you have already installed the suitable postgresql-libs for your postgresql version and your OS platform

2: Symbolic link that library in a "well known" library path like "/usr/lib":

ln -s /usr/pgsql-9.4/lib/libpq.so.5 /usr/lib/libpq.so.5

Attention:If your platform is 64 bit, you MUST also symbolic link to 64 bit libraries path:

ln -s /usr/pgsql-9.4/lib/libpq.so.5 /usr/lib64/libpq.so.5

2、connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

psql进入数据库时出现：
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

解决方案：

1、copy一个.s.PGSQL.5432文件，并增加权限。

2、调小共享内存、BUFFER、最大联接数。