This is a multi-part message in MIME format.
--Boundary_(ID_Ec+W7J2Ib9PtWiiq0KklOw)
Content-type: text/plain; charset=windows-1250
Content-transfer-encoding: quoted-printable
Thanks for the reply, a****sh.=20
=20
Sorry, should=92ve been more specific.
=20
By running WAL, I mean reprocessing the WALs up to a certain point of =
time.=20
=20
For example:
=20
A backup is made at 0000 hours. Something happens. Restore has to be =
made at
2000.
=20
Since the backup is at 0000, 20 hours=92 worth of transactions will be =
stored
in WAL. To get the data up to the 2000 the WALs have to be reprocessed. =
I
realize the only way for this to work is by data file duplication, so =
this
mean the service has to be stopped anyway to allow the files to be =
restored.
=20
But there may be a requirement to not take the system offline so I=92m =
looking
for a method to do the restore and WAL reprocessing without stopping =
then
starting the service like described in the manual.=20
=20
It would be of great help if it=92s possible.
=20
Thanks in advance,
=20
Nick
=20
_____ =20
From: a****sh [mailto:a****sh.karalkar@[EMAIL PROTECTED]
Thursday, March 27, 2008 7:40 PM
To: nick
Cc: pgsql-novice@[EMAIL PROTECTED]
Re: [NOVICE] Restoring DB using Continuous Archive Backup
=20
nick wrote:=20
Hi everyone,
=20
I just got PGSQL up and running yesterday. One of the features that =
intrigue
me is the WAL. I am running tests to perform DB restores using WAL. The =
last
attempt ended in disaster and a reinstall.=20
=20
This may sound retarded. I can=92t seem to get a clear picture from the
manual. I quote (Chapter 24.3.3 Step 4):
=20
Restore the database files from your backup dump. Be careful that they =
are
restored with the right
owner****p (the database system user, not root!) and with the right
permissions. If you are using
tablespaces, you should verify that the symbolic links in pg_tblspc/ =
were
correctly restored.
=20
I need to know which kind of backup (as there are multiple suggested in =
the
manual) would that (underlined) be referring to?=20
=20
File system level backup=20
Is there a way to detach/attach databases (like ms-sql) and so perform
restoration on only one database instead of bringing down the service?
=20
As far as i think the answer is NO
Is there a method to re-run WAL after restoring an old backup without
resorting to a service stop-start?
Not clear need more info.
=20
Thanks in advance,
=20
Nick
=20
=20
=20
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: =
3/26/2008
6:50 PM
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
sms START NETCORE to 575758 to get updates on Netcore's enterprise
products and services
sms START MYTODAY to 09845398453 for more information on our mobile
consumer services or go to http://www.mytodaysms.com
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: =
3/26/2008
6:50 PM
No virus found in this outgoing message.
Checked by AVG.=20
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: =
3/26/2008
6:50 PM
=20
--Boundary_(ID_Ec+W7J2Ib9PtWiiq0KklOw)
Content-type: text/html; charset=windows-1250
Content-transfer-encoding: 7BIT
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns:st1="urn:schemas-microsoft-com:office:smarttags"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
11 6 4 3 5 4 4 2 4;}
@[EMAIL PROTECTED]
0 0 0 0 0 0 0 0 0;}
@[EMAIL PROTECTED]
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks for the reply,
</span></font><font
size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'>a****sh.</span></font><font size=2 color=navy
face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>Sorry, should’ve been more
specific.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>By running WAL, I mean reprocessing
the
WALs up to a certain point of time. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>For
example:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>A backup is made at 0000 hours.
Something
happens. Restore has to be made at 2000.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>Since the backup is at 0000, 20
hours’
worth of transactions will be stored in WAL. To get the data up to the
2000 the
WALs have to be reprocessed. I realize the only way for this to work is by
data
file duplication, so this mean the service has to be stopped anyway to
allow
the files to be restored.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>But there may be a requirement to not
take
the system offline so I’m looking for a method to do the restore and
WAL
reprocessing without stopping then starting the service like described in
the
manual. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>It would be of great help if
it’s
possible.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks in
advance,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'>Nick<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span
style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span
style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> a****sh [mailto:a****sh.karalkar@[EMAIL PROTECTED]
<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, March 27,
2008
7:40 PM<br>
<b><span style='font-weight:bold'>To:</span></b> nick<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName
w:st="on">pgsql-novice@[EMAIL PROTECTED]
><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [NOVICE]
Restoring DB
using Continuous Archive Backup</span></font><font color=black><span
style='color:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>nick wrote: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span
style='font-size:
10.0pt;font-family:Arial'>Hi
everyone,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span
style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span
style='font-size:
10.0pt;font-family:Arial'>I just got PGSQL up and running yesterday. One
of the
features that intrigue me is the WAL. I am running tests to perform DB
restores
using WAL. The last attempt ended in disaster and a reinstall.
<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span
style='font-size:
10.0pt;font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span
style='font-size:
10.0pt;font-family:Arial'>This may sound retarded. I can’t seem to
get a
clear picture from the manual. I quote (Chapter 24.3.3 Step
4):<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><i><font size=2 color=black
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'><u1:p> </u1:p></span></font></i><o:p></o:p></p>
<p class=MsoNormal><i><u><font size=2 color=black
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'>Restore
the database files from your backup dump</span></font></u></i><i><font
size=2
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;
font-style:italic'>. Be careful that they are restored with the
right<u1:p></u1:p></span></font></i><o:p></o:p></p>
<p class=MsoNormal><i><font size=2 color=black
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'>owner****p
(the database system user, not </span></font></i><i><font size=1
face=NimbusMonL-Regu><span
style='font-size:9.0pt;font-family:NimbusMonL-Regu;
font-style:italic'>root</span></font></i><i><font size=2
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;
font-style:italic'>!) and with the right permissions. If you are
using<u1:p></u1:p></span></font></i><o:p></o:p></p>
<p class=MsoNormal><i><font size=2 color=black
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'>tablespaces,
you should verify that the symbolic links in </span></font></i><i><font
size=1
face=NimbusMonL-Regu><span
style='font-size:9.0pt;font-family:NimbusMonL-Regu;
font-style:italic'>pg_tblspc/ </span></font></i><i><font size=2
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;
font-style:italic'>were correctly
restored.<u1:p></u1:p></span></font></i><o:p></o:p></p>
<p class=MsoNormal><i><font size=2 color=black
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'><u1:p> </u1:p></span></font></i><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'>I need to know
which
kind of backup (as there are multiple suggested in the manual) would that
(underlined) be referring to? <u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>File system level backup
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'>Is there a way to
detach/attach databases (like ms-sql) and so perform restoration on only
one
database instead of bringing down the
service?<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>As far as i think the answer is NO<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'>Is there a method
to
re-run WAL after restoring an old backup without resorting to a service
stop-start?</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>Not clear need more info.<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p></u1:p><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'>Thanks in
advance,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'>Nick<u1:p></u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu'><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt'>No
virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50
PM</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
<pre>
===================================================================
sms START NETCORE to 575758 to get updates on Netcore's enterprise
products and services
sms START MYTODAY to 09845398453 for more information on our mobile
consumer services or go to http://www.mytodaysms.com
===================================================================
</pre>
</html>
<BR>
<P><FONT SIZE=2>No virus found in this incoming message.<BR>
Checked by AVG.<BR>
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50 PM<BR>
</FONT> </P><BR>
<P><FONT SIZE=2>No virus found in this outgoing message.<BR>
Checked by AVG.<BR>
Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date: 3/26/2008
6:50 PM<BR>
</FONT> </P>
--Boundary_(ID_Ec+W7J2Ib9PtWiiq0KklOw)--
|
