creating a dump
Hello,
I try to dump my databases using pg_dumpall or pg_dump and I get the following error:
\connect bic postgres
getAggregates(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'aggtransfn1' not found
'.
pg_dump failed on bic, exiting
I tried to fiddle around with the privileges, granted public access to the database to no avail.
Any clues why this happens?
BTW, I would like a cron job to periodically dump out the data in a restorable form.
Best Regards,
Hegyvari Krisztian
"Hegyvari Krisztian" <Hegyvari.Krisztian@ardents.hu> writes:
I try to dump my databases using pg_dumpall or pg_dump and I get the following error:
\connect bic postgres
getAggregates(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'aggtransfn1' not found
'.
I think you are trying to use a 7.0 or older pg_dump against a 7.1 or
newer database. Or maybe it was 7.2 where we changed the layout of
pg_aggregate. Anyway, this is a version skew problem.
(Newer versions of pg_dump do complain if the server version isn't one
they recognize, btw. But you are invoking an old one :-()
regards, tom lane