The pathces and a prototype tool to manipulate the ``flat password file'' functionality of PostgreSQL6.11. FileMakefilepg_passwd.c           the source file of the tool.2. How to specify pasword files and their format.Specify the password file in the same style of Ident authentication in$PGDATA/pg_hba.confhost  unv     133.65.96.250   255.255.255.255 password passwdThe above line allows access from 133.65.96.250 using the passwords listedin $PGDATA/passwd.The format of the password files follows those of /etc/passwd and/etc/shadow: the first field is the user name, and  the second fieldis the encrypted password.  The rest is completely ignored.  Thusthe following three sample lines specify the same user and password pair:.pg_guest:/nB7.w5Auq.BY:10031::::::pg_guest:/nB7.w5Auq.BY:93001:930::/home/guest:/bin/tcshpg_guest:/nB7.w5Auq.BY:93001Note that the original src/backend/libpq/password.c has a bug, whichdisallows the first and the second format.  If you want to use theseformats, please make sure you've applied the patch accompanied withthis tool.3. Usage of pg_passwdSupply the password file to the pg_passwd command.   In the case describedabove, after ``cd'ing to $PGDATA,  the following command execution specifythe new password for pg_guest:% pg_passwd passwdUsername: pg_guestPassword:Re-enter password:where the Password: and Re-enter password: prompts require the samepassword input which are not displayed on the terminal.The original password file is renamed to ``passwd.bk''.4. How to specify pasasword authenticationYou can use the password authentication fro psq, perl, or pg{tcl,tk}sh.4.1 psqlUse the -u option.  Note that the original distribution includes a bug.Please make sure you've applied the patch distributed with this tool.The following lines show the sample usage of the option:% psql -h hyalos -u unvUsername: pg_guestPassword:Welcome to the POSTGRESQL interactive sql monitor:  Please read the file COPYRIGHT for copyright terms of POSTGRESQL   type \? for help on slash commands   type \q to quit   type \g or terminate with semicolon to execute query You are currently connected to the database: unvunv=>4.2 perl5Use the new style of the Pg.pm like this$conn = Pg::connectdb("host=hyalos authtype=password dbname=unv                       user=pg_guest password=xxxxxxx");For more details, the users refer to to ``src/pgsql_perl5/Pg.pm''.4.3 pg{tcl,tk}shUse the pg_connect comamnd with -conninfo option thus% set conn [pg_connect -conninfo \        "host=hyalos authtype=password dbname=unv \         user=pg_guest password=xxxxxxx "]Use can list all of the keys for the option by executing the followingcommand:% puts [ pg_conndefaults]5. AcknowledgmentMr. Ishii, SRA, pointed out the original bugs in the tool.  He alsosupplied the Makefile for this distribution.-------------------------------------------------------------------------July 2, 1997Yoshihiko Ichikawa, Dept of Info Sci, Fac of Sci, Ochanomizu UniversityE-mail: ichikawa@is.ocha.ac.jpPostgreSQL Data Base Management System (formerly known as Postgres, thenas Postgres95).  This directory contains the version 6.1 release of the PostgreSQLdatabase server.  The server is not ANSI SQL compliant, but it getscloser with every release.  After you unzip and untar the distributionfile, look at file INSTALL for the installation notes and file HISTORYfor the changes.The latest version of this software may be obtained atftp://ftp.postgresql.org/pub/.  For more information look at our WWWhome page located athttp://www.postgreSQL.org/.PostgreSQL is not public domain software.  It is copyrighted by theUniversity of California but may be used according to the licensingterms of the the copyright below:------------------------------------------------------------------------POSTGRES95 Data Base Management System (formerly known as Postgres, thenas Postgres95).Copyright (c) 1994-7 Regents of the University of CaliforniaPermission to use, copy, modify, and distribute this software and itsdocumentation for any purpose, without fee, and without a written agreementis hereby granted, provided that the above copyright notice and thisparagraph and the following two paragraphs appear in all copies.IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FORDIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDINGLOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITSDOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THEPOSSIBILITY OF SUCH DAMAGE.THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITYAND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER ISON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TOPROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.