Re: packaging Postgres binary dump files

2013-09-23 Thread Jonathan Dowland
Please don't CC me, I'm subscribed to the list. -- To UNSUBSCRIBE, email to debian-devel-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/e3a10ec6-e8d6-4c82-8c0e-523f2931a...@debian.org

Re: packaging Postgres binary dump files

2013-09-23 Thread Jonathan Dowland
On 20 Sep 2013, at 14:49, Paul Tagliamonte paul...@debian.org wrote: I mean, not really, right? I wouldn't write it if I didn't think so. If I want to use a .so, I want the ELF, but I want to modify it in C The classic case we all know well which doesn't map to this situation. This just

Re: packaging Postgres binary dump files

2013-09-23 Thread Jonathan Dowland
Please don't CC me, I'm subscribed to the list. -- To UNSUBSCRIBE, email to debian-devel-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/108274b5-05b0-4a9b-8ee4-54bd1b353...@debian.org

Re: packaging Postgres binary dump files

2013-09-23 Thread Cyril Brulebois
Jonathan Dowland j...@debian.org (2013-09-23): Please don't CC me, I'm subscribed to the list. And the list doesn't care. “When replying to messages on the mailing list, do not send a carbon copy (CC) to the original poster unless they explicitly request to be copied.” is followed by: “If

Re: packaging Postgres binary dump files

2013-09-22 Thread Joerg Jaspert
On 13340 March 1977, Daniel Pocock wrote: However, if the package is formally rejected by the FTP masters then I will be happy to change it to ASCII SQL if required. Please include the source / preferred form for modification in the source, and create this postgres thing from that. I've now

Re: packaging Postgres binary dump files

2013-09-21 Thread Bernd Zeimetz
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

Re: packaging Postgres binary dump files

2013-09-20 Thread Paul Wise
On Thu, Sep 19, 2013 at 2:42 PM, Daniel Pocock wrote: PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore What is their reason for using the binary format? Could they be convinced to switch to or add something more normal like compressed SQL? -- bye,

Re: packaging Postgres binary dump files

2013-09-20 Thread Paul Wise
On Thu, Sep 19, 2013 at 2:49 PM, Martijn van Oosterhout wrote: FWIW, you can convert the file to text using pg_restore, you don't actually need a running database server. It's really just a compressed tarball and should be treated as such. That is, I think it can be included as-is. Unless

Re: packaging Postgres binary dump files

2013-09-20 Thread Daniel Pocock
On 20/09/13 09:07, Paul Wise wrote: On Thu, Sep 19, 2013 at 2:42 PM, Daniel Pocock wrote: PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore What is their reason for using the binary format? Could they be convinced to switch to or add something more

Re: packaging Postgres binary dump files

2013-09-20 Thread Chow Loong Jin
On Fri, Sep 20, 2013 at 09:07:48AM +0200, Paul Wise wrote: On Thu, Sep 19, 2013 at 2:42 PM, Daniel Pocock wrote: PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore What is their reason for using the binary format? Could they be convinced to switch

Re: packaging Postgres binary dump files

2013-09-20 Thread Federico Di Gregorio
On 20/09/2013 10:59, Chow Loong Jin wrote: On Fri, Sep 20, 2013 at 09:07:48AM +0200, Paul Wise wrote: On Thu, Sep 19, 2013 at 2:42 PM, Daniel Pocock wrote: PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore What is their reason for using the

Re: packaging Postgres binary dump files

2013-09-20 Thread Christoph Berg
Re: Paul Wise 2013-09-20 CAKTje6H+3YuHOo3Tr39yuCubjdZD08XOcVUu=02tvttx9x1...@mail.gmail.com The format doesn't appear to be very efficient, the plain SQL commands are much smaller: pabs@wagner:~$ pg_restore -l postbooks_empty-4.1.0.backup foo.sql pabs@wagner:~$ ls -Ssh total 5.6M 5.3M

Re: packaging Postgres binary dump files

2013-09-20 Thread Paul Wise
On Fri, Sep 20, 2013 at 10:59 AM, Chow Loong Jin wrote: Just speaking for myself here, but I find that the binary format is more flexible in that pg_restore can selectively restore things, generate DROP statements, restoring things in parallel and such. All in all, the binary format

Re: packaging Postgres binary dump files

2013-09-20 Thread Jonathan Dowland
On Fri, Sep 20, 2013 at 12:20:38PM +0200, Paul Wise wrote: It is also impossible to patch the binary format unlike SQL. Interesting. For the first time, I've realised there can be a clash between preferred form for modification and preferred form for use. -- To UNSUBSCRIBE, email to

Re: packaging Postgres binary dump files

2013-09-20 Thread Paul Tagliamonte
On Fri, Sep 20, 2013 at 02:47:39PM +0100, Jonathan Dowland wrote: On Fri, Sep 20, 2013 at 12:20:38PM +0200, Paul Wise wrote: It is also impossible to patch the binary format unlike SQL. Interesting. For the first time, I've realised there can be a clash between preferred form for

Re: packaging Postgres binary dump files

2013-09-20 Thread Daniel Pocock
On 20/09/13 15:49, Paul Tagliamonte wrote: On Fri, Sep 20, 2013 at 02:47:39PM +0100, Jonathan Dowland wrote: On Fri, Sep 20, 2013 at 12:20:38PM +0200, Paul Wise wrote: It is also impossible to patch the binary format unlike SQL. Interesting. For the first time, I've realised there can be a

Re: packaging Postgres binary dump files

2013-09-20 Thread Paul Tagliamonte
On Fri, Sep 20, 2013 at 05:04:50PM +0200, Daniel Pocock wrote: On 20/09/13 15:49, Paul Tagliamonte wrote: On Fri, Sep 20, 2013 at 02:47:39PM +0100, Jonathan Dowland wrote: On Fri, Sep 20, 2013 at 12:20:38PM +0200, Paul Wise wrote: It is also impossible to patch the binary format unlike SQL.

Re: packaging Postgres binary dump files

2013-09-20 Thread Daniel Pocock
On 20/09/13 17:07, Paul Tagliamonte wrote: On Fri, Sep 20, 2013 at 05:04:50PM +0200, Daniel Pocock wrote: On 20/09/13 15:49, Paul Tagliamonte wrote: On Fri, Sep 20, 2013 at 02:47:39PM +0100, Jonathan Dowland wrote: On Fri, Sep 20, 2013 at 12:20:38PM +0200, Paul Wise wrote: It is also

packaging Postgres binary dump files

2013-09-19 Thread Daniel Pocock
PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore They are available for download here (not in the source tarball): http://sourceforge.net/projects/postbooks/files/03%20PostBooks-databases/4.1.0/ The pg_dump documentation explains the binary format

Re: packaging Postgres binary dump files

2013-09-19 Thread Martijn van Oosterhout
On 19 September 2013 14:42, Daniel Pocock dan...@pocock.com.au wrote: PostBooks distributes their schema as a Postgres binary dump file for use with pg_restore They are available for download here (not in the source tarball):