This is a multi-part message in MIME format.
--Boundary_(ID_RLr2Y3dn/5UvnQgY8W2fKQ)
Content-type: text/plain; charset=windows-1250
Content-transfer-encoding: quoted-printable
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
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
Is there a method to re-run WAL after restoring an old backup without
resorting to a service stop-start?
=20
Thanks in advance,
=20
Nick
=20
=20
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_RLr2Y3dn/5UvnQgY8W2fKQ)
Content-type: text/html; charset=windows-1250
Content-transfer-encoding: 7BIT
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
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)">
<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>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi everyone,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 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.
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 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):<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><i><font size=2
face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;
font-style:italic'><o:p> </o:p></span></font></i></p>
<p class=MsoNormal style='text-autospace:none'><i><u><font size=2
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<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='text-autospace:none'><i><font size=2
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<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 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.<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:10.0pt;font-family:NimbusRomNo9L-Regu;font-style:italic'><o:p> </o:p></span></font></i></p>
<p class=MsoNormal><font size=2 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? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 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?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 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?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'>Thanks in
advance,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'>Nick<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=NimbusRomNo9L-Regu><span
style='font-size:
10.0pt;font-family:NimbusRomNo9L-Regu'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
<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_RLr2Y3dn/5UvnQgY8W2fKQ)--
|
