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

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

From
"Hiroshi Saito"
Date:
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

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

From
Tom Lane
Date:
"Hiroshi Saito" <saito@inetrt.skcapi.co.jp> writes:
> C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe --help
> pqpasswd installs a pgpass(libpq) connect a PostgreSQL database.

I must be missing something.  What exactly does this accomplish that
couldn't be done at least as flexibly with a simple text editor?

If the argument is "point-and-drool Windows users can't be expected to
use a text editor", I would think that the same argument applies to
a command-line program; you'd have to make a GUI application to make
it easier to use than Notepad or what-have-you.
        regards, tom lane


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

From
"Hiroshi Saito"
Date:
Thank you for a quick response.

From: "Tom Lane"


> > C:\Program Files\PostgreSQL\8.1\bin>pqpasswd.exe --help
> > pqpasswd installs a pgpass(libpq) connect a PostgreSQL database.
> 
> I must be missing something.  What exactly does this accomplish that
> couldn't be done at least as flexibly with a simple text editor?

Ah, It is involved with an environment variable, and a user has to operate it, 
fully taking into consideration. While opening the text editor, someone may 
be in your back....

> 
> If the argument is "point-and-drool Windows users can't be expected to
> use a text editor", I would think that the same argument applies to
> a command-line program; you'd have to make a GUI application to make
> it easier to use than Notepad or what-have-you.

Um, pgAdminIII is performing it. As for it, the solution method is different 
though regrettable....
As a very important thing, I am planning future encryption.

Regards,
Hiroshi Saito