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 > Losing data
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 16 Topic 15862 of 17437
Post > Topic >>

Losing data

by garry@[EMAIL PROTECTED] (Garry Saddington) Jun 19, 2008 at 04:55 PM

I have had a serious loss of data and wondered if anyone could shed any
light 
on what may have happened.
My users have been writing re****ts on students. No error messages have
been 
produced and when called back up the re****ts seem to be present at the
time 
of writing. However, next day they have disappeared, and they do not
appear 
in a pg_dump. They seem to have been kept in memory and never written to 
disk.
We are using Zope and connecting to Postgres through psycopg on Centos 5.
I suspect a hard disk failure but any other ideas would be welcome.
Would these re****ts be in the WAL?
regards
garry

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




 16 Posts in Topic:
Losing data
garry@[EMAIL PROTECTED]   2008-06-19 16:55:41 
Re: Losing data
jd@[EMAIL PROTECTED] (&q  2008-06-19 08:55:40 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-19 17:38:53 
Re: Losing data
ahodgson@[EMAIL PROTECTED  2008-06-19 10:15:43 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-19 19:06:38 
Re: Losing data
lists@[EMAIL PROTECTED]   2008-06-19 13:58:23 
Re: Losing data
tgl@[EMAIL PROTECTED] (T  2008-06-20 00:49:13 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-20 07:41:42 
Re: Losing data
scott.marlowe@[EMAIL PROT  2008-06-19 11:09:09 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-19 19:08:36 
Re: Losing data
wmoran@[EMAIL PROTECTED]   2008-06-19 13:10:19 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-19 19:00:12 
Re: Losing data
tgl@[EMAIL PROTECTED] (T  2008-06-19 14:20:26 
Re: Losing data
jd@[EMAIL PROTECTED] (&q  2008-06-19 11:03:10 
Re: Losing data
garry@[EMAIL PROTECTED]   2008-06-19 20:29:57 
Re: Losing data
jd@[EMAIL PROTECTED] (&q  2008-06-19 15:15:06 

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 15:51:38 CST 2008.