På tirsdag 08. mars 2016 kl. 15:43:37, skrev Adrian Klaver < adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 03/08/2016 01:53 AM, Andreas Joseph Krogh wrote: > Hi all. > Is there a way to exclude pg_largeobject from pg_dump? -T pg_largeobject > doesn't work. I've tried to exclude tables using OID-datatype also but > that didn't work either.
Well pg_largeobject is a system catalog so pretty sure it cannot be excluded. What tables are you trying to exclude with OID? Do you care about not dumping the pg_largeobject table or not dumping the data it contains? I have several tables with OID-columns and I'd like to dump my DB without any data in pg_largeobject (> 95% of the space is occupied by data in pg_largeobject). I've tried to exclude (using -T) the tables containing OID-columns but pg_largeobject is still dumped containing the data it seems. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
