From 2b4ae9c29d42ce7b1b7bb947c585b78a21535aa2 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 18 Aug 2016 21:41:10 -0400 Subject: [PATCH] doc: requirepeer is a way to avoid spoofing We already mentioned unix_socket_directories as an option. Reported-by: https://www.postgresql.org/message-id/45016837-6cf3-3136-f959-763d06a28076%402ndquadrant.com Backpatch-through: 9.6 --- doc/src/sgml/runtime.sgml | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 9007987dab..51d4f9ca1b 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1913,7 +1913,7 @@ pg_dumpall -p 5432 | psql -d postgres -p 5433 - The simplest way to prevent spoofing for local + On way to prevent spoofing of local connections is to use a Unix domain socket directory () that has write permission only for a trusted local user. This prevents a malicious user from creating @@ -1925,6 +1925,13 @@ pg_dumpall -p 5432 | psql -d postgres -p 5433 /tmp cleanup script to prevent removal of the symbolic link. + + Another option for local connections is for clients to use + requirepeer + to specify the required owner of the server process connected to + the socket. + + To prevent spoofing on TCP connections, the best solution is to use SSL certificates and make sure that clients check the server's certificate. -- 2.40.0