Re: [GENERAL] ordered pg_dump

2008-11-10 Thread Kyle Cordes
sible. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Decreasing WAL size effects

2008-10-30 Thread Kyle Cordes
ith a small pile of servers running PG)... I would also find any improvements in WAL shipping helpful, between now and when continuous streaming is ready. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] Decreasing WAL size effects

2008-10-30 Thread Kyle Cordes
e in a way that is always on (i.e. no setting, etc.). On the log-recovery side, PG would need to be willing to accept shorter-than-usual segments, if it's not already willing. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Decreasing WAL size effects

2008-10-30 Thread Kyle Cordes
Greg Smith wrote: On Thu, 30 Oct 2008, Kyle Cordes wrote: It sure would be nice if there was a way for PG itself to zero the unused portion of logs as they are completed, perhaps this will make The overhead of clearing out the whole thing is just large enough that it can be disruptive on

Re: [GENERAL] Decreasing WAL size effects

2008-10-30 Thread Kyle Cordes
or PG itself to zero the unused portion of logs as they are completed, perhaps this will make it in as part of the ideas discussed on this list a while back to make a more "out of the box" log-ship mechanism? -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-gener

[GENERAL] Need advice on PITR Slony(?) Backups etc.

2008-10-11 Thread Kyle Cordes
volve some hours of consulting work. If anyone is interested, get in touch by email, and I will send over a description of what we have and what we're trying to achieve. -- Kyle Cordes http://kylecordes.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang