Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Failing to ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15716 of 17437
Post > Topic >>

Re: Failing to recover after panic shutdown

by magnus@[EMAIL PROTECTED] (Magnus Hagander) Jun 3, 2008 at 03:47 PM

Per Lauv=C3=A5s wrote:
> Hi
>=20
> I am running Postgres 8.2 on Windows 2003 server SP2.
>=20
> Every now and then (2-3 times a year) our Postgres service is down
> and we need to manually start it. This is what we find:
>=20
> In log when going down:
> 2008-06-02 13:40:02 PANIC:  could not open file
> "pg_xlog/000000010000001C00000081" (log file 28, segment 129):
> Invalid argument

Are you by any chance running an antivirus or other "security software"
on this server?

> We are archiving WAL-segments at a remote machine, and we are copying
> non-filled WAL-segments every 10 minutes to be able to rebuild the DB
> with a maximum of 10 minutes of missing data. (I don't know if that
> has anything to do with it).

How are you copying these files? Are you saying you're actually copying
the files out of the pg_xlog directory, or are you using the
archive_command along with archive_timeout?

//Magnus

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Re: Failing to recover after panic shutdown
magnus@[EMAIL PROTECTED]   2008-06-03 15:47:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:09:58 CST 2008.