Skip site navigation (1) Skip section navigation (2)

Re: Automated backup problems - pg_dump

From: Jesse Burkhardt <jesse(at)skybuilders(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Automated backup problems - pg_dump
Date: 2003-08-25 19:07:09
Message-ID: 3F4A5E5D.3050502@skybuilders.com (view raw or flat)
Thread:
Lists: pgsql-admin
Yo Stephan,

Thanks. That was the problem: that there is no longer and underscore in 
the pg password env var, PGPASSWORD.

Are you familiar with the Hungarian jazz guitarist Gabo Szabo?

Stephan Szabo wrote:

>On Sun, 24 Aug 2003, Jesse Burkhardt wrote:
>
>  
>
>>I am sure many of you have encountered the problems I am experiencing
>>with automating the pg_dump command from a cron. The problem arises from
>>a failure of this command to use the environmental variable,
>>PG_PASSWORD. (PGUSER, on the other hand, is picked up during command
>>    
>>
>
>I think the environment variable is PGPASSWORD (no underscore) in at least
>7.3 and above.  Also, it's somewhat depricated in favor of using the
>.pgpass file.
>  
>

-- 

 Jesse Burkhardt
 jesse(at)skybuilders(dot)com  (w) 617-876-5680
 goose(at)aerogoose(dot)com    (h) 617-354-5523

In response to

pgsql-admin by date

Next:From: scott.marloweDate: 2003-08-25 19:14:38
Subject: Re: Disk Utilization Increases And Time for Vacuum Increases.
Previous:From: Peter EisentrautDate: 2003-08-25 18:01:09
Subject: Re: System Tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group