To reproduce the problem:
1. Open pgAdmin
2. Double click on server to connect
to. On the "Connect to Server" dialogue box check "Store
Password" and enter your password.
3. Close pgAdmin.
4. Reopen pgAdmin and try to connect
to the same server. You will be the following error: "Error
connectin
Mitch S McKenzie wrote:
To reproduce the problem:
1. Open pgAdmin
2. Double click on server to connect to. On the "Connect to Server"
dialogue box check "Store Password" and enter your password.
3. Close pgAdmin.
4. Reopen pgAdmin and try to connect to the same server. You will be
the foll
That's how it's suppose to work??? Throwing
and error???
hr..
So it's only suppose to save your password
for the duration you have the application open?
So if I never close pgAdmin then I don't
have to supply my password again.
Definitely not a feature I will be using
; )
Thanks Andr
Mitch S McKenzie wrote:
That's how it's suppose to work??? Throwing and error???
hr..
So it's only suppose to save your password for the duration you have the
application open?
No, it's supposed to save it if you press OK! In addition, it will
remember it until you close pgAdmin.
We, too, have found that the save-password does NOT work as described. Even
when OK is pressed fervently.
David Fisher
Pres.
Fisher Aircraft Corporation
Two Cairn StreetRochester, New York 14611-2416
[EMAIL PROTECTED]585.889.4026
Omnia extares!
-
Andreas,
Where is the pgpass.conf file??? Do I have to create
it?
"In addition, it will remember it until you close
pgAdmin."
Why only until I close the application? Still don't
understand the purpose of the feature then.
Don't worry about it. I will just
continue to input my password every
David Fisher wrote:
We, too, have found that the save-password does NOT work as described. Even
when OK is pressed fervently.
I can't reproduce this, that's why I asked for precise information about
user/password etc...
To repeat:
After pgAdmin has stored the password, it should reuse pgpass
Mitch S McKenzie wrote:
Andreas,
Where is the pgpass.conf file???
Please search the docs for the path, don't have it at hand right now.
Do I have to create it?
pgAdmin does it for you.
"In addition, it will remember it until you close pgAdmin."
remember internally, i.e. in RAM. This c
This pgpass.conf file is NOT created by pgAdmin. It is not there. This may
be relevant?
David Fisher
Pres.
Fisher Aircraft Corporation
Two Cairn StreetRochester, New York 14611-2416
[EMAIL PROTECTED]585.889.4026
Omnia extares!
---Original Mes
David Fisher wrote:
This pgpass.conf file is NOT created by pgAdmin. It is not there. This may be
relevant?
Very funny. Since the password is stored there, surely nonexistence *is*
relevant...
Do you have correct write access to your home directory? On English win32
C:\Documents and Set
Sorry, my error. I had not looked for the file in the right place. How
embarrassing.
It IS where you say, and it does contain the correct IP and password data.
However, we still get the same behaviour. Open pgAdmin and double-click on
the server, get a connection error message, close that dialogue
Oh, bother. Got it wrong. Subsequent reconnections do NOT ask for the
password again.
It's been a long day.
It appears that this aberrant behaviour occurs on connections to another
computer but not on connections to a server on localhost.
- David
Da
David Fisher wrote:
Sorry, my error. I had not looked for the file in the right place. How
embarrassing.
It IS where you say, and it does contain the correct IP and password data.
However, we still get the same behaviour. Open pgAdmin and double-click on
the server, get a connection error messa
David Fisher wrote:
Changed the password in pgpass.conf, opened pgAdmin, went past the error
msg, logged in with the correct password, closed pgAdmin; the correct
password had been written to pgpass.conf.
If pgAdmin doesn't ask for the password, it won't write it to the file,
so your manual
Guys,
Quick note that came in on one of the postgres lists, about storing
pg passwords for Win32 users.
>Do you have correct write access to your home directory? On English win32
>C:\Documents and Settings\\Application Data\postgresql\pgpass.conf
>or more exactly %APPDATA%\postgresql\pgpass.con
15 matches
Mail list logo
