Re: createdb.exe and psql.exe without Promting Password

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Sam Mason <sam(at)samason(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: createdb.exe and psql.exe without Promting Password
Date: 2009-02-10 22:25:56
Message-ID: 4991FEF4.1060105@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Pasher 2009-02-10 22:43:36 Continual increase of age(datfrozenxid) for template0
Previous Message Max Strömberg 2009-02-10 22:19:13 In need of help with message fetching query