X-Original-To: pgsql-admin@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 6CA82475E91
	for <pgsql-admin@postgresql.org>; Fri, 18 Apr 2003 14:56:00 -0400 (EDT)
Received: from proteus.affordablehost.com (unknown [216.46.203.177])
	by postgresql.org (Postfix) with SMTP id 72720475458
	for <pgsql-admin@postgresql.org>; Fri, 18 Apr 2003 14:55:59 -0400 (EDT)
Received: (qmail 13294 invoked from network); 18 Apr 2003 18:55:58 -0000
Received: from unknown (HELO e-greek.net) (66.92.74.181)
	by 216.46.203.177 with SMTP; 18 Apr 2003 18:55:58 -0000
Message-ID: <3EA04A42.8050604@e-greek.net>
Date: Fri, 18 Apr 2003 14:56:02 -0400
From: Andrew Biagioni <andrew.biagioni@e-greek.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
Cc: hetzel.devel@web.de, pgsql-admin@postgresql.org
Subject: Re: <no subject>
References: <Pine.LNX.4.44.0304091513480.1293-100000@Bhuvan.bksys.co.in>
In-Reply-To: <Pine.LNX.4.44.0304091513480.1293-100000@Bhuvan.bksys.co.in>
Content-Type: multipart/alternative;
	boundary="------------070806060007010007040507"
X-Spam-Status: No, hits=-33.2 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,HTML_20_30,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/260
X-Sequence-Number: 8415

This is a multi-part message in MIME format.
--------------070806060007010007040507
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

 From PostgreSQL 7.3.1 Documentation, section 1.10. Environment Variables:

PGPASSWORD sets the password used if the backend demands password 
authentication. _This functionality is deprecated for security reasons_; 
consider migrating to use the $HOME/.pgpass 
<libpq-files.html#PGPASSFILE> file.

See Victor Yegorov's response (he also recommends .pgpass) and section 
1.11. Files for details.

       Andrew

A.Bhuvaneswaran wrote:

>>local all md5
>>
>>If I want to make a dump with pg_dump, I have to insert the password. 
>>But I can't make a Cron-Job because I always have to insert the password!!
>>Is there any way to do this automatic?
>>    
>>
>
>PGPASSWORD environment variable can be used.
>
>regards,
>bhuvaneswaran
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>  
>

--------------070806060007010007040507
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body>
From PostgreSQL 7.3.1 Documentation, section 1.10. Environment
Variables:<br>
<p><tt class="ENVAR">PGPASSWORD</tt> sets the password used if the
backend demands password authentication. <u>This functionality is
deprecated for security reasons</u>; consider migrating to use the <a
 href="libpq-files.html#PGPASSFILE"><tt class="FILENAME">$HOME/.pgpass</tt></a>
file.</p>
See Victor Yegorov's response (he also recommends .pgpass) and section
1.11. Files for details.<br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  Andrew<br>
<br>
A.Bhuvaneswaran wrote:<br>
<blockquote type="cite"
 cite="midPine.LNX.4.44.0304091513480.1293-100000@Bhuvan.bksys.co.in">
  <blockquote type="cite">
    <pre wrap="">local all md5

If I want to make a dump with pg_dump, I have to insert the password. 
But I can't make a Cron-Job because I always have to insert the password!!
Is there any way to do this automatic?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
PGPASSWORD environment variable can be used.

regards,
bhuvaneswaran


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to <a class="moz-txt-link-abbreviated" href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>


  </pre>
</blockquote>
</body>
</html>

--------------070806060007010007040507--