Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-25 Thread Bruce Momjian
Simon Riggs wrote: > On Tue, 2010-08-24 at 11:04 -0700, Josh Berkus wrote: > > > I've been looking at the open item which belongs with this doc: > > > > http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html > > I'm back from holidays today, so will begin looking at this and r

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-25 Thread Simon Riggs
On Tue, 2010-08-24 at 11:04 -0700, Josh Berkus wrote: > I've been looking at the open item which belongs with this doc: > > http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html I'm back from holidays today, so will begin looking at this and related open-ish items. -- Simo

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-25 Thread Fujii Masao
On Wed, Aug 25, 2010 at 5:44 AM, Josh Berkus wrote: > Again, given that this is a method which is (a) fairly minority-need, > and (b) not at all tested in the field, I do not think it belongs in the > main docs.  Let's put it on the wiki and blog about it, and AFTER we've > collected bug reports a

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Robert Haas
On Tue, Aug 24, 2010 at 4:44 PM, Josh Berkus wrote: > On 8/24/10 12:42 PM, Tom Lane wrote: >> Marko Tiikkaja writes: >>> Is this method not reliable then?  Can something go wrong even if the >>> user does exactly what the documentation says? >> >> It is not.  This whole discussion started from so

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Joshua D. Drake
On Tue, 2010-08-24 at 13:44 -0700, Josh Berkus wrote: > On 8/24/10 12:42 PM, Tom Lane wrote: > > Marko Tiikkaja writes: > >> Is this method not reliable then? Can something go wrong even if the > >> user does exactly what the documentation says? > > > > It is not. This whole discussion started

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Josh Berkus
On 8/24/10 12:42 PM, Tom Lane wrote: > Marko Tiikkaja writes: >> Is this method not reliable then? Can something go wrong even if the >> user does exactly what the documentation says? > > It is not. This whole discussion started from somebody reporting that > it didn't work. Again, given that

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Tom Lane
Marko Tiikkaja writes: > Is this method not reliable then? Can something go wrong even if the > user does exactly what the documentation says? It is not. This whole discussion started from somebody reporting that it didn't work. regards, tom lane -- Sent via pgsql-ha

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Marko Tiikkaja
On 2010-08-24 9:04 PM +0300, Josh Berkus wrote: ... and my viewpoint is that the procedure described should be *cut* from the official docs and put on the Wiki, with warnings. It's simply far too hackish and dependant on DBA understanding of PostgreSQL internals to belong in the main docs. In 9

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Bruce Momjian
Bruce Momjian wrote: > Josh Berkus wrote: > > All, > > > > I've been looking at the open item which belongs with this doc: > > > > http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html > > > > ... and my viewpoint is that the procedure described should be *cut* > > from the o

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Bruce Momjian
Josh Berkus wrote: > All, > > I've been looking at the open item which belongs with this doc: > > http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html > > ... and my viewpoint is that the procedure described should be *cut* > from the official docs and put on the Wiki, with

[HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Josh Berkus
All, I've been looking at the open item which belongs with this doc: http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html ... and my viewpoint is that the procedure described should be *cut* from the official docs and put on the Wiki, with warnings. It's simply far too hack