Обсуждение: 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
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
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