Skip site navigation (1) Skip section navigation (2)

Re: Unable to run pg_dump from crontab

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Daniel Ostroff" <dano(at)livingincomfort(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Unable to run pg_dump from crontab
Date: 2003-02-18 17:29:22
Message-ID: NEBBLAAHGLEEPCGOBHDGGEAPGMAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Daniel Ostroff
Sent: Monday, February 17, 2003 5:18 PM
To: pgsql-admin(at)postgresql(dot)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


In response to

Responses

pgsql-admin by date

Next:From: Laurette CisnerosDate: 2003-02-18 17:39:56
Subject: Re: server won't shutdown
Previous:From: Tom LaneDate: 2003-02-18 15:28:59
Subject: Re: ServerLoop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group