Thread: Problem with pgdump_all

Problem with pgdump_all

From
Márcio A. Sepp
Date:
 
Hellow,
 
 
I'm using postgresql 8.02 in a OpenBSD 3.6 system. And since the 8.x.x version I had some problems with pgdump_all.
Yesterday I've installed in a new machine, with kernel and ports up-to-date and the problem as happened again.
 
 
-bash-3.00$ pg_dumpall >> /tmp/arquivo
pg_dumpall: query failed: ERROR:  column "datpath" does not exist
pg_dumpall: query was: SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath, datacl FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn ORDER BY 1
 
The postgresql does not have any data. I only have installed it and then I try to make backup.
 
The machine is running OpenBSD 3.6 in a i386 with 1 processor and 512 Mb of memory.
 
 
 
Best regards,
 
 
 
Márcio A. Sepp
ICQ: 162258623
MSN: marciosepp@hotmail.com
Fones (049) 444-4591
          (049) 9918-8641

Re: Problem with pgdump_all

From
Tom Lane
Date:
"Márcio A. Sepp" <marcio@zyontecnologia.com.br> writes:
> I'm using postgresql 8.02 in a OpenBSD 3.6 system. And since the 8.x.x =
> version I had some problems with pgdump_all.=20

> -bash-3.00$ pg_dumpall >> /tmp/arquivo
> pg_dumpall: query failed: ERROR:  column "datpath" does not exist

You're trying to use a pre-8.0 pg_dumpall ...
        regards, tom lane