Unable to run pg_dump from crontab

From: "Daniel Ostroff" <dano(at)livingincomfort(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Unable to run pg_dump from crontab
Date: 2003-02-17 22:17:53
Message-ID: 001201c2d6d2$6b712a90$d378c7d4@oats
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurette Cisneros 2003-02-17 22:56:24 Re: server won't shutdown
Previous Message Mona Gamboa 2003-02-17 22:16:54 please help--database just locks up.