recovery.conf

--_0f29d7ac-bdd9-485b-9c41-cc73293eb2dd_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all -

I'm trying to do a PITR and I've noticed that every time I try it=2C it ups=
the number it's looking for by one.

00000001.history

00000002.history

..

..

00000008.history

For example one of my transaction log files name is

0000000100000218000000C1

Instead of looking for 0000000100000218000000C1=2C it replaces the first 1=
=2C with a 2 or

0000000200000218000000C1=2C I'm all the way up to 8 now. How do I tell it =
to look for 1 or

0000000100000218000000C1 again.

Thanks=2C

~DjK

____________________________________________________________ _____
Windows 7: I wanted more reliable=2C now it's more reliable. Wow!
http://microsoft.com/windows/windows-7/default-ga.aspx?h=3Dm yidea?ocid=3DPI=
D24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:102009=

--_0f29d7ac-bdd9-485b-9c41-cc73293eb2dd_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style></style>
</head>
<body class=3D'hmmessage'>
Hi all -<BR>
=3B<BR>
I'm trying to do a PITR and I've noticed that every time I try it=2C it ups=
the number it's looking for by one.<BR>
=3B<BR>
00000001.history<BR>
00000002.history<BR>
..<BR>
..<BR>
00000008.history<BR>
=3B<BR>
For example one of my transaction log files name is <BR>
0000000100000218000000C1<BR><BR>
Instead of looking for 0000000100000218000000C1=2C it replaces the first 1=
=2C with a 2 or<BR>
0000000200000218000000C1=2C I'm all the way up to 8 now. =3B How do I t=
ell it to look for 1 or <BR>
0000000100000218000000C1 again.<BR>
=3B<BR>
=3B<BR>
Thanks=2C<BR>
~DjK<BR><BR><BR>
<hr />Windows 7: I wanted more reliable=
=2C now it's more reliable. <a href=3D'http://microsoft.com/windows/windows=
-7/default.aspx?h=3Dmyidea?ocid=3DPID24727::T:WLMTAGL:ON:WL: en-US:WWL_WIN_m=
yidea:102009' target=3D'_new'>Wow!</a></body>
</html>=

--_0f29d7ac-bdd9-485b-9c41-cc73293eb2dd_--

--0016e6db2d23235c4904771bac1b
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Oct 29, 2009 at 5:13 PM, dx k9 <bitsandbytes88 [at] hotmail.com> wrote:

> Hi all -
>
> I'm trying to do a PITR and I've noticed that every time I try it, it ups
> the number it's looking for by one.
>

What's in your recovery.conf?

>
> 00000001.history
> 00000002.history
> .
> .
> 00000008.history
>
> For example one of my transaction log files name is
> 0000000100000218000000C1
>
> Instead of looking for 0000000100000218000000C1, it replaces the first 1,
> with a 2 or
> 0000000200000218000000C1, I'm all the way up to 8 now. How do I tell it to
> look for 1 or
> 0000000100000218000000C1 again.
>
>

Every time your database opens, it comes onto a new timeline. I don't
*believe* you can go back to an older timeline once you've opened the
database for operation.

--Scott

--0016e6db2d23235c4904771bac1b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><div class=3D"gmail_quote">On Thu, Oct 29, 2009 at 5:13 PM, dx k9 <span=
dir=3D"ltr"><<a href=3D"mailto:bitsandbytes88 [at] hotmail.com">bitsandbytes=
88 [at] hotmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" s=
tyle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8e=
x; padding-left: 1ex;">

<div>
Hi all -<br>
=A0<br>
I'm trying to do a PITR and I've noticed that every time I try it, =
it ups the number it's looking for by one.<br></div></blockquote><div><=
br>=A0=A0 What's in your recovery.conf? <br></div><blockquote class=3D"=
gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0p=
t 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
=A0<br>
00000001.history<br>
00000002.history<br>
..<br>
..<br>
00000008.history<br>
=A0<br>
For example one of my transaction log files name is <br>
0000000100000218000000C1<br><br>
Instead of looking for 0000000100000218000000C1, it replaces the first 1, w=
ith a 2 or<br>
0000000200000218000000C1, I'm all the way up to 8 now.=A0 How do I tell=
it to look for 1 or <br>
0000000100000218000000C1 again.<br>
=A0<br></div></blockquote><div><br>=A0 Every time your database opens, it c=
omes onto a new timeline.=A0 I don't *believe* you can go back to an ol=
der timeline once you've opened the database for operation.<br></div></=
div>
<br>--Scott<br>

