Обсуждение: corrupted tables !!!
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have big problems with my postgres. There is a table that gets corrupted frecuently !!! (every week ...) I have to drop the table and create it again using the backup copy. (normally i lose some data) Can it gets corrupted bucause of bad usage of transactions (ie. transactions not committed or rollbacked) ?? And an intensive usage of restrictions, foreign keys, etc... ??? Thanks !! - -- Fernando Moyano Frase del día: - -------------- Linux es aburrido... con Windows nunca sabes cuándo se va a colgar. (*) SymeX ==> http://symex.lantik.com (*) WDBIL ==> http://wdbil.sourceforge.net (*) Informate sobre LINUX en http://www.linux.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7D8EQoZaf9MvtDvcRArX0AKCmj7oqUaWsKi4245SKqeUEU2/QvwCcDY1L sn48O86W3DRkSbnXJeqB/5U= =XHJm -----END PGP SIGNATURE-----
"J.Fernando Moyano" <txinete@wanadoo.es> writes:
> I have big problems with my postgres.
> There is a table that gets corrupted frecuently !!! (every week ...)
This isn't much information. What version of Postgres are you running?
(If your answer isn't "7.0.3" or "7.1.2", the first thing I'm going to
tell you to do is upgrade.) What sort of corruption are you seeing ---
I want exact details, not hypotheses about what's causing it. Are there
any unexpected messages in the postmaster log? Do you see any server
crashes (backend coredumps), and if so can you provide a debugger
backtrace from the core file?
regards, tom lane
Hi, What kind of a corruption? Do you lose data? As far as I tested; bas transactions do not destroy db. With regards, Devrim "J.Fernando Moyano" <txinete@wanadoo.es> wrote in message news:01052610432703.01848@txino.mikasa.eh... > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > I have big problems with my postgres. > There is a table that gets corrupted frecuently !!! (every week ...) > I have to drop the table and create it again using the backup copy. (normally > i lose some data) > > Can it gets corrupted bucause of bad usage of transactions (ie. transactions > not committed or rollbacked) ?? > > And an intensive usage of restrictions, foreign keys, etc... ??? > > Thanks !! > > > - -- > Fernando Moyano > > Frase del d�a: > - -------------- > Linux es aburrido... con Windows nunca sabes cu�ndo se va a colgar. > > (*) SymeX ==> http://symex.lantik.com > (*) WDBIL ==> http://wdbil.sourceforge.net > (*) Informate sobre LINUX en http://www.linux.org > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.4 (GNU/Linux) > Comment: For info see http://www.gnupg.org > > iD8DBQE7D8EQoZaf9MvtDvcRArX0AKCmj7oqUaWsKi4245SKqeUEU2/QvwCcDY1L > sn48O86W3DRkSbnXJeqB/5U= > =XHJm > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)