Postgres Pro
Downloads
Home   >   mailing lists

Thread: Unable to run pg_dump from crontab

Unable to run pg_dump from crontab

From
"Daniel Ostroff"
Date:
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

Re: Unable to run pg_dump from crontab

From
"Nick Fankhauser"
Date:
Dan-

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.

-Nick
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Daniel Ostroff
Sent: Monday, February 17, 2003 5:18 PM
To: pgsql-admin@postgresql.org
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 >
~/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

Re: Unable to run pg_dump from crontab

From
Robert Treat
Date:
The other option is to use pg_dump's -U flag to specify the user you
want to connect to the database as. See the pg_dump page in the docs for
more info.

Robert Treat

On Tue, 2003-02-18 at 12:29, Nick Fankhauser wrote:
> Dan-
>
> 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.
>
> -Nick
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Daniel Ostroff
> Sent: Monday, February 17, 2003 5:18 PM
> To: pgsql-admin@postgresql.org
> 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 >
> ~/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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org