This is a multi-part message in MIME format.
--------------050608090109060404070105
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
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
===================================================================
--------------050608090109060404070105
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:000301c88ff4$5d693fb0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
0 0 0 0 0 0 0 0 0;}
@[EMAIL PROTECTED]
0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hi
everyone,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family:
Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font 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.
<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family:
Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font 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):<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><i><font face="NimbusRomNo9L-Regu"
size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;"><o:p> </o:p></span></font></i></p>
<p class="MsoNormal" style=""><i><u><font 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<o:p></o:p></span></font></i></p>
<p class="MsoNormal" style=""><i><font 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<o:p></o:p></span></font></i></p>
<p class="MsoNormal"><i><font 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.<o:p></o:p></span></font></i></p>
<p class="MsoNormal"><i><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu; font-style:
italic;"><o:p> </o:p></span></font></i></p>
<p class="MsoNormal"><font 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? <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
File system level backup
<blockquote cite="mid:000301c88ff4$5d693fb0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font 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?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
As far as i think the answer is NO<br>
<blockquote cite="mid:000301c88ff4$5d693fb0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font 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></p>
</div>
</blockquote>
Not clear need more info.<br>
<blockquote cite="mid:000301c88ff4$5d693fb0$1502a8c0@[EMAIL PROTECTED]
"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family: NimbusRomNo9L-Regu;">Thanks in
advance,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;">Nick<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="NimbusRomNo9L-Regu" size="2"><span
style="font-size: 10pt; font-family:
NimbusRomNo9L-Regu;"><o:p> </o:p></span></font></p>
</div>
<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>
--------------050608090109060404070105--
|
