Thread: ...

...

From
"filipe paiva"
Date:
Hi there,

I want to write a script where I can create a database automatically. This
is intended to create a database during the installation of an application
I'm currently develloping. So, I (or the end-user of my app) can't be
prompted for the postgres password during the app installation.
I already found that it's possible to store passwords in the file
pgpass.conf in the %APPDATA% directory. But that file isn't stored in that
location. In fact it doesn't exist in my disk. I already checked the "Store
password" option in the pgadmin and I already checked in the pgadmin's
pgpass.conf menu entry that the password is stored. But where?

Can you help me?

Greetings,

Filipe Paiva

_________________________________________________________________
Partilhe ficheiros sem depender de pombos-correios!
http://www.communicationevolved.com/pt-pt/


Re:

From
Joshua Kramer
Date:
> I already found that it's possible to store passwords in the file pgpass.conf
> in the %APPDATA% directory. But that file isn't stored in that location. In
> fact it doesn't exist in my disk. I already checked the "Store password"

Filipe,

You need to create that file yourself.  Using the format you found in the
documentation, you can put your login information in the .pgpass file in
the user's home directory, or under windows it's under
"%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the
Application Data subdirectory in the user's profile)." [1]

Hope that helps!


Cheers,
-J

[1] http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html


...

From
"filipe paiva"
Date:
I already had done this but it seems the "Store password" function stores
the password in a file other than the pgpass.conf because it really stores
passwords with or without that file.

Can anyone tell me if it is possible to set the "Store password" option in a
file? Because if it isn't possible I should give up to look for the way the
passwords are stored...


>From: Joshua Kramer <josh@globalherald.net>
>To: filipe paiva <fmfpaiva@hotmail.com>
>CC: pgsql-bugs@postgresql.org, pgsql-admin@postgresql.org
>Subject: Re: [ADMIN]
>Date: Wed, 23 May 2007 10:35:35 -0400 (EDT)
>
>
>>I already found that it's possible to store passwords in the file
>>pgpass.conf in the %APPDATA% directory. But that file isn't stored in that
>>location. In fact it doesn't exist in my disk. I already checked the
>>"Store password"
>
>Filipe,
>
>You need to create that file yourself.  Using the format you found in the
>documentation, you can put your login information in the .pgpass file in
>the user's home directory, or under windows it's under
>"%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the
>Application Data subdirectory in the user's profile)." [1]
>
>Hope that helps!
>
>
>Cheers,
>-J
>
>[1] http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html
>

_________________________________________________________________
Partilhe ficheiros sem depender de pombos-correios!
http://www.communicationevolved.com/pt-pt/


Re:

From
"Vishal Arora"
Date:
If you are using windows, it's under "%APPDATA%\postgresql\pgpass.conf"
(where %APPDATA% refers to the Application Data subdirectory in the windows
user's profile and not the postgres user.


>From: "filipe paiva" <fmfpaiva@hotmail.com>
>To: pgsql-admin@postgresql.org
>CC: pgsql-bugs@postgresql.org
>Subject: [ADMIN]
>Date: Thu, 24 May 2007 07:09:56 +0100
>
>I already had done this but it seems the "Store password" function stores
>the password in a file other than the pgpass.conf because it really stores
>passwords with or without that file.
>
>Can anyone tell me if it is possible to set the "Store password" option in
>a file? Because if it isn't possible I should give up to look for the way
>the passwords are stored...
>
>
>>From: Joshua Kramer <josh@globalherald.net>
>>To: filipe paiva <fmfpaiva@hotmail.com>
>>CC: pgsql-bugs@postgresql.org, pgsql-admin@postgresql.org
>>Subject: Re: [ADMIN]
>>Date: Wed, 23 May 2007 10:35:35 -0400 (EDT)
>>
>>
>>>I already found that it's possible to store passwords in the file
>>>pgpass.conf in the %APPDATA% directory. But that file isn't stored in
>>>that location. In fact it doesn't exist in my disk. I already checked the
>>>"Store password"
>>
>>Filipe,
>>
>>You need to create that file yourself.  Using the format you found in the
>>documentation, you can put your login information in the .pgpass file in
>>the user's home directory, or under windows it's under
>>"%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the
>>Application Data subdirectory in the user's profile)." [1]
>>
>>Hope that helps!
>>
>>
>>Cheers,
>>-J
>>
>>[1] http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html
>>
>
>_________________________________________________________________
>Partilhe ficheiros sem depender de pombos-correios!
>http://www.communicationevolved.com/pt-pt/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org

_________________________________________________________________
PC Magazine�s 2007 editors� choice for best Web mail�award-winning Windows
Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507