Re: Incrementally Updated Backups

From: Mikko Partio <mpartio(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Gabe Nell <gabe(at)kikini(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Incrementally Updated Backups
Date: 2010-09-13 07:29:15
Message-ID: AANLkTikQD+zvOQgJFiN1+ZAHdOH6w-0=J7pQM_DDQjtU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> > I'm interested in the "incrementally updated backups" scenario
> > described in section 25.6 of the Postgres 9 documentation. I've
> > configured streaming replication for my warm standby server.
> >
> > Step 2 in this procedure is to note?pg_last_xlog_replay_location at
> > the end of the backup. However it seems like this requires hot standby
> > to be configured; otherwise there is no way of connecting to the
> > standby machine to make the required query. That does not seem clear
> > from the documentation. Is there a way to get this without using hot
> > standby?
>
> That section has been removed from the current 9.0 docs because we are
> unsure it works.

Is the feature (or the documentation) still being worked on, or is pg_dump
the only way to take a backup of a warm standby while the database is
running?

Regards

Mikko

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message adi hirschtein 2010-09-13 07:36:53 Re: Monitoring Object access
Previous Message Tomáš Kovářík 2010-09-13 07:00:58 Server crash during simple c-language function