Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] display and expression of the home directory in Win32

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] display and expression of the home directory in Win32
Date: 2006-02-27 18:34:02
Message-ID: 01d401c63bcc$618fa990$01324d80@hiroshi5jz7dqj (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)postgresql(dot)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

Attachment: scripts_pqpasswd_patch
Description: application/octet-stream (13.0 KB)

Responses

pgsql-hackers by date

Next:From: Clark C. EvansDate: 2006-02-27 18:37:03
Subject: Re: constraints and sql92 information_schema compliance
Previous:From: Peter EisentrautDate: 2006-02-27 18:20:01
Subject: Automatic free space map filling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group