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

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 (view raw or flat)
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

pgsql-admin by date

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

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