Please Help... Service fails to start

Dear Friends,

I really need help for my problem, 7 days ago Postgresql service fails
to start and i have no backup ! (OS: Windows XP Pro). I tried googling
everywhere but didn't find any solution.

I had tried to start the service manually from control panel, it
started for about 5 seconds, after that stop again.

This is the error log :

2009-11-02 10:13:29 LOG: database system was interrupted while in
recovery at 2009-10-30 06:33:49 Malay Peninsula Standard Time
2009-11-02 10:13:29 HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2009-11-02 10:13:29 LOG: checkpoint record is at 3/DA21E418
2009-11-02 10:13:29 LOG: redo record is at 3/DA21E418; undo record is
at 0/0; shutdown FALSE
2009-11-02 10:13:29 LOG: next transaction ID: 0/139856773; next OID:
28846
2009-11-02 10:13:29 LOG: next MultiXactId: 4; next MultiXactOffset: 7
2009-11-02 10:13:29 LOG: database system was not properly shut down;
automatic recovery in progress
2009-11-02 10:13:29 LOG: redo starts at 3/DA21E468
2009-11-02 10:13:35 FATAL: could not access status of transaction
139856778
2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/0085"
at offset 98304: Permission denied.
2009-11-02 10:13:35 CONTEXT: xlog redo commit: 2009-10-20 17:20:42
2009-11-02 10:13:38 LOG: startup process (PID 1284) exited with exit
code 1
2009-11-02 10:13:38 LOG: aborting startup due to startup process
failure
2009-11-02 10:13:38 LOG: logger shutting down

It seems that i still have chance to redo or undo the record that
caused this error. But how to do that ? How to find that file ?
Postgresql data folder only contain numbered filename.

