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	February 18, 2003 15:23:48
Msg-id	001201c2d6d2$6b712a90$d378c7d4@oats Whole thread Raw
Responses	Re: Unable to run pg_dump from crontab
List	pgsql-admin

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

From: yusuf0478@netscape.net (David Wendy)
Date: 18 February 2003, 15:23:47
Subject: log file maintenance

From: Ed Loehr
Date: 18 February 2003, 15:23:50
Subject: Re: please help--database just locks up.