From:
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To:
Marko Tiikkaja <pgmail(at)joh(dot)to>,
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Joel Jacobson <joel(at)trustly(dot)com>, pgsql-hackers(at)postgresql(dot)org,
Robert Treat <rob(at)xzilla(dot)net>
Subject:
Re: pg_dump --split patch
Date:
2012-11-19 14:07:40
Message-ID:
m2r4npwus3.fsf@2ndQuadrant.fr (view raw or flat )
Thread:
2010-12-28 16:00:35 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 16:26:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-28 16:41:04 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 16:51:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-28 16:59:31 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 17:10:37 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-28 17:17:22 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-12-28 17:33:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-02 07:48:47 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-12-28 17:33:36 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2010-12-28 19:39:01 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 20:44:54 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2010-12-28 21:44:13 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 21:57:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-12-28 22:26:06 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-28 22:51:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-04 10:09:10 from Hannu Krosing <hannu(at)2ndquadrant(dot)com>
2010-12-28 22:55:48 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2011-01-04 10:06:04 from Hannu Krosing <hannu(at)2ndquadrant(dot)com>
2010-12-28 23:00:46 from David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>
2010-12-28 23:24:37 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-29 00:24:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-29 01:18:46 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-29 01:51:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-12-29 07:27:34 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-29 13:17:25 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-29 13:31:17 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-29 14:11:22 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2010-12-29 14:23:38 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-29 15:07:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-29 15:21:16 from Joel Jacobson <joel(at)gluefinance(dot)com>
2011-01-03 12:11:33 from Dmitry Koterov <dmitry(at)koterov(dot)ru>
2011-01-03 18:19:48 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 18:33:39 from Joel Jacobson <joel(at)gluefinance(dot)com>
2011-01-03 18:34:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-03 18:50:03 from Joel Jacobson <joel(at)gluefinance(dot)com>
2011-01-03 19:01:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 19:18:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-03 19:46:02 from Joel Jacobson <joel(at)gluefinance(dot)com>
2011-01-03 19:54:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-23 02:04:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 20:15:17 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-03 20:50:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-02 07:54:31 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-04 13:06:55 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-29 20:33:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-30 07:13:20 from Joel Jacobson <joel(at)gluefinance(dot)com>
2010-12-30 20:28:18 from Robert Treat <rob(at)xzilla(dot)net>
2011-01-04 09:58:43 from Hannu Krosing <hannu(at)krosing(dot)net>
2012-10-22 11:33:42 from Marko Tiikkaja <pgmail(at)joh(dot)to>
2012-11-16 14:52:53 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-18 23:05:26 from Marko Tiikkaja <pgmail(at)joh(dot)to>
2012-11-19 08:40:46 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-19 14:07:40 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-19 15:16:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-11-28 18:46:48 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> writes:
>>> pg_dump | pg_restore
>>> pg_export | psql
>>
>> While I agree that this idea - when implemented - would be nicer in
>> practically every way, I'm not sure I want to volunteer to do all the
>> necessary work.
>
> What I think needs to happen now is a commiter's buy in that we want to
> get there at some point and that your current patch is not painting us
> into any corner now. So that we can accept it and have a documented path
> forward.
Just stumbled accross this message while reading some older threads
about the current topic:
http://archives.postgresql.org/pgsql-hackers/2010-12/msg02496.php
Where Robert Treat said:
> I've both enjoyed reading this thread and seeing this wheel reinvented
> yet again, and wholeheartedly +1 the idea of building this directly
> into pg_dump. (The only thing better would be to make everything thing
> sql callable, but that's a problem for another day).
I know Andrew has been working on his "Retail DDL" project which is
basically a bunch of server-side functions that spits out SQL object
definitions. Andrew, were you able to make progress on that project?
On the other hand, pg_dump -Fs still is something I would like to have
as a complement to Andrew's facility.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
In response to
Responses
pgsql-hackers by date
Next :From: Dimitri FontaineDate: 2012-11-19 14:22:31
Subject : Re: Proposal for Allow postgresql.conf values to be changed via SQL
Previous :From : Pavel StehuleDate : 2012-11-19 13:17:33
Subject : review: Reduce palloc's in numeric operations