Re: pg_dump --split patch

From: Marko Tiikkaja <pgmail(at)joh(dot)to>
To: Joel Jacobson <joel(at)gluefinance(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump --split patch
Date: 2012-10-22 11:33:42
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Now that the (at least as far as I know) last ordering problem in
pg_dump has been solved [1], I'm going to attempt resurrecting this old

It seemed to me that the biggest objections to this patch in the old
discussions were directed at the implementation, which I have tried to
improve. The attached patch implements the actual splitting in a new
backup format.

The general output scheme looks like this:

but there are some exceptions.

Overloaded functions are dumped into the same file. Object names are
encoded into the POSIX Portable Filename Character Set ([a-z0-9._-]) by
replacing any characters outside that set with an underscore.

Restoring the dump is supported through an index.sql file containing
statements which include (through \i) the actual object files in the
dump directory.

Any thoughts? Objections on the idea or the implementation?


Marko Tiikkaja

Attachment Content-Type Size
pg_dump_split_v2.patch text/plain 34.8 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-10-22 11:53:30 Re: Deprecating RULES
Previous Message Amit Kapila 2012-10-22 08:39:28 Re: [WIP PATCH] for Performance Improvement in Buffer Management