Обсуждение: loosing data in postgres database

Поиск
Список
Период
Сортировка

loosing data in postgres database

От
victor katemana
Дата:
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 /> 

Re: loosing data in postgres database

От
Filip Rembiałkowski
Дата:
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?


Re: loosing data in postgres database

От
Piotr Czekalski
Дата:
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