Re: is there a psql equivilent of fsck?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ben wrote:
> We recently installed and populated a new postgres 7.3 server, which was
> quickly abused with a good 12 hours of 115-degree heat. Now, we see
> ~1000 rows missing from a single table, and given our application, a
> delete of those rows seems a very remote possibility. Is there some
> database analogy to fsck I can run?
>
> FWIW the hardware raid claims everything is just fine.

If you are missing 1000 rows, you deleted your data , you had
transaction wrap or your hardware is toast. If your hardware as toast
there would be a lot of other issues cropping up.

Why are you installing a "new" postgres 7.3 server. It isn't even
officially supported anymore.

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGwJ/2ATb/zqfZUUQRArcUAKCPdiqmdLpPHoOvCiT3jI7MKjDQuACfRTVc
FIqCsdmwlos9DqMpMHgnNmA=
=1GPV
-----END PGP SIGNATURE-----