Trouble dumping "backing up" in 7.1.3

Поиск
Список
Период
Сортировка
Искать

Trouble dumping "backing up" in 7.1.3

От:
Michael Sheldon <michael.sheldon@verizon.net>
Дата:
As you can probably figure out by now I want to back up my databases so 
that I can upgrade to the latest version of PGSQL for a number of reasons.

I am having trouble though. See example below.

bash$ pg_dumpall > backup.data
getAggregates(): SELECT failed.  Explanation from backend: 'ERROR: 
Attribute 'aggtransfn1' not found
'.
pg_dump failed on postgres, exiting
bash$



Any help would be greatly appresheated. I am using PG_DUMP


Re: Trouble dumping "backing up" in 7.1.3

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Michael Sheldon  writes:
> bash$ pg_dumpall > backup.data
> getAggregates(): SELECT failed.  Explanation from backend: 'ERROR: 
> Attribute 'aggtransfn1' not found
> '.

This looks like a problem with using an older (7.0?) pg_dump against a
newer database.  Check your PATH to see which pg_dump is getting invoked
...

			regards, tom lane
FAQ