Postgres Pro
Downloads
Home   >   mailing lists

Unable to run pg_dump from crontab - Mailing list pgsql-admin

From Daniel Ostroff
Subject Unable to run pg_dump from crontab
Date
Msg-id 001201c2d6d2$6b712a90$d378c7d4@oats
Whole thread Raw
Responses Re: Unable to run pg_dump from crontab  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
Tree view
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 > ~/usr/local/shopcart/backup/ShopCart.pgdump
 
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?
 
Thanks,
 
/Dan

pgsql-admin by date:

Previous
From: yusuf0478@netscape.net (David Wendy)
Date:
Subject: log file maintenance
Next
From: Ed Loehr
Date:
Subject: Re: please help--database just locks up.