Re: packaging Postgres binary dump files
On 09/20/2013 06:18 PM, Daniel Pocock wrote:
> To go the other way (from an ASCII SQL into a binary dump file) during
> the package build phase, it needs to be loaded into a running PostgreSQL
> server and then extracted with pg_dump. I don't think that is a great
> build dependency, especially if we want to support things like chroot
> builds.
I don't think you should distribute the files in the binary format at all as
you'd have to require a pg_restore which is able to restore the files from
pg_dump in the version you've used to package it - so while it might be possible
that the ascii version just works well for older postgres versions, you might
end up with needed pg_restore form 9.x just becuase you dumped it with it.
--
Bernd Zeimetz Debian GNU/Linux Developer
http://bzed.de http://www.debian.org
GPG Fingerprint: ECA1 E3F2 8E11 2432 D485 DD95 EB36 171A 6FF9 435F
Reply to: