pg_dump custom format specification
Someone has some kind of specification or description of the pg_dump
custom format?
What I'm trying to do is an utility to remotelly syncronize postgresql
dumps, using lib_rsync to syncronize each table independently and
copying blobs only when sizes differ.
I've made the same using the Tar format, but I think most of the
features and optimizations like paralell-restore are now only available
with the custom format.
I will do the script in Python, so, I need to know how to parse and
write pg_dumps in custom format.
Thanks in advance.
--
Guillermo M. Narvaja
Lambda Sistemas S.R.L.
www.fierro-soft.com.ar
Tel: (5411) 4139-0493/4
Cel: (5411) 15-6783-4435
Email: guillermo.narvaja@fierro-soft.com.ar
MSN: guillermo_narvaja@hotmail.com
Skype: guillermonarvaja
Lavalleja 519 1er Piso - Ciudad de Buenos Aires - Argentina
On 01/21/2012 07:44 AM, Guillermo M. Narvaja wrote:
Someone has some kind of specification or description of the pg_dump
custom format?What I'm trying to do is an utility to remotelly syncronize postgresql
dumps, using lib_rsync to syncronize each table independently and
copying blobs only when sizes differ.I've made the same using the Tar format, but I think most of the
features and optimizations like paralell-restore are now only available
with the custom format.I will do the script in Python, so, I need to know how to parse and
write pg_dumps in custom format.
You might find this useful: <https://gist.github.com/1258232> It's a
perl script that parses and prints out the header and TOC of a custom
format dump.
cheers
andrew