Thread: Error on pg_dump

Hello,

When I run pg_dump from a shell script called from cron, I get the following
error for each invocation of pg_dump:

getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:
Attribute 'aggtransfn1' not found
'.

But when I run the script from the command line, it works fine.  PG version
is 7.1.2, OS is Linux, and no backup happens when I get this error (the
files are created bu their size is 0).  If it helps, the shell script is
below.  Thanks,

-- Jeremy  [jeremy@wellsgaming.com]


#!/usr/bin/bash

DATE_NUM=`date +%w`
sync
pg_dump data1 > /foo/$DATE_NUM/data1.db
sync
pg_dump data2 > /foo/$DATE_NUM/data2.db
sync
pg_dump data3 > /foo/$DATE_NUM/data3.db
sync

Jeremy Buchmann <jeremy@wellsgaming.com> writes:
> getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:
> Attribute 'aggtransfn1' not found

> But when I run the script from the command line, it works fine.  PG version
> is 7.1.2,

You're invoking a pre-7.1 pg_dump.  Check the PATH used by your script.

            regards, tom lane

what this mean??
pq_recvbuf: recv() failed: Connection reset by peer
keep comming out.

how to fix it??

OS: FreeBSD-4.3
DB: Postgres-7.1.2


Thanks.

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Mon, 18 Jun 2001, Tom Lane wrote:

> Jeremy Buchmann <jeremy@wellsgaming.com> writes:
> > getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:
> > Attribute 'aggtransfn1' not found
>
> > But when I run the script from the command line, it works fine.  PG version
> > is 7.1.2,
>
> You're invoking a pre-7.1 pg_dump.  Check the PATH used by your script.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>