Re: [HACKERS] Implementing incremental backup

2013-06-21 Thread Jehan-Guillaume (ioguix) de Rorthais
WAL between W1 and Wn would help to recover much faster to the time of Wn than replaying all the WALs between W1 and Wn and saves a lot of space. I was hoping to find some time to dig around this idea, but as the subject rose here, then here are my 2¢! Cheers, -- Jehan-Guillaume (ioguix) de Rort

Re: [HACKERS] Allowing multi "-t" and adding "-n" to vacuumdb ?

2012-03-02 Thread Jehan-Guillaume (ioguix) de Rorthais
On 01/03/2012 23:13, Tom Lane wrote: > "Jehan-Guillaume (ioguix) de Rorthais" writes: >> One of our customer send us a patch he wrote for his needs (on >> "src/bin/scripts/vacuumdb.c", no doc were included). > >> He's using one schema per applica

[HACKERS] Allowing multi "-t" and adding "-n" to vacuumdb ?

2012-03-01 Thread Jehan-Guillaume (ioguix) de Rorthais
a|-n" option which would fetch and build the table list and call "vacuum_one_database". But before I start writing this patch, I would like some opinion, pros / cons. Do you think such a feature could be accepted in official PostgreSQL code or should we keep this as an external s

Re: [HACKERS] Google Summer of Code? Call for mentors.

2012-02-20 Thread Jehan-Guillaume (ioguix) de Rorthais
r or not we should participate > this summer. Yes, I'll be available to mentor a student on phpPgAdmin this year again. Thanks, - -- Jehan-Guillaume (ioguix) de Rorthais http://www.dalibo.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla -

Re: [HACKERS] GSoC 2011 - Mentors? Projects?

2011-03-08 Thread Jehan-Guillaume (ioguix) de Rorthais
On 08/03/2011 07:44, Selena Deckelmann wrote: Hi! PostgreSQL is applying for GSoC again this year. We're looking for: * Mentors Ready to mentor again this year for phpPgAdmin * Project ideas Would you like to mentor? Please let me know! Our application closes on Friday, so please contact m

Re: [HACKERS] some comments rewording in recovery.conf.sample about SR

2011-01-07 Thread Jehan-Guillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Le 07/01/2011 16:58, Robert Haas a écrit : > On Fri, Jan 7, 2011 at 7:23 AM, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> PFA > > Committed, with some additional wordsmithing. Thank you ! -BEGIN PGP SIGNATURE- Vers

Re: [HACKERS] some comments rewording in recovery.conf.sample about SR

2011-01-07 Thread Jehan-Guillaume (ioguix) de Rorthais
Obviously... PFA Le 07/01/2011 13:22, Jehan-Guillaume (ioguix) de Rorthais a écrit : > Hello Hackers, > > I believe comments in the recovery.conf.sample are somehow confusing > about standby and SR: > > # Edit this file to provide the parameters that PostgreSQL needs t

[HACKERS] some comments rewording in recovery.conf.sample about SR

2011-01-07 Thread Jehan-Guillaume (ioguix) de Rorthais
uster in recovery, it doesn't imply to set up the SR. # By default, a standby server keeps streaming XLOG records from the # primary indefinitely. Same story... Please, find in attachment a proposal of rewording. Comments ? Regards, - -- Jehan-Guillaume (ioguix) de Rorthais www.

Re: [HACKERS] Typo in plperl doc ?

2010-06-14 Thread Jehan-Guillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/06/2010 14:08, Robert Haas wrote: > On Mon, Jun 14, 2010 at 3:48 AM, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> While translating the plperl page from the manual, I found the following >> sentence: >> >> T

[HACKERS] Typo in plperl doc ?

2010-06-14 Thread Jehan-Guillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, While translating the plperl page from the manual, I found the following sentence: The %_SHARED variable and other global state within the language is public data. Should it be : The %_SHARED variable and other global variables within

Re: [HACKERS] providing tokenized version of parsed SQL script

2010-04-28 Thread Jehan-Guillaume (ioguix) de Rorthais
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/04/2010 02:20, Robert Haas wrote: > On Tue, Apr 27, 2010 at 7:45 PM, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> I thought Michael was trying to write a tokenizer based on node tree >> returned by raw_parser. As it se

[HACKERS] providing tokenized version of parsed SQL script (was: nodeToString format and exporting the SQL parser)

2010-04-27 Thread Jehan-Guillaume (ioguix) de Rorthais
Admin that they depend on a contrib module. Moreover, PostgreSQL already expose a lot of informations about its internal mechanisms, configuration, ddl etc. I think having a proper tokenizer function is just a natural new functionality for core if possible. Having dropped an eye here and the

Re: [HACKERS] [RFC] nodeToString format and exporting the SQL parser

2010-04-21 Thread Jehan-Guillaume (ioguix) de Rorthais
2 OPERATOR| 30 | '=' | 2 CONSTANT | 31 | '1' | 2 > > Cheers, > David. As a phpPgAdmin dev, I am thinking about this subject since a long time. I am interested about trying to create such a patch after discussing it and if you think i

Re: [HACKERS] Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls

2010-01-20 Thread Jehan-Guillaume (ioguix) de Rorthais
- t (1 ligne) postgres=# SELECT ROW(ROW(NULL),NULL) IS NULL; ?column? -- f (1 ligne) > regards, tom lane -- Jehan-Guillaume (ioguix) de Rorthais DBA http://www.dalibo.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

[HACKERS] Bug ? different behaviour between 8.3 and 8.4 won IS NULL with sub arrays of nulls

2010-01-19 Thread ioguix
8.4 | t| t (1 ligne) > Regards, -- Jehan-Guillaume (ioguix) de Rorthais DBA http://www.dalibo.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Triggers on columns

2009-09-03 Thread ioguix
for the purpose of firing triggers. A simple use case would be to update a timestamp column with CURRENT_TIMESTAMP as instance. ...Robert -- Guillaume (ioguix) de Rorthais -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://ww

Re: [HACKERS] generic options for explain

2009-05-26 Thread ioguix
y. About the format, JSON would be the best here, as it is a one function call in PHP to retrieve an associative array from the JSON code. -- Guillaume (ioguix) de Rorthais -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscrip