trouble with pg_dumpall

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: trouble with pg_dumpall

Hi Everybody,

I started running 8.3.0 recently on dell hardware
with redhat advanced server 4.

I have a problem with pg_dumpall via crontab.
I had a simple crontab to do the same thing on
8.2.4 and the same thing doesn't work.

Here's my very simple crontab entry:

  xx xx * * * sh /usr/local/pgsql/cron_dir/moo.sh

and moo.sh is eqally simple:
  #! /bin/bash

  . .bashrc

  filename=`date +%G%m%d.%w`.gz
  /usr/local/pgsql/bin/pg_dumpall > $filename

Here's what I get back as output is:

  Password:
  pg_dumpall: could not connect to database "template1": fe_sendauth: no password supplied

This is not what happened on 8.2.4.  I read 8.3.0 man
page on pg_dumpall.  Here's what it told me:

  The file .pgpass in a user's home directory or the file referenced
  by PGPASSFILE can contain passwords to be used if the connection
  requires a password (and no password has been specified otherwise).

I have .pgpass in /usr/local/pgsql and when I type
  psql dbname
It lets me in without asking the password.  So I don't
understand why I get what I get: fe_sendauth: no password supplied

I ran a different cron job which looks like:

  #! /bin/bash

  . .bashrc

  echo PGUSER: $PGUSER
  echo PGDATABASE: $PGDATABASE
  echo PGHOST: $PGHOST
  echo PGPASSFILE: $PGPASSFILE
  echo PGDATA: $PGDATA

and everything it told me checks out with what I get from
interactive session.

Please tell me what I am doing wrong.  I am at the
end of my wits.

Regards,

Tena Sakai
tsakai@xxxxxxxxxxxxxx


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux