pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedClarification when using Continous Archiving in 8.4
4+ messages / 3 participants
[nested] [flat]
* Clarification when using Continous Archiving in 8.4
@ 2013-07-16 16:30 Nestor A. Diaz <nestor@tiendalinux.com>
0 siblings, 1 reply; 4+ messages in thread
From: Nestor A. Diaz @ 2013-07-16 16:30 UTC (permalink / raw)
To: pgsql-admin
Hello People,
In reference to my last post
<http://www.postgresql.org/message-id/51E4725C.3050609@tiendalinux.com;
, my question is: It is possible to recover more (subsequent) WAL files
when I have already recover a postgres 8.4 database using a PITR ? I
have read on some places that it's not possible and I want to confirm
that, is it possible in 9.1 ?
Slds
--
Typed on my key64.org keyboard
Nestor A Diaz
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification when using Continous Archiving in 8.4
@ 2013-08-09 01:36 Bruce Momjian <bruce@momjian.us>
parent: Nestor A. Diaz <nestor@tiendalinux.com>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2013-08-09 01:36 UTC (permalink / raw)
To: Nestor A. Diaz <nestor@tiendalinux.com>; +Cc: pgsql-admin
On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote:
> Hello People,
>
> In reference to my last post , my question is: It is possible to recover more
> (subsequent) WAL files when I have already recover a postgres 8.4 database
> using a PITR ? I have read on some places that it's not possible and I want to
> confirm that, is it possible in 9.1 ?
I am confused. You did recovery, and then you want to do more WAL
files past your stop point?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification when using Continous Archiving in 8.4
@ 2013-08-09 08:20 Jan Lentfer <Jan.Lentfer@web.de>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Jan Lentfer @ 2013-08-09 08:20 UTC (permalink / raw)
To: pgsql-admin
On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote:
> On Tue,
Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote:
>
>> Hello
People, In reference to my last post , my question is: It is possible to
recover more (subsequent) WAL files when I have already recover a
postgres 8.4 database using a PITR ? I have read on some places that
it's not possible and I want to confirm that, is it possible in 9.1 ?
>
> I am confused. You did recovery, and then you want to do more WAL
>
files past your stop point?
>
> -- Bruce Momjian http://momjian.us [2]
EnterpriseDB http://enterprisedb.com [3] + It's impossible for
everything to be true. +
With 8.4 (up to 9.0) you have to restart the
PITR over and over again, if you "missed" the desired point. Starting
with 9.1 there is pause_at_recovery_target(). Is that what you mean?
http://www.postgresql.org/docs/9.1/interactive/recovery-target-settings.html
Regards
Jan
--
professional:
http://www.oscar-consult.de
private:
http://neslonek.homeunix.org/drupal/
Links:
------
[1]
mailto:bruce@momjian.us
[2] http://momjian.us
[3]
http://enterprisedb.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification when using Continous Archiving in 8.4
@ 2013-08-10 02:06 Bruce Momjian <bruce@momjian.us>
parent: Jan Lentfer <Jan.Lentfer@web.de>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2013-08-10 02:06 UTC (permalink / raw)
To: Jan Lentfer <Jan.Lentfer@web.de>; +Cc: pgsql-admin
On Fri, Aug 9, 2013 at 10:20:13AM +0200, Jan Lentfer wrote:
> On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote:
>
> On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote:
>
> Hello People, In reference to my last post , my question is: It is
> possible to recover more (subsequent) WAL files when I have already
> recover a postgres 8.4 database using a PITR ? I have read on some
> places that it's not possible and I want to confirm that, is it
> possible in 9.1 ?
>
> I am confused. You did recovery, and then you want to do more WAL
> files past your stop point?
>
> -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
>
> With 8.4 (up to 9.0) you have to restart the PITR over and over again, if you
> "missed" the desired point. Starting with 9.1 there is pause_at_recovery_target
> (). Is that what you mean?
>
> http://www.postgresql.org/docs/9.1/interactive/recovery-target-settings.html
Yes, that is the right information.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-08-10 02:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-16 16:30 Clarification when using Continous Archiving in 8.4 Nestor A. Diaz <nestor@tiendalinux.com>
2013-08-09 01:36 ` Bruce Momjian <bruce@momjian.us>
2013-08-09 08:20 ` Jan Lentfer <Jan.Lentfer@web.de>
2013-08-10 02:06 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox