pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Biagioni <andrew.biagioni@e-greek.net>
To: A.Bhuvaneswaran <bhuvansql@myrealbox.com>
Cc: hetzel.devel@web.de
Cc: pgsql-admin@postgresql.org
Subject: Re: <no subject>
Date: Fri, 18 Apr 2003 14:56:02 -0400
Message-ID: <3EA04A42.8050604@e-greek.net> (raw)
In-Reply-To: <Pine.LNX.4.44.0304091513480.1293-100000@Bhuvan.bksys.co.in>
References: <Pine.LNX.4.44.0304091513480.1293-100000@Bhuvan.bksys.co.in>

 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
>
>
>  
>

view thread (8+ messages)  latest in thread

Message-ID: <3EA04A42.8050604@e-greek.net>
Permalink:  ../3EA04A42.8050604@e-greek.net/
Also on:    postgresql.org/message-id/3EA04A42.8050604@e-greek.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: andrew.biagioni@e-greek.net, bhuvansql@myrealbox.com, hetzel.devel@web.de
  Subject: Re: <no subject>
  In-Reply-To: <3EA04A42.8050604@e-greek.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox