Lists: | pgsql-hackers |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
scripts_pqpasswd_patch | application/octet-stream | 13.0 KB |
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp> |
Cc: | "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:52:59 |
Message-ID: | 21103.1141066379@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
"Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)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
From: | "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] display and expression of the home directory in Win32 |
Date: | 2006-02-27 19:07:21 |
Message-ID: | 021001c63bd1$090c6a10$01324d80@hiroshi5jz7dqj |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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