Thank you all!
and Thanks Sam for the explanation about environment variable. I didn't
know about that :)
I've also tried the option of .pgpass file, that as far as I understand
in Windows is pgpass.conf. I did a file containing only this line
/*/:/*///:/*///:/MyPostgres///User/:MyPostgres://Password
/I put this file in:
c:\MyPosgreInstalation and
c:\MyPosgreInstalation\bin and
c:\MyPosgreInstalation\data and
C:\Documents and Settings\postgres\Application Data\
all without success. What I'm doing wrong? When I try to execute createdb.exe -T template0 -U MyPostgres MyDataBase always ask for password.
I'm running Windows XP 32 bit.
Thanks in advance for your support.
Best,
On 10/02/2009 21:47, Sam Mason wrote:
On Tue, Feb 10, 2009 at 07:22:24PM +0100, IIIigo Barandiaran wrote:
What does "visible to the script" means?
Each command interpreter has its own set of variables; you need to set
them in the correct one. For example, starting one copy of "cmd" and
typing "SET var=value" and then closing it and starting another one and
running your "script" won't work because they are different interpreters
(i.e. different instances, or processes, of the same executable, or
program).
If you're executing "SET ..." in one command interpreter and then double
clicking on your script (a .bat file?) then you're effectively starting
another interpreter on that one script, it will exit when it's reached
the end of your script.
I couldn't have put it better! :-) You could create a system-wide
environment variable via right-clicking on My Computer, selecting
properties, then clicking "Environment variables" - but this is a
*really* bad idea for storing a password, as it's visible to anyone
using the computer. Far better to use the .pgpass file.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
