From a8e7c707a3e85cfcbdf2706634e8fc07dd9b3f54 Mon Sep 17 00:00:00 2001
From: Timo Weingärtner <timo@tiwe.de>
Date: Sat, 3 Nov 2012 17:43:58 +0100
Subject: update pgsql plugin documentation

+ add SSL verification options
+ replace PGCLUSTER with PGHOST, former cements the use of a specific
  version of postgresql-client.

Git-Dch: Full
---
 examples/psql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'examples/psql')

diff --git a/examples/psql b/examples/psql
index e2e72cb..3fc7102 100644
--- a/examples/psql
+++ b/examples/psql
@@ -3,8 +3,10 @@ PLUGIN=psql
 # the session was not interactive
 EXIT_IGNORE=2
 
-PGCLUSTER=8.3/db.example.com:
+PGHOST=db.example.com
 PGDATABASE=exampledb
+PGSSLMODE=verify-full
+PGSSLROOTCERT=/etc/ssl/certs/examplerootcert
 PGUSER=exampleuser
 PGPASSWORD=foobar # beware: will be readable from /proc/<pid>/environ, better:
 PGPASSFILE=/path/to/.pgpass
-- 
cgit v1.2.3