Postgres Pro
Downloads
Home   >   mailing lists

Thread: corrupted tables !!!

corrupted tables !!!

From
"J.Fernando Moyano"
Date:
-----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-----

Re: corrupted tables !!!

From
Tom Lane
Date:
"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

Ynt: corrupted tables !!!

From
"Madness"
Date:
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)