diff options
author | Timo Weingärtner <timo@tiwe.de> | 2012-11-03 17:43:58 +0100 |
---|---|---|
committer | Timo Weingärtner <timo@tiwe.de> | 2013-01-07 14:18:40 +0100 |
commit | a8e7c707a3e85cfcbdf2706634e8fc07dd9b3f54 (patch) | |
tree | 4009a056b4f2645c676b275ba90cae21c87284f9 | |
parent | 9817011424d5a37501ffb6bcee573e6fb25b852d (diff) | |
download | openssh-known-hosts-a8e7c707a3e85cfcbdf2706634e8fc07dd9b3f54.tar.gz |
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
-rw-r--r-- | examples/psql | 4 | ||||
-rwxr-xr-x | plugins/psql | 8 |
2 files changed, 6 insertions, 6 deletions
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 diff --git a/plugins/psql b/plugins/psql index d1009ef..aa210d2 100755 --- a/plugins/psql +++ b/plugins/psql @@ -2,20 +2,18 @@ # psql plugin # -# uses psql to download a table (or view) of the form: +# uses psql to download a TABLE (or VIEW) of the form: # CREATE TABLE known_hosts ( # namelist text, # comma seperated # type text, # key text # ); +# alternatively only one column with spaces between those three # # ENVIRONMENT VARIABLES: # TABLE table to download # used by psql: -# PGCLUSTER see pg_wrapper(1) -# PGDATABASE see psql(1) -# PGUSER .. -# PGPASSFILE .. +# PG* see psql(1) # set -e |