On Sat, 2010-09-11 at 14:21 -0700, Gabe Nell wrote:
> Is there a way to get this without using hot standby?
Why would you want to avoid using hot standby?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-general mai
On Sep 12, 2:39 pm, jo...@antarean.org ("J. Roeleveld") wrote:
> On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
>
> > On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> > > How can you ensure the snapshot is in a consistent state if the server is
> > > running?
>
>
>
> >> 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?
>
> I don't think you can t
On Mon, Sep 13, 2010 at 1:29 AM, Mikko Partio wrote:
>> > 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 n
>
> > 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 ba
On Sun, 2010-09-12 at 12:18 +0200, J. Roeleveld wrote:
> On Sunday 12 September 2010 00:43:19 Bruce Momjian wrote:
> > Gabe Nell wrote:
> > > > That section has been removed from the current 9.0 docs because we are
> > > > unsure it works.
> > >
> > > Hmm. So the only way to make a consistent back
On Sun, Sep 12, 2010 at 7:51 AM, Bruce Momjian wrote:
> J. Roeleveld wrote:
>> Nice in theory.
>> Except backups can not be fully trusted if they rely on database recovery
>> mechanics as part of the restore process.
>
>> How certain can you be that the data you have in your backup will always
>>
J. Roeleveld wrote:
> On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
> > On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> > > How can you ensure the snapshot is in a consistent state if the server is
> > > running?
> > >
> > > If a snapshot is taken between 2 upd
On Sun, Sep 12, 2010 at 7:39 AM, J. Roeleveld wrote:
> On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
>> On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
>> > How can you ensure the snapshot is in a consistent state if the server is
>> > running?
>> >
>> > If a sna
On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
> On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> > How can you ensure the snapshot is in a consistent state if the server is
> > running?
> >
> > If a snapshot is taken between 2 updates in a single transaction, on
On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> How can you ensure the snapshot is in a consistent state if the server is
> running?
>
> If a snapshot is taken between 2 updates in a single transaction, only half
> of
> this transaction is included in the snapshot.
> I would nev
On Sunday 12 September 2010 00:43:19 Bruce Momjian wrote:
> Gabe Nell wrote:
> > > That section has been removed from the current 9.0 docs because we are
> > > unsure it works.
> >
> > Hmm. So the only way to make a consistent backup from a standby server
> > is to shut down the standby first? Or
Gabe Nell wrote:
> > That section has been removed from the current 9.0 docs because we are
> > unsure it works.
>
> Hmm. So the only way to make a consistent backup from a standby server
> is to shut down the standby first? Or is even that problematic?
>
> Would it change anything if we are able
> That section has been removed from the current 9.0 docs because we are
> unsure it works.
Hmm. So the only way to make a consistent backup from a standby server
is to shut down the standby first? Or is even that problematic?
Would it change anything if we are able to guarantee that the
filesyst
Gabe Nell wrote:
> Hello,
>
> 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
> t
Hello,
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
I'm about to begin playing with incrementally updated backups for a
warm standby scenario, but I need some help understanding this
paragraph in postgres terms. From 23.4.5 in the 8.2.3 docs:
"If we take a backup of the standby server's files while it is
following logs shipped from the prima
17 matches
Mail list logo