Re: Automated backup problems - pg_dump

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Jesse Burkhardt <jesse(at)skybuilders(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 07:40:18
Message-ID: 20030825003812.G79187-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2003-08-25 08:39:42 Re: Automated backup problems - pg_dump
Previous Message Jeff Boes 2003-08-25 02:16:32 Re: Disk Utilization Increases And Time for Vacuum Increases.