Thread: ...
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/
> 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
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/
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