the name of env var is PGPASSWORD http://www.network-theory.co.uk/docs/postgresql/vol2/EnvironmentVariables1.h tml Viel Gluck Martin- ----- Original Message ----- From: "Marten Lehmann" <lehmann@xxxxxx> To: <pgsql-general@xxxxxxxxxxxxxx> Sent: Thursday, January 10, 2008 6:48 PM Subject: Re: How to automate password requests? > Hello, > > >> TIP 5: don't forget to increase your free space map settings > > Read about something called the .pgpass file. There's a way to set a > > file that contains the password (pgAdmin will create one autmoatically) > > that pgsql will look for before it asks for your password. It's stored > > in ~/ > > > > The solution I use is a bat file that redefines an environment variable > > (PGPASSFILE) that points to the file, then runs pg_dumpall. > > is there no way to specify the password directly? I don't like to create > a separate file because all config is done in a shell script. I could > set a certain environment variable with the password, but does pgadmin > read a password from such a variable? If yes, what is its name? > > Regards > Marten > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
