Skip site navigation (1) Skip section navigation (2)

pg_dumpall forces plain text format

From: Andrew Kohlsmith <akohlsmith(at)mixdown(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dumpall forces plain text format
Date: 2002-07-11 03:04:08
Message-ID: 200207102304.08584@-mixdown.ca (view raw or flat)
Thread:
Lists: pgsql-bugs
I was trying to do a data+lo dump using pg_dumpall:

pg_dumpall -C -a -b -o -Ft > dumptest.data

Unfortunately I kept getting this error:

pg_dump: large object output is not supported for plain text dump files.
pg_dump: (Use a different output format.)

Upon looking at the pg_dumpall shell script I found out why:

PGDUMP="${PGPATH}/pg_dump $connectopts $pgdumpextraopts -Fp"

Is there a particular reason why plain text is forced?  Could this be removed 
in the next version?  Or even moved to a pg_dumpall command line option?  I 
really dislike using nonstandard tools.

Regards,
Andrew

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-07-11 09:43:26
Subject: Bug #708: PgTransaction class is broken since 7.2
Previous:From: Bruce MomjianDate: 2002-07-11 02:50:21
Subject: Re: Bug #706: Wrong shlib flag for GCC compilation on Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group