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
> > Is there a particular reason why plain text is forced?
> Because pg_dumpall is producing a script file.
> This is obviously not optimal, but it's not very clear how to do better.
Agreed. :-)
I notice that pg_dumpall just uses a query to grab a list of databases and
some information about t
> > Or is that on the TODO for whenever foreign keys can be across databases?
> I very seriously doubt that PG will *ever* support foreign keys across
> databases.
No problem. I'm not that advanced of a user or admin to want it, I was just
trying to peer into the crystal ball and try to anticip
