That did, Jeff! Fantastic!
*:5432:canon:postgres:winkwink <- no good
*:5432:*:postgres:winkwink <- works!
Many thanks to Jeff and everybody else who
stayed with me to see the end of this saga.
I appreciate it wholeheartedly.
From: Jeff Frost [mailto:jeff(at)frostconsultingllc(dot)com]
Sent: Wed 2/27/2008 8:45 PM
To: Tena Sakai
Subject: RE: [ADMIN] trouble with pg_dumpall
On Wed, 27 Feb 2008, Tena Sakai wrote:
> Hi Jeff,
>> What does your .pgpass look like?
There's the problem. That says, any host, port 5432, canon database, postgres
user, password. But pg_dumpall needs to connect to all the databases
including template1 and postgres DBs. Change the 'canon' to '*' and I bet it
will be fine.
>> What OS user are you running the cron job as?
> User postgres.
>> Do you have SELINUX enabled?
> I have no idea what SELINUX is.
>> Can you run the script with the strace command
>> I sent in a previous email so that we can see
>> what's really going on?
> Yes, it is running and I expect it to go for another
> 10 to 15 minutes. I will get your the result asap.
> Thank you for your invariable assistance.
> I am getting excited.
> Tena Sakai
> -----Original Message-----
> From: Jeff Frost [mailto:jeff(at)frostconsultingllc(dot)com]
> Sent: Wed 2/27/2008 8:32 PM
> To: Tena Sakai
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: RE: [ADMIN] trouble with pg_dumpall
> On Wed, 27 Feb 2008, Tena Sakai wrote:
>> Hi Jeff,
>> You cuaght me with a fine point.
>>> but I didn't see HOME being exported.
>> I have changed the script accordingly:
>> And the result/my claim remains the same as before:
>> pg_dumpall: could not connect to database "template1": fe_sendauth: no password supplied
>> I see just one more option. Namely, to change the
>> postgres user entry for pg_hba.conf to "trust" for
>> a short period as pg_dumpall starts and then put it
>> back to the way normally is (md5). I would rather
>> not do that and get .pgpass or PGPASSFILE to work
>> for me.
> I didn't really expect that to make a difference. What does your .pgpass look
> like? What OS user are you running the cron job as? Do you have SELINUX
> enabled? Can you run the script with the strace command I sent in a previous
> email so that we can see what's really going on?
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
In response to
pgsql-admin by date
|Next:||From: Babu, Gabriel Suresh||Date: 2008-02-28 07:02:28|
|Subject: ES7000 Windows 2003 server 64bit processor|
|Previous:||From: Phillip Smith||Date: 2008-02-28 04:52:26|
|Subject: Re: trouble with pg_dumpall|