--0016e6db2d23235c4904771bac1b--

--0016e6d64486250e6c04771bb751
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Oct 29, 2009 at 7:57 PM, Scott Mead <scott.lists [at] enterprisedb.com>wrote:

>
> On Thu, Oct 29, 2009 at 5:13 PM, dx k9 <bitsandbytes88 [at] hotmail.com> wrote:
>
>> Hi all -
>>
>> I'm trying to do a PITR and I've noticed that every time I try it, it ups
>> the number it's looking for by one.
>>
>
> What's in your recovery.conf?
>
>>
>> 00000001.history
>> 00000002.history
>> .
>> .
>> 00000008.history
>>
>> For example one of my transaction log files name is
>> 0000000100000218000000C1
>>
>> Instead of looking for 0000000100000218000000C1, it replaces the first 1,
>> with a 2 or
>> 0000000200000218000000C1, I'm all the way up to 8 now. How do I tell it
>> to look for 1 or
>> 0000000100000218000000C1 again.
>>
>>
>
> Every time your database opens, it comes onto a new timeline. I don't
> *believe* you can go back to an older timeline once you've opened the
> database for operation.
>

Sorry, I'm wrong:

http://www.postgresql.org/docs/8.4/interactive/continuous-ar chiving.html#BACKUP-TIMELINES

You'll need to modify your recovery.conf slightly, but should be able to
move back.

--Scott

--0016e6d64486250e6c04771bb751
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Thu, Oct 29, 2009 at 7:57 PM, Scott Mead <spa=
n dir=3D"ltr"><<a href=3D"mailto:scott.lists [at] enterprisedb.com">scott.lis=
ts [at] enterprisedb.com</a>></span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt=
0.8ex; padding-left: 1ex;">
<br><div class=3D"gmail_quote"><div class=3D"im">On Thu, Oct 29, 2009 at 5:=
13 PM, dx k9 <span dir=3D"ltr"><<a href=3D"mailto:bitsandbytes88 [at] hotmail=
..com" target=3D"_blank">bitsandbytes88 [at] hotmail.com</a>></span> wrote:<br=
><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204,=
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<div>
Hi all -<br>
=A0<br>
I'm trying to do a PITR and I've noticed that every time I try it, =
it ups the number it's looking for by one.<br></div></blockquote></div>=
<div><br>=A0=A0 What's in your recovery.conf? <br></div><div class=3D"i=
m">
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
=A0<br>
00000001.history<br>
00000002.history<br>
..<br>
..<br>
00000008.history<br>
=A0<br>
For example one of my transaction log files name is <br>
0000000100000218000000C1<br><br>
Instead of looking for 0000000100000218000000C1, it replaces the first 1, w=
ith a 2 or<br>
0000000200000218000000C1, I'm all the way up to 8 now.=A0 How do I tell=
it to look for 1 or <br>
0000000100000218000000C1 again.<br>
=A0<br></div></blockquote></div><div><br>=A0 Every time your database opens=
, it comes onto a new timeline.=A0 I don't *believe* you can go back to=
an older timeline once you've opened the database for operation.<br></=
div>
</div></blockquote><div><br>=A0Sorry, I'm wrong:<br><br><a href=3D"http=
://www.postgresql.org/docs/8.4/interactive/continuous-archiv ing.html#BACKUP=
-TIMELINES">http://www.postgresql.org/docs/8.4/interactive/c ontinuous-archi=
ving.html#BACKUP-TIMELINES</a><br>
<br>You'll need to modify your recovery.conf slightly, but should be ab=
le to move back.<br><br>--Scott<br></div></div><br>

--0016e6d64486250e6c04771bb751--

recovery.conf

Re: recovery.conf

Re: recovery.conf