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
thishelp, 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