Thread: loosing data in postgres database

hi everyone, i have a problem of loosing data in my postgres database whenever i restart my machine what could be the
possibleproblem help me out?<br /> 

2011/1/24 victor katemana <developervickatg@gmail.com>:
> hi everyone, i have a problem of loosing data in my postgres database
> whenever i restart my machine what could be the possible problem help me
> out?

can you please adjust your question to this
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems


How exactly do you insert data? maybe there is a BEGIN but no COMMIT?
How exactly dou you verify that it does not exist?

W dniu 2011-01-24 10:37, victor katemana pisze:
> hi everyone, i have a problem of loosing data in my postgres database 
> whenever i restart my machine what could be the possible problem help 
> me out?
A plenty of reasons is possible, starting from uncommited transactions 
on shutdown till invalid fsync method or hardware problem (i.e. failed 
accu on Adaptec HW raid cache).
Some more information is required to study your case, at least OS / 
config / hardware info.

Regards,

P.

P.S. It sounds more likely being a topic to the administrator's list 
than PL/PGSQL list.

-- 

--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB&  eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289