Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-19 Thread Jasen Betts
On 2009-02-10, Inigo Barandiaran wrote: > > Hi. > > I would like to create an script that includes calls to createdb.exe and > psql.exe. I would like to use them with a user but without asking or > prompting for pasword. For example: > createdb.exe -T template0 -U MyPosgresUser MyDataBaseName. >

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-11 Thread Inigo Barandiaran
Hi Dennis, all. You are right. I know that sounds stupid, but the problem why the environment variable didn't work was due that 'P' :). I don't know why but I didn't realize that I was writing the name of the variable wrong :S Now, I've tried both options and both works correctly. I think for the

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-11 Thread Dennis Brakhane
On Tue, Feb 10, 2009 at 7:04 PM, Inigo Barandiaran wrote: > I've read that if I define an environment variable like SET > PGPPASSWORD=MyPosgresUserPassword, both calls dont ask for password. I've > tested this variable in different platforms and does not work. > Do you know how so solve it? As yo

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-11 Thread Richard Huxton
Iñigo Barandiaran wrote: > 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 > > /*/:/*//

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Iñigo Barandiaran
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

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Raymond O'Donnell
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

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Sam Mason
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

Fwd: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Iñigo Barandiaran
Thanks Raymon. I'm using Windows XP. What does "visible to the script" means? Thanks in advance! Best, On 10/02/2009 18:04, Inigo Barandiaran wrote: I would like to create an script that includes calls to createdb.exe and psql.exe. I would like to use them with a user but without asking o

Fwd: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Iñigo Barandiaran
Thanks Raymon. I'm using Windows XP. What does "visible to the script" means? Thanks in advance! Best, On 10/02/2009 18:04, Inigo Barandiaran wrote: I would like to create an script that includes calls to createdb.exe and psql.exe. I would like to use them with a user but without asking

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Iñigo Barandiaran
Thanks Raymon. I'm using Windows XP. What does "visible to the script" means? Thanks in advance! Best, On 10/02/2009 18:04, Inigo Barandiaran wrote: I would like to create an script that includes calls to createdb.exe and psql.exe. I would like to use them with a user but with

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Raymond O'Donnell
On 10/02/2009 18:04, Inigo Barandiaran wrote: > I would like to create an script that includes calls to createdb.exe and > psql.exe. I would like to use them with a user but without asking or > prompting for pasword. For example: > createdb.exe -T template0 -U MyPosgresUser MyDataBaseName. > > I

Re: [GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Richard Huxton
Inigo Barandiaran wrote: > Hi. > > I would like to create an script that includes calls to createdb.exe and > psql.exe. I would like to use them with a user but without asking or > prompting for pasword. For example: > createdb.exe -T template0 -U MyPosgresUser MyDataBaseName. http://www.postgre

[GENERAL] createdb.exe and psql.exe without Promting Password

2009-02-10 Thread Inigo Barandiaran
Hi. I would like to create an script that includes calls to createdb.exe and psql.exe. I would like to use them with a user but without asking or prompting for pasword. For example: createdb.exe -T template0 -U MyPosgresUser MyDataBaseName. I've read that if I define an environment variable lik