Hi All. I have thought this way and that since that time. Suggestion of Magnus-san was considered and this was made.
I considered many things about the pgpass guide of libpq. In windows, even the place of it was not clear. Furthermore, they are intricately concerned with an environment variable again. Then, I thought that wanted to take into consideration not only a position but its maintenance. C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe --help pqpasswd installs a pgpass(libpq) connect a PostgreSQL database. Usage: pqpasswd [OPTION]... [DBNAME] Options: -l, --list show a list of installed pgpass -r, --remove remove the my pgpass -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port -d, --dbname=DBNAME database to connect as -U, --username=USERNAME user name to connect as --help show this help, then exit --version output version information, then exit Report bugs to <pgsql-bugs@postgresql.org>. C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe --list C:\Documents and Settings\saito\Application Data/postgresql/pgpass.conf hostname=localhost port=5432 dbname=* username=postgres password=********** hostname=* port=5432 dbname=saito username=saito password=********** hostname=localhost port=5432 dbname=* username=z-saito password=********** The 2th line is used. password change can be made as follows. C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe --dbname="*" --username="postgres" New Password: Retype New Password: Succeeded in creation. C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe -l --dbname="*" --username="postgres" C:\Documents and Settings\saito\Application Data/postgresql/pgpass.conf hostname=localhost port=5432 dbname=* username=postgres password=********** hostname=* port=5432 dbname=saito username=saito password=********** hostname=localhost port=5432 dbname=* username=z-saito password=********** The 1th line is used. I want the password to be enciphered in the future. However, we fully have to take the past property into consideration. Then, I want this to be equipped as first stage. any suggestion.? Regards, Hiroshi Saito
scripts_pqpasswd_patch
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
