--00032555b6469d1364048c78f024
Content-Type: text/plain; charset=ISO-8859-1
I hope the method with the environment variables will hold on.
For security reasons it is much better to use the variable method with
PGPASSWORD. I can set the environment hidden from any user by a program.
The .pgpass is readable for any admin, opposed to the statement in the docs:
"On Microsoft Windows, it is assumed that the file is stored in a directory
that is secure, so no special permissions check is made."
Regards
Walter
On Wed, Jul 28, 2010 at 1:02 AM, Scott Marlowe <scott.marlowe [at] gmail.com>wrote:
> However, those are deprecated, and the .pgpass is considered the
> preferred method.
>
> On Tue, Jul 27, 2010 at 3:56 PM, Walter Willmertinger <willmis [at] gmail.com>
> wrote:
> > You can set user and password with environment variables (PGUSER and
> > PGPASSWORD) , also in a Windows batch or program.
> > SET PGPASSWORD=xxxyyyzzz
> > psql -U "dbadmin" -d mydb -f D:\script.sql
> >
> >
> >
> > Regards
> >
> > Walter
> >
> >
> > On Tue, Jul 27, 2010 at 6:53 PM, <Steve.Toutant [at] inspq.qc.ca> wrote:
> >>
> >> Hi,
> >> I created several SQL that are automatically executed via windows task
> >> scheduler, here is an example
> >> psql -U "dbadmin" -d mydb -f D:\script.sql
> >>
> >> It was running well until I changed the user (to open a session)
> >> associated to these task.
> >> The script prompt for a password for user dbadmin.
> >>
> >> How to avoid that? I guess there is a config so dbadmin will "trust"
> this
> >> new user....
> >>
> >> Thanks for your help,
> >>
> >> Steve
> >
>
>
>
> --
> To understand recursion, one must first understand recursion.
>
--00032555b6469d1364048c78f024
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<span class=3D"Apple-style-span" style=3D"font-family: arial, sans-serif; f=
ont-size: 13px; border-collapse: collapse; ">I hope the method with the env=
ironment variables will hold on.<div><br></div><div>For security reasons it=
is much better to use the variable method with PGPASSWORD. I can set the e=
nvironment hidden from any user by a program.</div>
<div>The .pgpass is readable for any admin, opposed to the statement in the=
docs: "<span style=3D"font-family: verdana, sans-serif; font-size: 12=
px; line-height: 18px; ">On Microsoft Windows, it is assumed that the file =
is stored in a directory that is secure, so no special permissions check is=
made."</span></div>
<div><br clear=3D"all">Regards</div></span>Walter<br>
<br><br><div class=3D"gmail_quote">On Wed, Jul 28, 2010 at 1:02 AM, Scott M=
arlowe <span dir=3D"ltr"><<a href=3D"mailto:scott.marlowe [at] gmail.com">sco=
tt.marlowe [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
;">
However, those are deprecated, and the .pgpass is considered the<br>
preferred method.<br>
<div><div></div><div class=3D"h5"><br>
On Tue, Jul 27, 2010 at 3:56 PM, Walter Willmertinger <<a href=3D"mailto=
:willmis [at] gmail.com">willmis [at] gmail.com</a>> wrote:<br>
> You can set user and password with environment variables (PGUSER and<b=
r>
> PGPASSWORD) , also in a Windows batch or program.<br>
> SET PGPASSWORD=3Dxxxyyyzzz<br>
> psql -U "dbadmin" -d mydb -f D:\script.sql<br>
><br>
><br>
><br>
> Regards<br>
><br>
> Walter<br>
><br>
><br>
> On Tue, Jul 27, 2010 at 6:53 PM, <<a href=3D"mailto:Steve.Toutant [at] i=
nspq.qc.ca">Steve.Toutant [at] inspq.qc.ca</a>> wrote:<br>
>><br>
>> Hi,<br>
>> I created several SQL that are automatically executed via windows =
task<br>
>> scheduler, here is an example<br>
>> psql -U "dbadmin" -d mydb -f D:\script.sql<br>
>><br>
>> It was running well until I changed the user (to open a session)<b=
r>
>> associated to these task.<br>
>> The script prompt for a password for user dbadmin.<br>
>><br>
>> How to avoid that? I guess there is a config so dbadmin will "=
;trust" this<br>
>> new user....<br>
>><br>
>> Thanks for your help,<br>
>><br>
>> Steve<br>
><br>
<br>
<br>
<br>
</div></div><font color=3D"#888888">--<br>
To understand recursion, one must first understand recursion.<br>
</font></blockquote></div><br>
--00032555b6469d1364048c78f024--
