XataX
Xata3mo ago
xSupeFly

pg_dump running out of memory

Hello, I'm having problem exporting whole database of around 270mb using pg_dump command.

command used: pg_dump --no-acl --no-owner --no-table-access-method --schema-only --format=tar --schema=public

used without --schema-only same error

pg_dump: error: query failed: ERROR: out of memory
DETAIL: Failed on request of size 32768. (8192)
CONTEXT: SQL expression "num NOT IN (SELECT oid FROM "xata.pg_catalog".pg_class)"

@cmck
Was this page helpful?