Either create user "adam" in the database, or create the crontab entry under
a unix user that already has access to the database. I routinely run my
backups as the "postgres" user to ensure that I don't miss anything.
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Daniel Ostroff
Sent: Monday, February 17, 2003 5:18 PM
Subject: [ADMIN] Unable to run pg_dump from crontab
I'm trying to run a pg_dump under Crontab (FreeBSD is the OS).
The command line is:
/usr/home/jwilbur/usr/local/bin/pg_dump ShopCart >
I am getting the following message:
pg_dump: [archiver (db)] connection to database "ShopCart" failed: FATAL 1:
user "adam" does not exist
What can I do to correct this?
In response to
pgsql-admin by date
|Next:||From: Laurette Cisneros||Date: 2003-02-18 17:39:56|
|Subject: Re: server won't shutdown |
|Previous:||From: Tom Lane||Date: 2003-02-18 15:28:59|
|Subject: Re: ServerLoop |