Thank you for any help.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hengky Lie [ Di, 03 November 2009 02:55 ] [ ID #2021446 ]

Re: Please Help... Service fails to start

Hengky Lie <hengkyliwandouw [at] gmail.com> writes:
> 2009-11-02 10:13:35 FATAL: could not access status of transaction
> 139856778
> 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/0085"
> at offset 98304: Permission denied.

You need to fix that "Permission denied" problem. Either the file
really is marked as not readable by the postgres user, or (probably
more likely on Windows) you have some malfunctioning "antivirus"
software installed.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Tom Lane [ Di, 03 November 2009 04:37 ] [ ID #2021450 ]

Re: Please Help... Service fails to start

--0-302245818-1257230896=:49193
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=0A=0A=0A=0A>> 2009-11-02 10:13:35 FATAL:=A0 could not access status of=0At=
ransaction=A0139856778
=0A=A02009-11-02 10:13:35 DETAIL:=A0 Could=0Anot read from file "pg_clog/00=
85"=A0 at offset 98304: Permission=0Adenied.=0A=0A
=0A=0A=0A=0A=A0I faced this error before a week only. Fortunately=0Awe have=
a valid backup and we restored the file (0085) in pg_clog directory. In=0A=
our case it is the corruption issue. =A0Kindly=0Acheck with permission and =
also under the /usr/local/pgsql/data/pg_clog directory whether=0Athe file (=
0085) is there or not ? If it is not there than try to reload it from=0Athe=
backup. At last you can touch the file and restart the database. However,=
=0Ain this case you will be lose your data.=A0

=0A=0A-- Thanks
=0A=0ASam Jas=0A=0A

--- On Tue, 3/11/09, Tom Lane <tgl [at] sss.pgh.pa.us> wrote:

From: Tom Lane <tgl [at] sss.pgh.pa.us>
Subject: Re: [ADMIN] Please Help... Service fails to start
To: "Hengky Lie" <hengkyliwandouw [at] gmail.com>
Cc: pgsql-admin [at] postgresql.org
Date: Tuesday, 3 November, 2009, 3:37 AM

Hengky Lie <hengkyliwandouw [at] gmail.com> writes:
> 2009-11-02 10:13:35 FATAL:=A0 could not access status of transaction=A0=

> 139856778
> 2009-11-02 10:13:35 DETAIL:=A0 Could not read from file "pg_clog/0085"=A0=

> at offset 98304: Permission denied.

You need to fix that "Permission denied" problem.=A0 Either the file
really is marked as not readable by the postgres user, or (probably
more likely on Windows) you have some malfunctioning "antivirus"
software installed.

=A0=A0=A0 =A0=A0=A0 =A0=A0=A0 regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
=0A=0A=0A Connect more, do more and share more with Yahoo! India Mail.=
Learn more. http://in.overview.mail.yahoo.com/
--0-302245818-1257230896=:49193
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;"><meta http-equiv=3D"Content-Type" content=3D"=
text/html; charset=3Dutf-8"><meta name=3D"ProgId" content=3D"Word.Document"=
><meta name=3D"Generator" content=3D"Microsoft Word 12"><meta name=3D"Origi=
nator" content=3D"Microsoft Word 12"><link rel=3D"File-List" href=3D"file:/=
//C:%5CDOCUME%7E1%5CRAMANA%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml clip1%5C01%5Ccl=
ip_filelist.xml"><link rel=3D"themeData" href=3D"file:///C:%5CDOCUME%7E1%5C=
RAMANA%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_th emedata.thmx"><=
link rel=3D"colorSchemeMapping" href=3D"file:///C:%5CDOCUME%7E1%5CRAMANA%7E=
1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorscheme mapping.xml"><!=
--[if gte mso 9]><xml>=0A <w:WordDocument>=0A <w:View>Normal</w:View>=0A =
<w:Zoom>0</w:Zoom>=0A <w:TrackMoves/>=0A <w:TrackFormatting/>=0A <w:Punc=
tuationKerning/>=0A <w:ValidateAgainstSchemas/>=0A <w:SaveIfXMLInvalid>fa=
lse</w:SaveIfXMLInvalid>=0A <w:IgnoreMixedContent>false</w:IgnoreMixedCont=
ent>=0A <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>=
=0A <w:DoNotPromoteQF/>=0A <w:LidThemeOther>EN-US</w:LidThemeOther>=0A <=
w:LidThemeAsian>X-NONE</w:LidThemeAsian>=0A <w:LidThemeComplexScript>X-NON=
E</w:LidThemeComplexScript>=0A <w:Compatibility>=0A <w:BreakWrappedTable=
s/>=0A <w:SnapToGridInCell/>=0A <w:WrapTextWithPunct/>=0A <w:UseAsian=
BreakRules/>=0A <w:DontGrowAutofit/>=0A <w:SplitPgBreakAndParaMark/>=0A=
<w:DontVertAlignCellWithSp/>=0A <w:DontBreakConstrainedForcedTables/>=
=0A <w:DontVertAlignInTxbx/>=0A <w:Word11KerningPairs/>=0A <w:CachedC=
olBalance/>=0A </w:Compatibility>=0A <w:BrowserLevel>MicrosoftInternetExp=
lorer4</w:BrowserLevel>=0A <m:mathPr>=0A <m:mathFont m:val=3D"Cambria Ma=
th"/>=0A <m:brkBin m:val=3D"before"/>=0A <m:brkBinSub m:val=3D"--"/=
>=0A <m:smallFrac m:val=3D"off"/>=0A <m:dispDef/>=0A <m:lMargin m:val=
=3D"0"/>=0A <m:rMargin m:val=3D"0"/>=0A <m:defJc m:val=3D"centerGroup"/=
>=0A <m:wrapIndent m:val=3D"1440"/>=0A <m:intLim m:val=3D"subSup"/>=0A =
<m:naryLim m:val=3D"undOvr"/>=0A </m:mathPr></w:WordDocument>=0A</xml><!=
[endif]--><style>=0A=0A</style>=0A=0A<p class=3D"MsoNormal">>> 2009-11-02 10:13:=
35 FATAL: could not access status of=0Atransaction 139856778<br>=
=0A<span style=3D""> </span>2009-11-02 10:13:35 DETAIL: Could=0A=
not read from file "pg_clog/0085" at offset 98304: Permission=0Adenie=
d.</p>=0A=0A<br>=0A=0A=0A=0A<p class=3D"MsoNormal"> I faced this error=
before a week only. Fortunately=0Awe have a valid backup and we restored t=
he file (0085) in pg_clog directory. In=0Aour case it is the corruption iss=
ue. <span style=3D""> </span>Kindly=0Acheck with permission and also u=
nder the /usr/local/pgsql/data/pg_clog directory whether=0Athe file (0085) =
is there or not ? If it is not there than try to reload it from=0Athe backu=
p. At last you can touch the file and restart the database. However,=0Ain t=
his case you will be lose your data. <span style=3D""><br></span></p>=
<p class=3D"MsoNormal"><span style=3D""><br></span></p>=0A=0A<p class=3D"Ms=
oNormal"><o:p>-- </o:p>Thanks <br></p>=0A=0A<p class=3D"MsoNormal">Sam Jas<=
/p>=0A=0A<br><br><br><br><br><br><br>--- On <b>Tue, 3/11/09, Tom Lane <i>&l=
t;tgl [at] sss.pgh.pa.us></i></b> wrote:<br><blockquote style=3D"border-left:=
2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From=
: Tom Lane <tgl [at] sss.pgh.pa.us><br>Subject: Re: [ADMIN] Please Help...=
Service fails to start<br>To: "Hengky Lie" <hengkyliwandouw [at] gmail.com&g=
t;<br>Cc: pgsql-admin [at] postgresql.org<br>Date: Tuesday, 3 November, 2009, 3:=
37 AM<br><br><div class=3D"plainMail">Hengky Lie <<a ymailto=3D"mailto:h=
engkyliwandouw [at] gmail.com" href=3D"/mc/compose?to=3Dhengkyliwandouw [at] gmail.co=
m">hengkyliwandouw [at] gmail.com</a>> writes:<br>> 2009-11-02 10:13:35 FA=
TAL: could not access status of transaction <br>> 139856778<=
br>> 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog=
/0085" <br>> at offset 98304: Permission denied.<br><br>You need t=
o fix that "Permission denied" problem. Either the file<br>really is =
marked as
not readable by the postgres user, or (probably<br>more likely on Windows)=
you have some malfunctioning "antivirus"<br>software installed.<br><br>&nb=
sp; regards, tom lane<br>=
<br>-- <br>Sent via pgsql-admin mailing list (<a ymailto=3D"mailto:pgsql-ad=
min [at] postgresql.org" href=3D"/mc/compose?to=3Dpgsql-admin [at] postgresql.org">pg=
sql-admin [at] postgresql.org</a>)<br>To make changes to your subscription:<br><=
a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank"=
>http://www.postgresql.org/mailpref/pgsql-admin</a><br></div></blockquote><=
/td></tr></table><br>=0A <hr size=3D1></hr> Yahoo! India has a=
new look. <a href=3D"http://in.rd.yahoo.com/tagline_metro_2/*http://in.yah=
oo.com/trynew" target=3D"_blank"> Take a sneak peek</a>.
--0-302245818-1257230896=:49193--

Sam Jas [ Di, 03 November 2009 07:48 ] [ ID #2021451 ]

Re: Please Help... Service fails to start

--Apple-Mail-3--245955035
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

What exactly file pg_clog/0085 exactly is ? Thank you for any advice.
Now i'm trying to check file permission and antivirus.

On Nov 3, 2009, at 2:48 PM, Sam Jas wrote:

> >> 2009-11-02 10:13:35 FATAL: could not access status of
> transaction 139856778
> 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/
> 0085" at offset 98304: Permission denied.
>
>
> I faced this error before a week only. Fortunately we have a valid
> backup and we restored the file (0085) in pg_clog directory. In our
> case it is the corruption issue. Kindly check with permission and
> also under the /usr/local/pgsql/data/pg_clog directory whether the
> file (0085) is there or not ? If it is not there than try to reload
> it from the backup. At last you can touch the file and restart the
> database. However, in this case you will be lose your data.
>
>
>
> -- Thanks
>
> Sam Jas
>
>
>
>
>
>
>
>
> --- On Tue, 3/11/09, Tom Lane <tgl [at] sss.pgh.pa.us> wrote:
>
> From: Tom Lane <tgl [at] sss.pgh.pa.us>
> Subject: Re: [ADMIN] Please Help... Service fails to start
> To: "Hengky Lie" <hengkyliwandouw [at] gmail.com>
> Cc: pgsql-admin [at] postgresql.org
> Date: Tuesday, 3 November, 2009, 3:37 AM
>
> Hengky Lie <hengkyliwandouw [at] gmail.com> writes:
> > 2009-11-02 10:13:35 FATAL: could not access status of transaction
> > 139856778
> > 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/0085"
> > at offset 98304: Permission denied.
>
> You need to fix that "Permission denied" problem. Either the file
> really is marked as not readable by the postgres user, or (probably
> more likely on Windows) you have some malfunctioning "antivirus"
> software installed.
>
> regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> Yahoo! India has a new look. Take a sneak peek.

--Apple-Mail-3--245955035
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; "><div>What exactly file =
pg_clog/0085 exactly is ? Thank you for any advice. Now i'm trying to =
check file permission and =
antivirus.</div><div><br></div><div><br></div><div><br><div><div>On Nov =
3, 2009, at 2:48 PM, Sam Jas wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><span =
class=3D"Apple-style-span" style=3D"border-collapse: separate; color: =
rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: =
normal; font-variant: normal; font-weight: normal; letter-spacing: =
normal; line-height: normal; orphans: 2; text-align: auto; text-indent: =
0px; text-transform: none; white-space: normal; widows: 2; word-spacing: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "><div><table cellspacing=3D"0" =
cellpadding=3D"0" border=3D"0"><tbody><tr><td valign=3D"top" =
style=3D"font: inherit; "><p class=3D"MsoNormal" style=3D"margin-top: =
0in; margin-right: 0in; margin-bottom: 10pt; margin-left: 0in; =
line-height: 17px; font-size: 11pt; font-family: Calibri, sans-serif; =
">>> 2009-11-02 10:13:35 FATAL: could not access status of =
transaction 139856778<br><span> </span>2009-11-02 10:13:35 =
DETAIL: Could not read from file "pg_clog/0085" at offset =
98304: Permission denied.</p><br><p class=3D"MsoNormal" =
style=3D"margin-top: 0in; margin-right: 0in; margin-bottom: 10pt; =
margin-left: 0in; line-height: 17px; font-size: 11pt; font-family: =
Calibri, sans-serif; "> I faced this error before a week only. =
Fortunately we have a valid backup and we restored the file (0085) in =
pg_clog directory. In our case it is the corruption issue.<span =
class=3D"Apple-converted-space"> </span><span> </span>Kindly =
check with permission and also under the /usr/local/pgsql/data/pg_clog =
directory whether the file (0085) is there or not ? If it is not there =
than try to reload it from the backup. At last you can touch the file =
and restart the database. However, in this case you will be lose your =
data. <span =
class=3D"Apple-converted-space"> </span><span><br></span></p><p =
class=3D"MsoNormal" style=3D"margin-top: 0in; margin-right: 0in; =
margin-bottom: 10pt; margin-left: 0in; line-height: 17px; font-size: =
11pt; font-family: Calibri, sans-serif; "><span><br></span></p><p =
class=3D"MsoNormal" style=3D"margin-top: 0in; margin-right: 0in; =
margin-bottom: 10pt; margin-left: 0in; line-height: 17px; font-size: =
11pt; font-family: Calibri, sans-serif; "><o:p>--<span =
class=3D"Apple-converted-space"> </span></o:p>Thanks<span =
class=3D"Apple-converted-space"> </span><br></p><p =
class=3D"MsoNormal" style=3D"margin-top: 0in; margin-right: 0in; =
margin-bottom: 10pt; margin-left: 0in; line-height: 17px; font-size: =
11pt; font-family: Calibri, sans-serif; ">Sam =
Jas</p><br><br><br><br><br><br><br>--- On<span =
class=3D"Apple-converted-space"> </span><b>Tue, 3/11/09, Tom =
Lane<span class=3D"Apple-converted-space"> </span><i><<a =
href=3D"mailto:tgl [at] sss.pgh.pa.us">tgl [at] sss.pgh.pa.us</a>></i></b><span =
class=3D"Apple-converted-space"> </span>wrote:<br><blockquote =
style=3D"border-left-width: 2px; border-left-style: solid; =
border-left-color: rgb(16, 16, 255); margin-left: 5px; padding-left: =
5px; "><br>From: Tom Lane <<a =
href=3D"mailto:tgl [at] sss.pgh.pa.us">tgl [at] sss.pgh.pa.us</a>><br>Subject: =
Re: [ADMIN] Please Help... Service fails to start<br>To: "Hengky Lie" =
<<a =
href=3D"mailto:hengkyliwandouw [at] gmail.com">hengkyliwandouw [at] gm ail.com</a>>=
;<br>Cc:<span class=3D"Apple-converted-space"> </span><a =
href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postg resql.org</a><=
br>Date: Tuesday, 3 November, 2009, 3:37 AM<br><br><div =
class=3D"plainMail">Hengky Lie <<a =
ymailto=3D"mailto:hengkyliwandouw [at] gmail.com" =
href=3D"/mc/compose?to=3Dhengkyliwandouw [at] gmail.com">hengkyli wandouw [at] gmail.=
com</a>> writes:<br>> 2009-11-02 10:13:35 FATAL: could not =
access status of transaction <span =
class=3D"Apple-converted-space"> </span><br>> 139856778<br>> =
2009-11-02 10:13:35 DETAIL: Could not read from file =
"pg_clog/0085" <span =
class=3D"Apple-converted-space"> </span><br>> at offset 98304: =
Permission denied.<br><br>You need to fix that "Permission denied" =
problem. Either the file<br>really is marked as not readable by =
the postgres user, or (probably<br>more likely on Windows) you have some =
malfunctioning "antivirus"<br>software =
installed.<br><br> =
regards, tom lane<br><br>--<span =
class=3D"Apple-converted-space"> </span><br>Sent via pgsql-admin =
mailing list (<a ymailto=3D"mailto:pgsql-admin [at] postgresql.org" =
href=3D"/mc/compose?to=3Dpgsql-admin [at] postgresql.org">pgsql-a dmin [at] postgresq=
l.org</a>)<br>To make changes to your subscription:<br><a =
href=3D"http://www.postgresql.org/mailpref/pgsql-admin" =
target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-a dmin</a><br></=
div></blockquote></td></tr></tbody></table><br><hr size=3D"1">Yahoo! =
India has a new look.<span class=3D"Apple-converted-space"> </span><a=
=
href=3D"http://in.rd.yahoo.com/tagline_metro_2/*http://in.ya hoo.com/trynew=
" target=3D"_blank">Take a sneak =
peek</a>.</div></span></blockquote></div><br></div></body></html>=

--Apple-Mail-3--245955035--

Hengky Lie [ Di, 03 November 2009 08:41 ] [ ID #2021452 ]

Re: Please Help... Service fails to start

--0015176f115cd1609d04777b7581
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie <hengkyliwandouw [at] gmail.com>wrote:

> What exactly file pg_clog/0085 exactly is ? Thank you for any advice. Now
> i'm trying to check file permission and antivirus.
>

pg_clog contains the commit log. Once things in pg_xlog have been committed
to disk when the background writer gets around to it. They get marked
committed in pg_clog.

Note that often broken antivirus programs will still cause problems if
they're simply disabled. The real answer is to uninstall them (and hope
they don't leave any broken system dlls behind to still cause problems).

A database server should be so far from things that can give it viruses that
anti-virus software should be uneeded.

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

<div class=3D"gmail_quote">On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie <spa=
n dir=3D"ltr"><<a href=3D"mailto:hengkyliwandouw [at] gmail.com">hengkyliwand=
ouw [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" st=
yle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex=
; padding-left: 1ex;">
<div style=3D""><div>What exactly file pg_clog/0085 exactly is ? Thank you =
for any advice. Now i'm trying to check file permission and antivirus.<=
/div></div></blockquote></div><br>pg_clog contains the commit log.=A0 Once =
things in pg_xlog have been committed to disk when the background writer ge=
ts around to it.=A0 They get marked committed in pg_clog.=A0 <br>
<br>Note that often broken antivirus programs will still cause problems if =
they're simply disabled.=A0 The real answer is to uninstall them (and h=
ope they don't leave any broken system dlls behind to still cause probl=
ems).<br>
<br>A database server should be so far from things that can give it viruses=
that anti-virus software should be uneeded.<br>

--0015176f115cd1609d04777b7581--

Scott Marlowe [ Di, 03 November 2009 19:14 ] [ ID #2021458 ]

Re: Please Help... Service fails to start

--Apple-Mail-1--182515442
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

Dear friends,

At last i can solved the problem by running CHKDSK. This program found
bad allocation unit on pg_clog folder. After repairing, service can
start again.

Thank you for your advice. I really appreciate it.

Regards,

Hengky

On Nov 4, 2009, at 2:14 AM, Scott Marlowe wrote:

> On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie
> <hengkyliwandouw [at] gmail.com> wrote:
> What exactly file pg_clog/0085 exactly is ? Thank you for any
> advice. Now i'm trying to check file permission and antivirus.
>
> pg_clog contains the commit log. Once things in pg_xlog have been
> committed to disk when the background writer gets around to it.
> They get marked committed in pg_clog.
>
> Note that often broken antivirus programs will still cause problems
> if they're simply disabled. The real answer is to uninstall them
> (and hope they don't leave any broken system dlls behind to still
> cause problems).
>
> A database server should be so far from things that can give it
> viruses that anti-virus software should be uneeded.

--Apple-Mail-1--182515442
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; ">Dear =
friends,<div><br></div><div>At last i can solved the problem by running =
CHKDSK. This program found bad allocation unit on pg_clog folder. After =
repairing, service can start again.</div><div><br></div><div>Thank you =
for your advice. I really appreciate =
it.</div><div><br></div><div>Regards,</div><div><br></div><div>Hengky =
;</div><div><br></div><div><br><div><div>On Nov 4, 2009, at 2:14 AM, =
Scott Marlowe wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><div =
class=3D"gmail_quote">On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie <span =
dir=3D"ltr"><<a =
href=3D"mailto:hengkyliwandouw [at] gmail.com">hengkyliwandouw [at] gm ail.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 style=3D""><div>What exactly file pg_clog/0085 exactly is ? =
Thank you for any advice. Now i'm trying to check file permission and =
antivirus.</div></div></blockquote></div><br>pg_clog contains the commit =
log. Once things in pg_xlog have been committed to disk when the =
background writer gets around to it. They get marked committed in =
pg_clog. <br> <br>Note that often broken antivirus programs will =
still cause problems if they're simply disabled. The real answer =
is to uninstall them (and hope they don't leave any broken system dlls =
behind to still cause problems).<br> <br>A database server should be so =
far from things that can give it viruses that anti-virus software should =
be uneeded.<br></blockquote></div><br></div></body></html>=

--Apple-Mail-1--182515442--

Hengky Lie [ Mi, 04 November 2009 02:19 ] [ ID #2021622 ]