pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedloosing data in postgres database
3+ messages / 3 participants
[nested] [flat]
* loosing data in postgres database
@ 2011-01-24 09:37 victor katemana <developervickatg@gmail.com>
2011-01-24 09:49 ` Re: loosing data in postgres database Filip Rembiałkowski <plk.zuber@gmail.com>
2011-01-24 09:51 ` Re: loosing data in postgres database Piotr Czekalski <pczekalski@techbaza.pl>
0 siblings, 2 replies; 3+ messages in thread
From: victor katemana @ 2011-01-24 09:37 UTC (permalink / raw)
To: pgsql-sql
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: loosing data in postgres database
2011-01-24 09:37 loosing data in postgres database victor katemana <developervickatg@gmail.com>
@ 2011-01-24 09:49 ` Filip Rembiałkowski <plk.zuber@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Filip Rembiałkowski @ 2011-01-24 09:49 UTC (permalink / raw)
To: victor katemana <developervickatg@gmail.com>; +Cc: pgsql-sql
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: loosing data in postgres database
2011-01-24 09:37 loosing data in postgres database victor katemana <developervickatg@gmail.com>
@ 2011-01-24 09:51 ` Piotr Czekalski <pczekalski@techbaza.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Piotr Czekalski @ 2011-01-24 09:51 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-01-24 09:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-01-24 09:37 loosing data in postgres database victor katemana <developervickatg@gmail.com>
2011-01-24 09:49 ` Filip Rembiałkowski <plk.zuber@gmail.com>
2011-01-24 09:51 ` Piotr Czekalski <pczekalski@techbaza.pl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox