This is a multi-part message in MIME format.
--------------090201010708070102070907
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
nick wrote:
>
> Thanks for the reply, a****sh.
>
>
>
> Sorry, should've been more specific.
>
>
>
> By running WAL, I mean reprocessing the WALs up to a certain point of
> time.
>
>
>
> For example:
>
>
>
> A backup is made at 0000 hours. Something happens. Restore has to be
> made at 2000.
>
>
>
> 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.
>
>
>
Yes , Service has to be stopped and started to restore from the WAL and
also make sure that no one connects to the database during this phase by
ensuring proper pg_hba.conf.
>
> 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.
>
>
>
When something is "already happened" to database then what is it worth
to connect to that database before bringing it to proper place.
Correct me if I am mis understanding you.
Other way around i think is create another database cluster and restore
the database there instead on your current cluster. But I doubt on this.
> It would be of great help if it's possible.
>
>
>
With Regards
A****sh
>
> Thanks in advance,
>
>
>
> Nick
>
>
>
> ------------------------------------------------------------------------
>
> *From:* a****sh [mailto:a****sh.karalkar@[EMAIL PROTECTED]
> *Sent:* Thursday, March 27, 2008 7:40 PM
> *To:* nick
> *Cc:* pgsql-novice@[EMAIL PROTECTED]
> *Subject:* Re: [NOVICE] Restoring DB using Continuous Archive Backup
>
>
>
> nick wrote:
>
> Hi everyone,
>
>
>
> 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.
>
>
>
> This may sound retarded. I can't seem to get a clear picture from the
> manual. I quote (Chapter 24.3.3 Step 4):
>
> / /
>
> /_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./
>
> / /
>
> I need to know which kind of backup (as there are multiple suggested
> in the manual) would that (underlined) be referring to?
>
>
>
> File system level backup
>
> 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?
>
>
>
> 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.
>
>
>
> Thanks in advance,
>
>
>
> Nick
>
>
>
>
>
>
>
> 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
>
>
>
> ===================================================================
>
> 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
>
> ===================================================================
>
>
> 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.
> Version: 7.5.519 / Virus Database: 269.22.1/1345 - Release Date:
> 3/26/2008 6:50 PM
>
===================================================================
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
===================================================================
--------------090201010708070102070907
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
nick wrote:
<blockquote cite="mid:001501c8908a$4f3180b0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<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]-->
</o:SmartTagType>
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Thanks for
the reply, </span></font><font color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color:
windowtext;">a****sh.</span></font><font
color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Sorry,
should’ve been more specific.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">For
example:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
Yes , Service has to be stopped and started to restore from the WAL and
also make sure that no one connects to the database during this phase
by ensuring proper pg_hba.conf.<br>
<blockquote cite="mid:001501c8908a$4f3180b0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
When something is "already happened" to database then what is it worth
to connect to that database before bringing it to proper place.<br>
<br>
Correct me if I am mis understanding you.<br>
<br>
Other way around i think is create another database cluster and restore
the database there instead on your current cluster. But I doubt on
this.<br>
<br>
<blockquote cite="mid:001501c8908a$4f3180b0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
<br>
With Regards<br>
A****sh<br>
<blockquote cite="mid:001501c8908a$4f3180b0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Thanks in
advance,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;">Nick<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color:
navy;"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font
color="black" face="Times New Roman" size="3"><span
style="font-size: 12pt; color: windowtext;">
<hr tabindex="-1" align="center" size="2"
width="100%"></span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;
font-weight: bold;">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;">
a****sh [<a class="moz-txt-link-freetext"
href="mailto:a****sh.karalkar@[EMAIL PROTECTED]
">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"><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-novice@[EMAIL PROTECTED]
">pgsql-novice@[EMAIL PROTECTED]
></st1:PersonName><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 color="black" face="Times New Roman"
size="3"><span style="font-size:
12pt;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">nick wrote:
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hi
everyone,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family:
Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="black" face="Arial" size="2"><span
style="font-size: 10pt; font-family:
Arial;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Arial" size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; 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 color="black"
face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;">Restore
the database files from your backup dump</span></font></u></i><i><font
face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;">owner****p
(the database system user, not </span></font></i><i><font
face="NimbusMonL-Regu" size="1"><span
style="font-size: 9pt; font-family: NimbusMonL-Regu; font-style:
italic;">root</span></font></i><i><font
face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;">tablespaces,
you should verify that the symbolic links in </span></font></i><i><font
face="NimbusMonL-Regu" size="1"><span
style="font-size: 9pt; font-family: NimbusMonL-Regu; font-style:
italic;">pg_tblspc/
</span></font></i><i><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;"><u1:p> </u1:p></span></font></i><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">File system level backup
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; 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 color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">As far as i think the
answer
is NO<br>
<br>
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; 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 color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">Not clear need more info.<br>
<br>
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p></u1:p><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu;">Thanks in
advance,<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;">Nick<u1:p></u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><u1:p> </u1:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size:
12pt;"><o:p> </o:p></span></font></p>
<p><font color="black" face="Times New Roman" size="2"><span
style="font-size: 10pt;">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 color="black" face="Times New Roman"
size="3"><span style="font-size:
12pt;"><o:p> </o:p></span></font></p>
</div>
<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 <a class="moz-txt-link-freetext"
href="http://www.mytodaysms.com">http://www.mytodaysms.com</a>
===================================================================
</pre>
<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>
</blockquote>
<br>
</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>
--------------090201010708070102070907--
|
