From: Dan McGuirk <mcguirk@indirect.com>

Subject: [HACKERS] password authentication

This patch adds support for plaintext password authentication.  To use
it, you add a line like

host         all         0.0.0.0       0.0.0.0           password  pg_pwd.conf


to your pg_hba.conf, where 'pg_pwd.conf' is the name of a file containing
the usernames and password hashes in the format of the first two fields
of a Unix /etc/passwd file.  (Of course, you can use a specific database
name or IP instead.)

Then, to connect with a password through libpq, you use the PQconnectdb()
function, specifying the "password=" tag in the connect string and also
adding the tag "authtype=password".

I also added a command-line switch '-u' to psql that tells it to prompt
for a username and password and use password authentication.

1 files changed, 5 insertions, 2 deletions

diff --git a/src/include/config.h.in b/src/include/config.h.in
index c0f56a2ac09..99973dde07f 100644
--- a/src/include/config.h.in
+++ b/src/include/config.h.in
@@ -266,8 +266,11 @@
  */
 /*#define GEQO */ /* backend/optimizer/path/allpaths.c */
 
-
-
+/*
+ * Define this if you want psql to _always_ ask for a username and a password
+ * for password authentication.
+ */
+/* #define PSQL_ALWAYS_GET_PASSWORDS */
 
 /* Undocumented "features"? */
 #define FASTBUILD /* access/nbtree/nbtsort.c */