Обсуждение: Unable to connect existing PGAdmin to existing PostgreSQL Db

This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and/or CONFIDENTIAL. This email is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this email is not an intended recipient, or you have received this email in error, you are hereby advised that any review, dissemination, distribution or copying is strictly prohibited. If you have received this email in error, please notify the sender immediately by return mail and permanently delete the copy you received.

On Thu, 2012-07-12 at 18:40 +0000, Zhang, Nancy wrote:
> Hi ,
> 
> I have come across this issue all the time.
> 
> I reinstalled and it works for a while. Once the computer rebooted, it appeared again.
> 

Well, without any kind of error messages, how do you want us to help
you?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Mon, 2012-07-16 at 12:50 +0000, Zhang, Nancy wrote:
> Thank you Gaullaume, 
> 
>  
> 
> Here is the screenshot of the issue:
> 

If it continues to ask you for the password, it is because you don't
give him the right password.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and/or CONFIDENTIAL. This email is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this email is not an intended recipient, or you have received this email in error, you are hereby advised that any review, dissemination, distribution or copying is strictly prohibited. If you have received this email in error, please notify the sender immediately by return mail and permanently delete the copy you received.

On Mon, 2012-07-16 at 13:45 +0000, Zhang, Nancy wrote:
> It is not that simple.
> 
> Once I installed PostgreSQL, it run well for a certain amount of time, then oneday, that window pop up, asking the
password.
> 

Something must be happening on your PC.

> And because I have come across this several times, so I put down the password and entered, making sure the password
isexactly the same as the one I set up when installing PostgreSQL.
 
> 
> Some guy at my firm told me it might be caused by the security setting of my computer...
> 
> Any more hint?
> 

No, I don't see how a security setting of your computer may be involved.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote:
> So what Should I do? Tons of thanks!
> 

Please, send the emails to the mailing list, not only me.

What should you do? I have no idea. All I know is that it works, and
suddenly it doesn't remember your password. There's nothing I can do
about this. If you find why it forgets your password, then I may be able
to do something.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On 17/07/2012 07:57, Guillaume Lelarge wrote:
> On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote:
>> So what Should I do? Tons of thanks!
>>
> 
> Please, send the emails to the mailing list, not only me.
> 
> What should you do? I have no idea. All I know is that it works, and
> suddenly it doesn't remember your password. There's nothing I can do
> about this. If you find why it forgets your password, then I may be able
> to do something.

Passwords are stored on Windows under <your home
directory>/AppData/Roaming/postgresql/pgpass.conf - could something be
deleting it behind your back?

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Thank you Ray.

There isn't any file named pgpass.conf in my computer after my searching attempt. Is there any other reasons?
And is there a way that I delete in a clean way and resintall it?

Regards,

Naixian (Nancy) Zhang
Product Specialist | Global Client Solutions
Revere Data
60 East 42nd Street, Suite 716
New York, NY 10165
Office: (212) 405 3980 x210
Mobile: (216) 533 7395
www.reveredata.com

-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie]
Sent: Tuesday, July 17, 2012 8:00 AM
To: Guillaume Lelarge
Cc: Zhang, Nancy; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

On 17/07/2012 07:57, Guillaume Lelarge wrote:
> On Mon, 2012-07-16 at 21:59 +0000, Zhang, Nancy wrote:
>> So what Should I do? Tons of thanks!
>>
>
> Please, send the emails to the mailing list, not only me.
>
> What should you do? I have no idea. All I know is that it works, and
> suddenly it doesn't remember your password. There's nothing I can do
> about this. If you find why it forgets your password, then I may be
> able to do something.

Passwords are stored on Windows under <your home
directory>/AppData/Roaming/postgresql/pgpass.conf - could something be
deleting it behind your back?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and/or
CONFIDENTIAL.This email is intended only for the personal and confidential use of the recipient(s) named above. If the
readerof this email is not an intended recipient, or you have received this email in error, you are hereby advised that
anyreview, dissemination, distribution or copying is strictly prohibited. If you have received this email in error,
pleasenotify the sender immediately by return mail and permanently delete the copy you received.
 

On 17/07/2012 14:14, Zhang, Nancy wrote:
> Thank you Ray.
> 
> There isn't any file named pgpass.conf in my computer after my
> searching attempt. Is there any other reasons? And is there a way
> that I delete in a clean way and resintall it?

If there's no pgpass.conf file, then that's why you're being asked for
your password - it hasn't been saved.

You should try entering the password and ticking the box to save it, and
see if the pgpass.conf gets created. If it doesn't, you need to figure
out why (permissions maybe?). If it does get created, and then is
deleted at a later point, you need to find out what's deleting it; from
what I understand it's unlikely to be pgAdmin.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 17/07/2012 17:37, Raymond O'Donnell wrote:
> On 17/07/2012 14:14, Zhang, Nancy wrote:
>> Thank you Ray.
>>
>> There isn't any file named pgpass.conf in my computer after my
>> searching attempt. Is there any other reasons? And is there a way
>> that I delete in a clean way and resintall it?
> 
> If there's no pgpass.conf file, then that's why you're being asked for
> your password - it hasn't been saved.
> 
> You should try entering the password and ticking the box to save it, and
> see if the pgpass.conf gets created. If it doesn't, you need to figure
> out why (permissions maybe?). If it does get created, and then is
> deleted at a later point, you need to find out what's deleting it; from
> what I understand it's unlikely to be pgAdmin.

One other though - did someone maybe change the password on the server?
- i.e. the PostgreSQL server?

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie